Subject Re: [Firebird-Architect] ORs in Where statement
Author Jim Starkey
At 06:30 PM 6/12/03 -0300, Daniel Rail wrote:
>Hello Chris,
>
>Thursday, June 12, 2003, 6:02:14 PM, you wrote:
>
>CM> Is Firebird constructed in such a way that when one OR condition is true
>CM> that it doesn't calculate the rest since we already know it can be used?
>
>This has been implemented in FB 1.5. And, you even have the option to
>turn back on the complete boolean evaluation, if you wish. By default,
>it's turned off.


Having just checked the code, I fear you are correct. That's not the
way I wrote it and not the way it should work.

Why is it an option in version 1.5? Why would anyone want or care
about full evaluation? (Other than wanting it to go fast, of course.)

Jim Starkey