INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10

A nested select statement returns a -294: "The column 
column-name must be in the GROUP BY list" even though the column 
is listed in the GROUP BY list.

**************************************************************** 
* USERS AFFECTED:                                              * 
* Users of 12.10.xC2 through 12.10.xC4.                        * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* A query may return -294 error under the following            * 
* conditions:                                                  * 
*  - query contains at least two derived tables, e.g., dt1,    * 
* dt2                                                          * 
*  - each of the derived tables contains in its projection     * 
* list a complex expression with an alias name, e.g. " c1 ||   * 
* c2 as cardkey"                                               * 
*  - the two alias has exactly the same name in the two        * 
* derived tables                                               * 
*  - both derived tables have group-by clause, and the alias   * 
* name "cardkey" appear in both group-by clause in both        * 
* derived tables                                               * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Update to IBM Informix Server 12.10.xC5.                     * 
****************************************************************

Problem Fixed In IBM Informix Server 12.10.xC5.

keiner bekannt / siehe Local-Fix

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

20.02.2015
16.10.2015
16.02.2017

12.10.xC5