Subject RE: Re[4]: [Firebird-Architect] ORs in Where statement
Author Claudio Valderrama C.
Daniel Rail wrote:
>
> I think the only side effects possible would be to perform an external
> operation to Firebird(i.e. writing to a text file).

Don't know why someone would want to write that call in an OR condition. I
would rather use

select something, udf(whatever)
from ...

instead of putting the udf(whatever) call in the WHERE or JOIN/ON clause.

Furthermore, there's more logic in FB than simply reading records...
remember that there is extra logic involved when indices can be used. Or do
we want a config param to control the creation of sparse bitmaps?
;-)

C.