On Tue, Jun 21, 2011 at 4:17 AM, Knut Anders Hatlen <firstname.lastname@example.org> wrote:
Derby will stop evaluating the clauses once one evaluates to false. NoteMasood Mortazavi <email@example.com> writes:
> When a Derby "select" executes in the case when "where" is followed by
> multiple conjoined AND clauses, will all the AND clauses be evaluated
> even if the first one is false, in the scan?
however that the optimizer may reorder the AND clauses for efficiency,
so if you code your application to rely on the short-circuiting (for
example if the AND clauses call functions with side effects), the
results may not be what you expect.