RE: [sqlite] CHECK constraints

[Drew, Stephen]

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]>