home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
14.10.xC12 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 IT06676 Status: Geschlossen

EQUAL EXPRESSION USING A SPL CALL IN A WHERE CLAUSE IN A STORED PROCEDURE
CAN RETURN 9791/110 IN EV_PROCVAR/GETVARDATA

Produkt:
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10
Problembeschreibung:
When a select in a stored procedure is using an expression like 
 
    let mnewklass  = (select a.klass from ccontract a 
--> here 
                       where 
a.number==vklgetccont(VKL_CR_CONTRACT,'L') 
                         and ncontract==VKL_CR_CONTRACT); 
 
where a stored procedure is called on the right hand side of an 
equal expression, 
the server can return 9791 / -110 to the session and write an 
assert failure file with the following 
stack: 
 
oninit :: var_unset_err 
oninit :: getvardata 
oninit :: geval 
oninit :: routine_evalargs 
oninit :: exroutine 
oninit :: multiexcmp 
oninit :: geval 
oninit :: ev_geval2 
oninit :: new_eval 
oninit :: readidx_new 
oninit :: gettupl 
oninit :: scan_next 
oninit :: getrow 
oninit :: fetchrow 
oninit :: doselect 
oninit :: exsubq 
oninit :: ev_cb 
oninit :: new_eval 
oninit :: ip_evalexpr 
oninit :: runproc 
oninit :: udrlm_spl_execute 
oninit :: udrlm_exec_routine 
oninit :: udr_execute 
oninit :: udr_spl_curnext 
oninit :: ip_curnext 
oninit :: ip_fetch 
oninit :: getrow 
oninit :: fetchrow 
oninit :: exfetch 
oninit :: sql_nfetch 
oninit :: sq_nfetch 
oninit :: sqmain 
oninit :: listen_verify 
oninit :: spawn_thread 
oninit :: th_init_initgls 
oninit :: startup
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* Iterative stored procedure used inside the query             * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Update to IBM Informix Server 12.10                          * 
****************************************************************
Local-Fix:
Lösung
Problem Fixed In IBM Informix Server 12.10
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
22.01.2015
16.10.2015
16.10.2015
Problem behoben ab folgender Versionen (IBM BugInfos)
12.10.0
Problem behoben lt. FixList in der Version
12.10.xC5 FixList
12.10.xC5.W1 FixList