Oracle 9.2 CREATE TABLE ex1( x INTEGER, y NUMBER(21,18), CHECK( x<y ) );
INSERT succeeds. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 02 November 2005 23:31 To: sqlite-users@sqlite.org Subject: [sqlite] CHECK constraints In a CHECK constraint, if the expression is NULL (neither true nor false) does the constraint fail? Example: CREATE TABLE ex1( x INTEGER, y REAL, CHECK( x<y ) ); Then you do: INSERT INTO ex1 VALUES(5, NULL); Does the check constraint fail or not? Or do different database engines do different things? I need to know so that I can make check constraint in SQLite work like they do in other database engines... -- D. Richard Hipp <[EMAIL PROTECTED]>