|Subject||Re: [firebird-support] Possible bug with CHECK constraint|
> From: "Ann W. Harrison"Yes, but original question of this thread was whether behaviour of check
> Certainly, constraints work as documented. Equally clearly, they
> don't follow the standard. The 92 standard recognizes two types of
> constraint, immediate and deferrable. ...
constraints containing selects
> CREATE TABLE test_master (is possibly buggy because they do not behave as "expected".
> id INTEGER NOT NULL PRIMARY KEY,
> CHECK(COALESCE((SELECT max(id) FROM test_master), 0) < 10)
So, even if Firebird supported sql92 standard, would that solve
the problem ?