RE: Wrong results. 10053 event help

I wonder if this was caused by the "common subquery elimination" bug. See metalink note 137430.1

At 04:31 PM 4/17/2003 -0800, you wrote:
>I am using cursor_sharing=exact.
>Well after bringing the database upto 8.1.7.4.10 the problem has gone.
>
>
> > -----Original Message-----
> > From: Jesse, Rich [mailto:Rich.Jesse_at_qtiworld.com]
> > Sent: Thursday, April 17, 2003 2:57 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: RE: Wrong results. 10053 event help
> >
> >
> > Are you using CURSOR_SHARING=FORCE? There's a bug fixed in
> > 8.1.7.3 or 8.1.7.4 just like this if this is the case. The
> > workaround is to set CURSOR_SHARING=EXACT for the query in
> > question. The solution is to patch.
> >
> >
> > Rich
> >
> > Rich Jesse System/Database Administrator
> > rich.jesse_at_qtiworld.com Quad/Tech International,
> > Sussex, WI USA
> >
> >
> > -----Original Message-----
> > Sent: Thursday, April 17, 2003 2:47 PM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > Well I am very lucky today.
> >
> > After cloning a 8.1.7 db I found a query would return diff
> > results with and without cbo or by changing the sequence of
> > expr in the where clause. Can anyone help me understand the
> > 10053 trace output before apply 8.1.7.4 patch and remove this bug.
> >
> > Case 1: with cbo and all analyzed, return zero rows. Wrong
> > Result. SELECT "USER_OR_TEAM_ID",
> > "ID_TYPE",
> > "ITEM_TYPE",
> > "ITEM1_ID",
> > "ITEM2_ID",
> > "ITEM3_ID",
> > "ITEM4_ID",
> > "ITEM5_ID",
> > "ITEM6_ID",
> > "PRV",
> > "GRANT_DENY_FLAG"
> > FROM acl
> > WHERE (
> > (id_type = 1 AND user_or_team_id IN (SELECT user_id FROM
> > my_user_id))
> > or
> > (id_type = 2 AND user_or_team_id IN (SELECT team_id FROM
> > my_team))
> > )
> >

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Wolfgang Breitling
  INET: breitliw_at_centrexcc.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).