RE: Smells like oracle bug?

From: Mercadante, Thomas F \(LABOR\) <Thomas.Mercadante_at_labor.state.ny.us>
Date: Thu, 13 Jul 2006 14:50:30 -0400
Message-ID: <ABB9D76E187C5146AB5683F5A07336FF681403@EXCNYSM0A1AJ.nysemail.nyenet>

Another reason to never use hints!

---

This transmission may contain confidential, proprietary, or privileged information which is intended solely for use by the individual or entity to whom it is addressed. If you are not the intended recipient, you are hereby notified that any disclosure, dissemination, copying or distribution of this transmission or its attachments is strictly prohibited. In addition, unauthorized access to this transmission may violate federal or State law, including the Electronic Communications Privacy Act of 1985. If you have received this transmission in error, please notify the sender immediately by return e-mail and delete the transmission and its attachments.

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Gints Plivna Sent: Thursday, July 13, 2006 2:49 PM
Cc: oracle-l
Subject: Re: Smells like oracle bug?

retrying because of overquoting.

Unfortunately in my specially created example I of course can do that, but original query hasn't any hints and without them chose the access path that led to incorrect results. I of course can give some hint(-s) to force another access path, but this is somehow very unpleasing :(

Gints

2006/7/13, Jared Still <jkstill_at_gmail.com>:
> It appears that Oracle is taking your hint quite seriously.
>
> As there is no data in idx2 due to the only value in the
> id2 column being null, Oracle is not returning any rows.
>
> Take idx2 out of the hint, and you get data.

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

Received on Thu Jul 13 2006 - 13:50:30 CDT