Hi, if I insert the NULL value in CHECK constraint with IN the SQL generated
don't take in consideration the NULL value.
ALTER TABLE MyTable ADD CONSTRAINT CkMyTable_CODE CHECK(CODE IN(NULL,
In Enterprise Manager / Table / Check the sql generated by the check don't
test the NULL with IS but with the equal.
The result is that I can insert EVERY value in my CODE column.
This is a very malicious bug and in my opinion there are two solutions:
1) accept the null in CHECK(IN ... clause but the sql generated must take in
consideration the ...