> > Now, I also seem to remember a Fb 1.5 configuration setting
> > (looking it up)...
> >
> >
> > # ----------------------------
> > # Boolean evaluation method (complete or shortcut)
> > #
> > # If your SQL code depends on side-effects of full evaluation of OR
> > # and AND statements (right-hand-side terms), even if the expressions
> > # final result could be determined by just examining the value of the
> > # first term, you might need to turn this on.
> > #
> > # Type: boolean
> > #
> > #CompleteBooleanEvaluation = 0
> >
> > I wonder if this applies to JOIN conditions as well. Arno?
> >
>
> Hmm, that would be of a great help! I've got many JOIN-conditions, all
> ANDed, and if the first one would evaluate to False, the rest can be
> ignored...

Well, from what I can read in the above blurb, it currently does
NOT do full evaluation.

> However, as it is in firebird.conf, I guess it would apply to all
> databases on this server? Would be great if one could turn it on or off
> per database...

Vulcan ;)

Martijn Tonies
Database Workbench - development tool for Firebird and more!
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com