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 IT02702 Status: Geschlossen

A SELECT STATEMENT FROM A VIEW WITH A SUBSELECT RETURNS ERROR -392

Produkt:
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10
Problembeschreibung:
Running a select against a view that has a correlated subquery 
and IFX_FOLDVIEW is enabled (default), might fail with error 
-392 
 
    392: System error - unexpected null pointer encountered. 
  Error in line 1 
  Near character position 52 
 
With a trap enabled for error -392, the following stack is 
observed: 
 
 11:07:30  Stack for thread: 3037 sqlexec 
 
 oninit :: afstack 
 oninit :: afhandler 
 oninit :: affail_interface 
 oninit :: check_traperror 
 oninit :: sqerr 
 oninit :: opcsqp 
 oninit :: op_opinit 
 oninit :: sqoptim 
 oninit :: bldstructs 
 oninit :: sqcmd 
 oninit :: sq_cmnd 
 oninit :: sq_prepare 
 oninit :: sqmain 
 oninit :: listen_verify 
 oninit :: spawn_thread 
 oninit :: th_init_initgls 
 oninit :: startup
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All users                                                    * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Update to IDS-12.10.xC5                                      * 
****************************************************************
Local-Fix:
If you disable IFX_FOLDVIEW so the view cannot be folded / 
merged into the optimized query or you remove the views 
subquery, the select runs successfully.
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:
20.06.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