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 IT03042 Status: Closed

-392 error in complex ANSI JOIN query when it includes a UNION ALL view and
another view with group by and aggregation.

product:
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10
Problem description:
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 the fixes for two other defect fixes 
and 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.
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* Users of 12.10.xC4                                           * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* A query may return -392 error under the following            * 
* conditions:                                                  * 
*   - at least two views are involved, one UNION ALL view, and * 
* another view which contains group by and aggregation in its  * 
* definition                                                   * 
*   - the UNION ALL view is folded into the main query (i.e.   * 
* no temp table creation)                                      * 
*   - the other view with group by and aggregation is          * 
* materialized into a temp table                               * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Update to IDS-12.10.xC5                                      * 
****************************************************************
Local Fix:
Solution
Problem Fixed In IDS-12.10.xC5
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
09.07.2014
16.10.2015
16.10.2015
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)
12.10.xC4.W1 FixList
12.10.xC5 FixList
12.10.xC5.W1 FixList