RE: [sqlite] CHECK constraints

[Marcus Welz]

PostgreSQL 8.0 will happily insert (5, NULL).


-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, November 02, 2005 6:31 PM
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]>