Icon View Incident Report

Minor Minor
Reported By: Unknown
Reported On: 5/9/2004
For: Version 4.05 Build 1
# 1692 Cannot Specify Negative Numbers in Default, Min, or Max Values in an SQL CREATE TABLE SQL Statement

If you have a integer field and you want to set it default value <0 e.g. -1 will cause a error:

create table tb_test(
 fn_count integer default -1

Comments Comments and Workarounds
The workaround is to include the -1 in quotes like this '-1'.

Resolution Resolution
Fixed Problem on 5/12/2004 in version 4.06 build 1