Kbase P24488: Query of data does not show Data in the correct order.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
21/01/2005 |
|
Status: Unverified
SYMPTOM(s):
Query of data does not show Data in the correct order.
Dumped table from test database to production using Data Dictionary.
Query against the same table between two databases result in different order of data.
Table has a primary unique index and 3 other indices.
A comparison of the collation table between the Production and test system show that they are different.
CHANGE:
Dumped and loaded a table
CAUSE:
The dump load process changes the recid for the record, causing the query behavior change.
FIX:
To guarantee the sort order when using a non-unique index is necessary to specify a sort criteria on the query, otherwise the recid order will be used.