2009/5/15 Dmitry Yemanov <dimitr@...>

>
>
>
> >> Thanks for running the script, Dmitry. But I just ran it again to be
> sure,
> >> still the result is 6 index reads on ExcludedFile with v2.1.2 but 2
> index
> >> reads with v2.0.3.
>
> I was testing on Windows, this somewhat confirms my guess stated above.
>
> Actually I just tried this on Windows, and got the same result as yours.
>
> A short answer is that there's no predefined evaluation order for
> predicates in Firebird. In fact, this depends on the compiler used to
> build the FB binaries. So what you observe is not really a bug, but
> rather a side effect of some implementation detail. It's going to be
> fixed in v2.5 though, at least to work similarly in all environments,
> i.e. always from left to right (no promises for the smart re-ordering of
> predicates yet).
>
> Just try to understand a bit more here, could you elaborate more here about
> the from left to right and smart re-ordering.
>



> Thanks
> Huan
>



> Dmitry
>
>
>

[Non-text portions of this message have been removed]