|
Problem IT39842
|
Status: Closed |
HIERACHICAL QUERY WITH "ORDER SIBLINGS BY COLA" AND "COLA" NOT IN ITS PROJECTION LIST RETURNS ERROR 9628
|
| product: |
INFORMIX SERVER / 5725A3900 / E10 - |
| Problem description: |
This behavior actually contradicts the normal "ORDER BY"
statement, which can also be applied to columns when they do
not appear in the SELECT statement (see also
https://www.ibm.com/docs/de/informix-servers/14.10?topic=clause-
ordering-by-column-by-expression
"Informix supports columns and expressions in the ORDER BY
clause that do not appear in the select list of the Projection
clause."). |
| Problem Summary: |
|
| Local Fix: |
|
| Solution |
|
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 03.02.2022
02.02.2023
02.02.2023 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
