home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
15.0.xC1.2 FixList
14.10.xC13.3 FixList
12.10.xC16.X5 FixList
11.70.xC9.XB FixList
11.50.xC9.X2 FixList
11.10.xC3.W5 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

Informix - Problembeschreibung

Problem IT03042 Status: Geschlossen

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

Produkt:
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10
Problembeschreibung:
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-Zusammenfassung:
**************************************************************** 
* 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:
Lösung
Problem Fixed In IDS-12.10.xC5
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
09.07.2014
16.10.2015
16.10.2015
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
12.10.xC4.W1 FixList
12.10.xC5 FixList
12.10.xC5.W1 FixList