home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
14.10.xC11 FixList
12.10.xC16.X5 FixList
11.70.xC9.XB FixList
11.50.xC9.X2 FixList
11.10.xC3.W5 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

Informix - Problem description

Problem IT10309 Status: Closed

THE UPDATE STATISTICS CAUSES WRONG RESULTS IN THE MULTIPLY-TABLE JOIN OF
THE SELECT QUERY WITH MIN() OR MAX() AGGREGATES

product:
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10
Problem description:
The multiply-table join with select query using min() or max() 
aggregates returns wrong result after running UPDATE STATISTICS.
Problem Summary:
**************************************************************** 
* 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                      * 
****************************************************************
Local Fix:


Solution


Problem Fixed In IBM Informix Server 12.10.xC6


Workaround


not known / see Local fix


Timestamps


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

23.07.2015
30.12.2015
30.12.2015


Problem solved at the following versions (IBM BugInfos)


12.10.xC6



Problem solved according to the fixlist(s) of the following version(s)


12.10.xC6

FixList