Re: Smells like oracle bug?

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Thu, 13 Jul 2006 21:31:45 +0100
Message-ID: <7765c8970607131331o4891c539hfee039dd6f5f7846@mail.gmail.com>

On 7/13/06, Jared Still <jkstill_at_gmail.com> wrote:
>
> 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.
>

a classic justification for this being a bug. You cannot (or at least shouldn't be able to) provide a hint to an access path that gives wrong results. Imagine if there were a hint (it would be nice) table_scan (table_name) a writer shouldnt be able to write

select /*+ table_scan(dept) */ empno,ename from emp;

and get a tablescan of dept to answer the query. You want to do that there is always DBMS_ADVANCED_REWRITE! This is the same thing.

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info

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

Received on Thu Jul 13 2006 - 15:31:45 CDT