> 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
-- -- Original Message -- -- From: Niall Litchfield To: jkstill@(protected) Cc: gints.plivna@(protected) ; oracle-l Sent: Thursday, July 13, 2006 10:31 PM Subject: Re: Smells like oracle bug?
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=Content-Type content="text/html; charset=iso-8859-1"> <META content="MSHTML 6.00.2900.2912" name=GENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=#ffffff> <DIV><FONT face=Arial size=2>Hi,</FONT></DIV> <DIV><FONT face=Arial size=2></FONT> </DIV> <DIV> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt; mso-layout-grid-align: none"><SPAN lang=EN-US style="mso-ansi-language: EN-US">> You cannot (or at least shouldn't be able to) provide a hint to an access path that <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt; mso-layout-grid-align: none"><SPAN lang=EN-US style="mso-ansi-language: EN-US">> gives wrong results.<o:p></o:p></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt; mso-layout-grid-align: none"><SPAN lang=EN-US style="FONT-SIZE: 8pt; FONT-FAMILY: 'Courier New'; mso-ansi-language: EN-US; mso-bidi-font-size: 10.0pt"> <o:p></o:p></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt; mso-layout-grid-align: none"><SPAN lang=EN-US style="mso-ansi-language: EN-US">Conscious or unconscious abuse of hints in a SQL statement may lead only to three kind of results:<BR>- you get some result<BR>- you get no result (see halting problem of Alan Tuning:)<BR>- you get an error<BR>Other behavior (i.e. receiving two different results) is in my opinion a bug.<o:p></o:p></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt; mso-layout-grid-align: none"><SPAN lang=EN-US style="mso-ansi-language: EN-US"> <o:p></o:p></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt; mso-layout-grid-align: none"><SPAN lang=EN-US style="mso-ansi-language: EN-US">Regards<o:p></o:p></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt; mso-layout-grid-align: none"><SPAN lang=EN-US style="mso-ansi-language: EN-US">Jaromir<o:p></o:p></SPAN></P></DIV> <BLOCKQUOTE style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px"> <DIV style="FONT: 10pt arial">-- -- Original Message -- -- </DIV> <DIV style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B> <A title=niall.litchfield@(protected) href="mailto:niall.litchfield@(protected)">Niall Litchfield</A> </DIV> <DIV style="FONT: 10pt arial"><B>To:</B> <A title=jkstill@(protected) href="mailto:jkstill@(protected)">jkstill@(protected)</A> </DIV> <DIV style="FONT: 10pt arial"><B>Cc:</B> <A title=gints.plivna@(protected) href="mailto:gints.plivna@(protected)">gints.plivna@(protected)</A> ; <A title=oracle-l@(protected) href="mailto:oracle-l@(protected)">oracle-l</A > </DIV> <DIV style="FONT: 10pt arial"><B>Sent:</B> Thursday, July 13, 2006 10:31 PM</DIV> <DIV style="FONT: 10pt arial"><B>Subject:</B> Re: Smells like oracle bug?</DIV> <DIV><BR></DIV></BLOCKQUOTE></BODY></HTML>
