|
Problem IT06257
|
Status: Geschlossen |
JOIN EXPRESSION USING AN SPL CALL 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
where a.clnum == mnumber
and a.ncontract == b.ncontract
-- here
and b.number ==
vklgetccont(a.ncontract,"L")
and b.subacc[1,24] == c.acclsc
and c.dateclos > mtoday
and a.tstatus != 1
where a Stored procedure is called on the right hand side of a
join
the server can return 9791 / -110 to the session and write an
assert failure file with the following
stack
(oninit)afstack
(oninit)afhandler
(oninit)affail_interface
(oninit)mt_ex_throw_sig@AF11_4
(oninit)afsig_handler
(oninit)getvardata
(*nosymtab*)0x700000050046280
(oninit)ev_procvar
(oninit)new_eval
(oninit)readidx_new
(oninit)gettupl
(oninit)scan_next
(oninit)inner_next
(oninit)join_next
(oninit)merge_next
(oninit)sort_open
(oninit)prepselect
(oninit)open_cursor
(oninit)ip_scurstart
(oninit)ip_evalcursor
(oninit)runproc
(oninit)udrlm_spl_execute
(oninit)udrlm_exec_routine
(oninit)udr_execute
(oninit)exroutine
(oninit)execproc
(oninit)aud_execproc
(oninit)excommand
(oninit)sq_execute
(oninit)sqmain
(oninit)listen_verify
(oninit)spawn_thread
(oninit)th_init_initgls
(oninit)startup |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* select in a stored procedure is using an iterative function *
* in where clause *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Update to IBM Informix Server 12.10.xC5 *
**************************************************************** |
| Local-Fix: |
|
| Lösung |
Problem Fixed In IBM Informix Server 12.10.xC5 |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 29.12.2014
16.10.2015
16.10.2015 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
12.10.xC5
|
| Problem behoben lt. FixList in der Version |
| 12.10.xC5
|
 |
| 12.10.xC5.W1
|
|
