|
Problem IT06257
|
Status: Closed |
JOIN EXPRESSION USING AN SPL CALL IN A STORED PROCEDURE CAN RETURN 9791/110 IN EV_PROCVAR/GETVARDATA |
| product: |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 |
| Problem description: |
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 Summary: |
****************************************************************
* 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: |
|
| Solution |
Problem Fixed In IBM Informix Server 12.10.xC5 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 29.12.2014
16.10.2015
16.10.2015 |
| Problem solved at the following versions (IBM BugInfos) |
12.10.xC5
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 12.10.xC5
|
 |
| 12.10.xC5.W1
|
|
