Subject Re: [firebird-support] Possible bug with CHECK constraint
Author Martijn Tonies
> How do other db engines handle these cases? If you like, I can check MS
> and Oracle.

btw, Oracle does not allow sub-selects in a CHECK constraint.

It does, however, check existing rows when adding the constraint.

So this fails:

ceate table t
i integer
insert into t (1);
alter table t
add constraint my_check (i < 0);

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Upscene Productions