Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle Bug? SQL not returning correct rows.
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