Reported By: Richard Harding/Ole WillyTuv Reported On: 2/27/2007 For: Version 1.00 Build 1
# 2241NULL 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.
CommentsThe ANSI/ISO standard dictates that check constraints only be considered failed if the check constraint expression is False, not True or Unknown.
ResolutionFixed Problem on 2/28/2007 in version 1.01 build 1
Products AffectedElevateDB 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