There is a bug associated with the new HASH GROUP BY operation where
incorrect rows are returned. I don't recall the exact bug details, so it
may or may not apply.
--
Daniel Fink
Oracle Performance, Diagnosis and Training
OptimalDBA http://www.optimaldba.com
Oracle Blog http://optimaldba.blogspot.com
Michael.Coll-Barth_at_VerizonWireless.com wrote:
> All,
>
> I came across a rather strange situation a few days ago. One of our
> developers wrote a simple sql script that inserted some rows into a
> table. However, he was getting things that were not expected. He ran
> just the select portion of the code and got a different number of rows.
> Any thoughts on what it might be or what to search for?
>
> We are running on AIX Version 5.2 with Oracle Database 10g Enterprise
> Edition Release 10.2.0.3.0 - 64bit Production
> With the Partitioning, OLAP and Data Mining options.
>
> Thanks,
> Michael
>
>
> The information contained in this message and any attachment may be
> proprietary, confidential, and privileged or subject to the work
> product doctrine and thus protected from disclosure. If the reader
> of this message is not the intended recipient, or an employee or
> agent responsible for delivering this message to the intended
> recipient, you are hereby notified that any dissemination,
> distribution or copying of this communication is strictly prohibited.
> If you have received this communication in error, please notify me
> immediately by replying to this message and deleting it and all
> copies and backups thereof. Thank you.
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
>
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Oct 19 2007 - 09:35:57 CDT
