When I read Note: 391116.1 with the full list, I noticed the following bugs that we’ve encountered are fixed.
- the ‘hash group by’ bug with incorrect results: bug 4604970
- the listener may hang in RAC: bug 4518443
- ora-600  on multitable join – a problem with histograms described in Note:371333.1 and Bug 5041016
Unfortunately, an important bug in 10.2.0.2 posted on the Sept. 29 is not listed as fixed in this patch list. The bug has to do with both data corruption, and security vulnerabilities when running queries that can be interpreted in multiple ways by the SQL parser — depending on what schema has namespace precedence for your signon. In this regard, I would recommend anyone who is running, for example, a test or development copy of their production schemas on the same database, to read the following metalink note without delay.
Note: 392673.1 Bug 5458753 “SQL can execute in wrong schema”.
Want to talk with an expert? Schedule a call with our team to get the conversation started.
well, look again. It’s on the list
The note sais
“Last Revision Date: 11-OCT-2006 ”
Seems like they added it after I wrote the article :)
I guess that’s why the list is not official yet.
Thanks for the note !