Subject Re: [Firebird-Architect] ORs in Where statement
Author Helen Borrie
At 02:02 PM 12/06/2003 -0700, you wrote:
>Is Firebird constructed in such a way that when one OR condition is true
>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?

It's a matter of implementation. By tradition, InterBase and Firebird OR
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.