Home

Problem IT01868	Status: Closed
"ORDER BY" DOES NOT WORK IF COLUMN_ALIAS IN PROJECTION CLAUSE IS SAME CHARACTER STRING AS COLUMN NAME
product:
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10
Problem description:
When you use column_alias in projection clause and it is same character string as column name, "order by" does not work if you specify column_alias in "order by" clause.
Problem Summary:
**************************************************************** * USERS AFFECTED: * * users using XA transactions with stored procedures * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to 12.10.xC5 or earlier PID if available * ****************************************************************
Local Fix:
Workaround is that you use select_number in "order by" clause.
Solution

Workaround
not known / see Local fix
Timestamps
Date - problem reported : Date - problem closed : Date - last modified :	19.05.2014 16.10.2015 16.10.2015
Problem solved at the following versions (IBM BugInfos)
12.10.xC5
Problem solved according to the fixlist(s) of the following version(s)
12.10.xC4.W1
12.10.xC5
12.10.xC5.W1