Help - Search - Members - Calendar
Full Version: wrong select result sequence
Oracle DBA Forums > Oracle > Oracle Forum
marco95h
since 10g upgrade, select results are incorrectly sorted. We use the value of a column in the primary key to sort the results. Now, when we insert a record in the middle of the table, let say in position 20, this new record is returned at the end of the select result, even if its value should put it at the 20th position.
The SELECT statement has no clause like "order by" or "sort", just SELECT ... FROM ... WHERE ... EQ

There are only 220 records in this table.

Thanks in advance.
Asma
QUOTE (marco95h @ Jul 8 2008, 02:41 PM) *
since 10g upgrade, select results are incorrectly sorted. We use the value of a column in the primary key to sort the results. Now, when we insert a record in the middle of the table, let say in position 20, this new record is returned at the end of the select result, even if its value should put it at the 20th position.
The SELECT statement has no clause like "order by" or "sort", just SELECT ... FROM ... WHERE ... EQ

There are only 220 records in this table.

Thanks in advance.



>> since 10g upgrade, select results are incorrectly sorted.
>> The SELECT statement has no clause like "order by" or "sort",


your statements are contradictory... explain what is your issue..
HAL9000
"select results are incorrectly sorted."

That's clearly a bug, I would get the patch.

"since 10g upgrade, select results are incorrectly sorted."

Oh, the rows come out in a different order?

Without an ORDER BY or GROUP BY, the row order is unpredictable.

When upgrading to 10g, make sure to carefully do these steps:

http://www.dba-oracle.com/t_slow_performan...ter_upgrade.htm
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2014 Invision Power Services, Inc.