Subject | Re: [Firebird-Architect] ORs in Where statement |
---|---|
Author | Helen Borrie |
Post date | 2003-06-12T23:00:40Z |
At 02:02 PM 12/06/2003 -0700, you wrote:
evaluation exits as soon as a True condition is found.
In Fb 1.5 it's still the default behaviour, but you can configure the
server so that it always does a full evaluation. Uncomment the
CompleteBooleanEvaluation key in firebird.conf and set it to 1.
Helen
>Is Firebird constructed in such a way that when one OR condition is trueIt's a matter of implementation. By tradition, InterBase and Firebird OR
>that it doesn't calculate the rest since we already know it can be used?
>
>such as if i have a
>
>where thisvalue = 1 or thisvalue =2
>
>if my value is 1 then it never checks to see if my value equal 2 because i'm
>already good to go.
>
>or does this type of thing not work like this within an SQL database?
evaluation exits as soon as a True condition is found.
In Fb 1.5 it's still the default behaviour, but you can configure the
server so that it always does a full evaluation. Uncomment the
CompleteBooleanEvaluation key in firebird.conf and set it to 1.
Helen