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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle Bug? SQL not returning correct rows.

Re: Oracle Bug? SQL not returning correct rows.

From: <zugzug21_at_gmail.com>
Date: 13 Feb 2007 11:45:49 -0800
Message-ID: <1171395947.426525.266080@v45g2000cwv.googlegroups.com>


Ed,

I re-ran the query with ROWID and for each row that appears to be a duplicate it has the same ROWID. According to the info I found from Anurag's suggestions this defaintely appears to be a bug.

Thanks for the help,
Ryan

>
> Sorry, I was too quick while trying to keep it simple. Just try
> something in place of * that will uniquely identify the source row, in
> fact, ROWID would be a good choice.
>
> Then if the results show the same rowid for the duplicates, then it
> may be a bug. But if the results show different rows with duplicate
> bill_of_lading values, then you know the problem is in the select.
> (IOW, something was not the same between query 1 and query 3)
>
> HTH,
> ed
Received on Tue Feb 13 2007 - 13:45:49 CST

Original text of this message

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