Subject Re: [Firebird-Architect] Nulls in CHECK Constraints
Author Martijn Tonies
From: "Dmitry Yemanov" <dimitr@...>
> "Martijn Tonies" <m.tonies@...> wrote:
> >
> > Might be, but given that our CHECKs are only evaluated on insert/update
> > (and not even on DELETE), could make them useless in certain occasions
> > when referring to other tables.
> As per SQL spec, all existing constraints must be checked at the end of
> SQL statement. So DELETE shouldn't behave differently, IMHO.

There's something to fix then :-)

With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Upscene Productions
Database development questions? Check the forum!