IBM Support

IT39842: HIERACHICAL QUERY WITH "ORDER SIBLINGS BY COLA" AND "COLA" NOT IN ITS PROJECTION LIST RETURNS ERROR 9628

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as returned (APAR cannot be resolved without additional info from IBM or customer.)

Error 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.").
    

Local fix

Problem summary

Problem conclusion

Temporary fix

Comments

  • It can't be reproduced. There is a remote chance that some of
    these defect fixes might solve this one. (idsdb00108738,
    idsdb00110072, idsdb00110659 )
    

APAR Information

  • APAR number

    IT39842

  • Reported component name

    INFORMIX SERVER

  • Reported component ID

    5725A3900

  • Reported release

    E10

  • Status

    CLOSED RET

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2022-02-03

  • Closed date

    2023-02-02

  • Last modified date

    2023-02-02

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

Applicable component levels

[{"Business Unit":{"code":"BU053","label":"Cloud \u0026 Data Platform"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"E10"}]

Document Information

Modified date:
02 February 2023