Icon View Incident Report

Serious Serious
Reported By: Richard Harding/Ole WillyTuv
Reported On: 2/27/2007
For: Version 1.00 Build 1
# 2241 NULL Column Values Are Causing Check Constraints to Fail

The check constraint expression (Sex >= 'F' AND Sex <= 'M') evaluates to UNKNOWN for null values in the Sex column, yet ElevateDB will still raise a constraint exception. It seems that the current implementation of the CHECK constraint in ElevateDB is incorrect.

Comments Comments
The ANSI/ISO standard dictates that check constraints only be considered failed if the check constraint expression is False, not True or Unknown.

Resolution Resolution
Fixed Problem on 2/28/2007 in version 1.01 build 1

Products Affected Products Affected
ElevateDB Additional Software and Utilities
ElevateDB VCL Client-Server
ElevateDB VCL Client-Server with Source
ElevateDB VCL Standard
ElevateDB VCL Standard with Source
ElevateDB VCL Trial