RE: Wrong Results - Bad Execution Plan

Thanks for the update. I just ran counts of the "wrong results" bug fixes in all patchsets from 9.2.0.2 to 10.2.0.4 and 10.2.0.4 is the highest by far with 180! So, I think it's not just our imagination that the software is getting buggier as complexity increases (this was discussed in another thread recently). Maybe Oracle will get to the point some day of offering a stripped down version for all of us that don't need the extra functionality and just want reliability and consistency. Well, I guess we do still have the option of running 8.1.7.4 since it's under Lifetime Sustaining Support :-)

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Henry Poras

There are a number of bugs listed in metalink associated with this feature (just search on _optimizer_filter_pred_pullup).

Privileged/Confidential Information may be contained in this message or attachments hereto. Please advise immediately if you or your employer do not consent to Internet email for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of this company shall be understood as neither given nor endorsed by it.

--
http://www.freelists.org/webpage/oracle-l