Subject Re: [Firebird-Architect] Re: Nulls in CHECK Constraints
Author Ann W. Harrison
Dmitry Yemanov wrote:
> OK. We also have a bugreport that check constraints should perform in the
> system context, i.e. work as "dirty read" (like our PK and FK behave). I
> don't have a clue how it corresponds to the SQL spec.

We should run all constraints in system context - that's the only
way to get reliable answers unless you restrict your checks to the
current row. And I think the spec is in favor of constraints that
result in correct results.. (BTW, the decision to run constraints
as triggers in user context happened after my watch and before
Firebird, she says, playing the blame game.)