Subject | Re: [Firebird-Architect] Nulls in CHECK Constraints |
---|---|
Author | Dmitry Yemanov |
Post date | 2005-10-26T09:36:54Z |
"paulruizendaal" <pnr@...> wrote:
condition> is not False for any row of
a table". And Unknown is not False.
line of thinking.
Dmitry
>The Firebird behaviour violates the standard.
> What are the opinions about this?
> What does the standard say?"A table check constraint is satisfied if and only if the specified <search
condition> is not False for any row of
a table". And Unknown is not False.
> What do other databases implement?PostgreSQL and MSSQL are standard compliant, i.e. they follow the Oracle's
line of thinking.
Dmitry