[sqlite] CHECK constraints

[drh]

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