Previous Topic

Next Topic

Correct LEFT OUTER JOINS Containing OR Conjunctions in an ON Clause

A query containing an OR conjunction in the ON clause of a left outer join returned incorrect results. Optimizer logic was found to inappropriately apply restrictions to this statement resulting in the incorrect return. This logic as adjusted to properly handle this clause in the case of a left outer join.