Reported By: Steve Rasch Reported On: 3/2/2005 For: Version 4.17 Build 1
# 1989Cannot Update a Numeric Column with a NULL Value If a Minimum Value Is Defined for the Column I can't set a NULL in a field with a min value.
drop table if exists TEST;
CREATE TABLE IF NOT EXISTS TEST
(
ID INTEGER NOT NULL,
VALUE INTEGER MIN 1,
PRIMARY KEY ("ID") COMPRESS FULL
LOCALE CODE 0
USER MAJOR VERSION 1
);
insert into TEST values (1, 1); -- OK
insert into TEST values (2, NULL); -- Not ok
select * from TEST;
ResolutionFixed Problem on 3/2/2005 in version 4.18 build 1