INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10

The multiply-table join with select query using min() or max() 
aggregates returns wrong result after running UPDATE STATISTICS.

**************************************************************** 
* USERS AFFECTED:                                              * 
* Users of 12.10.xC1 through 12.10.xC5, as well as users of    * 
* 11.70.xC3 through 11.70.xC8.                                 * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* A query may return incorrect results for simple aggregation  * 
* under the following conditions:                              * 
*   - the same table is referenced at least twice with         * 
* different aliases, e.g., tab1 t1, tab1 t2                    * 
*   - the query contains an aggregation on a column from one   * 
* of the instances of the table, e.g. MIN(t1.c1)               * 
*   - the query plan chosen by the optimizer accesses the      * 
* other instance of the table, e.g. t2, using a keyonly index  * 
* access, and via nested-loop join                             * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Update to IBM Informix Server 12.10.xC6                      * 
****************************************************************

Problem Fixed In IBM Informix Server 12.10.xC6

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

23.07.2015
30.12.2015
30.12.2015

12.10.xC6