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

Home -> Community -> Usenet -> c.d.o.server -> Re: here is another oracle 10g's bug?

Re: here is another oracle 10g's bug?

From: Havel Zhang <havel.zhang_at_gmail.com>
Date: Wed, 20 Jun 2007 19:11:29 -0700
Message-ID: <1182391889.851166.252950@n2g2000hse.googlegroups.com>


On 6 21 , 12 48 , "Vladimir M. Zakharychev" <vladimir.zakharyc..._at_gmail.com> wrote:
> On Jun 20, 3:20 pm, Havel Zhang <havel.zh..._at_gmail.com> wrote:
>
>
>
>
>
> > On 6 20 , 6 10 , "Vladimir M. Zakharychev"
>
> > The explain on 10g as follows:
> > ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
> > | Id | Operation |
> > Name | Rows | Bytes |
> > TempSpc| Cost (%CPU)|
> > ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
> > | 0 | INSERT STATEMENT
> > | | 72276
> > | 13M| | 826K (1)|
> > | 1 | TABLE ACCESS BY INDEX ROWID|
> > STORE_PRODUCT | 1 | 74 |
> > | 3 (0)|
> > | 2 | NESTED LOOPS
> > | | 72276
> > | 13M| | 826K (1)|
> > | 3 | HASH JOIN
> > | | 72276 |
> > 8681K| 7136K| 609K (2)|
> > | 4 | TABLE ACCESS FULL |
> > DAY_DEBIT_NE_MARGIN_GROCERY | 72276 | 6281K| | 236 (1)|
> > | 5 | TABLE ACCESS FULL |...
>
> Well, the plan above says that the insert will process exactly 72276
> rows, which is what you expect. The plan for 9i doesn't seem to be
> right. Are you sure you didn't exchange 10g and 9i plans?
>
> And if you just select, not insert as select, then both releases
> return correct results with and without the index? If so, then it's
> definitely a bug: a query should always return the same result set
> given the same data and predicates, regardless if it's used as data
> source for an insert operation or not.
>
> Regards,
> Vladimir M. Zakharychev
> N-Networks, makers of Dynamic PSP(tm)
> http://www.dynamicpsp.com- -
>
> - -

hi Vladimir

    I'm sure I haven't exchange two plans. and i tried again. I think its Oracle's Bug.

       Thank you for your help:)

Havel Zhang Received on Wed Jun 20 2007 - 21:11:29 CDT

Original text of this message

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