INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10

The error   "392: SYSTEM ERROR - UNEXPECTED NULL POINTER 
ENCOUNTERED." may occur  on 12.10.FC3XB and 12.10.FC3XE. 
 
A UNION ALL view folding enhancement was included in these 
releases. 
As a result of this enhancement, the UNION ALL gets folded but 
the other part of the view is improperly materialized when there 
is a group by and aggregation in the view definition. This was 
fixed by APAR IT03042. Subsequently it was discovered that when 
the STMT_CACHE is set to 2 in onconfig, the -392 error occurs 
again.

**************************************************************** 
* USERS AFFECTED:                                              * 
* Users of 12.10.xC4.                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* A query may return -392 error under the following            * 
* conditions:                                                  * 
*   - statement cache is turned on in the ONCONFIG file        * 
* (STMT_CACHE 2)                                               * 
*   - query contains two derived tables, DT1, DT2              * 
*   - DT1 contains a UNION ALL and does not contain any group  * 
* by, order by or aggregates                                   * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Update to IDS-12.10.xC5                                      * 
****************************************************************

Problem Fixed In IDS-12.10.xC5

not known / see Local fix

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

28.07.2014
16.10.2015
16.10.2015