Subject Re: [Firebird-Architect] ORs in Where statement
Author Ann W. Harrison
At 05:38 PM 6/12/2003 -0400, Jim Starkey wrote:
>At 02:02 PM 6/12/03 -0700, Chris Meelhuysen 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?
>
>
>In general, of course.

It was, and now is again. In the interim, it occurred to someone
that the evaluation of a boolean might have side-effects that
altered the state of the database, so full evaluation was done
even after the result was determined.


Regards,

Ann
www.ibphoenix.com
We have answers.