Re: sql question

From article <27sqfjINNrch@emory.mathcs.emory.edu>, by jgordon@ssf-sys.dhl.com (Jim Gordon): > > What are people out there expecting 1=2 and 1=1 to do? Consider the > case where 1=2 is one filter amongst many, part of a complex where > clause which has many OR's and AND's. > It should evaluate constant subexpressions at optimization time, not row-by-row. I don't see how making the clause more complex changes the nature of the problem, unless you are maintaining that the optimizer, in addition to not optimizing the trivial case of invariant filters, is also baffled by multiple conditions.