Icon View Incident Report

Minor Minor
Reported By: Steve Rasch
Reported On: 3/2/2005
For: Version 4.17 Build 1
# 1989 Cannot 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;



Resolution Resolution
Fixed Problem on 3/2/2005 in version 4.18 build 1
Image