Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Smells like oracle bug?

Re: Smells like oracle bug?

From: jaromir nemec <jaromir_at_db-nemec.com>
Date: Fri, 14 Jul 2006 00:02:10 +0200
Message-ID: <00dd01c6a6c7$fe10bb90$3c02a8c0@JARAWIN>


Hi,

> You cannot (or at least shouldn't be able to) provide a hint to an access path that

> gives wrong results.
 

Conscious or unconscious abuse of hints in a SQL statement may lead only to three kind of results:

- you get some result
- you get no result (see halting problem of Alan Tuning:)
- you get an error

Other behavior (i.e. receiving two different results) is in my opinion a bug.  

Regards

Jaromir

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Jul 13 2006 - 17:02:10 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US