Kbase P122957: What is the order of records retrieved using a constant value as BY clause?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/16/2008 |
|
Status: Unverified
GOAL:
What is the order of records retrieved using a constant value as BY clause?
GOAL:
What sorting is used when the BY clause does not mention a field name?
FACT(s) (Environment):
Progress 9.x
OpenEdge 10.x
FIX:
The BY expression is evaluated when sorting the results of the query. If a constant value is used, then the same value is used to compare each record against another, as if using a field with the same value for all records. In this case the sort order is meaningless.
When the BY clause does not provide a meaningful sorting order, the resulting order of records is unspecified.