|
Problem IT27577
|
Status: Closed |
TRIGGER CALLING A STORED PROCEDURE USING SET PARAMETER CAUSES EXCEPTION IN INSONE_NEXT EXPRESSION EVALUATION
|
| product: |
INFORMIX SERVER / 5725A3900 / B70 - IDS 11.70 |
| Problem description: |
In a complex environment an insert trigger is defined on a table
in order to
track changes on the base table for change logging reasons in
another history
table. If the base table had a SET column and the trigger
processing the insert
is calling another SP which handleS the SET in the parameter
list, a subsequent
call of the insert operation causes an assertion failure with
the following stack:
(oninit)afstack
(oninit)afhandler
(oninit)affail_interface
(oninit)mt_ex_throw_sig@AF11_4
(oninit)afsig_handler
(oninit)new_eval
(oninit)new_eval
(oninit)insone_next
(oninit)doinsert
(oninit)aud_doinsert
(oninit)excommand
(oninit)IPRA.$ip_evalsql
(oninit)runproc
(oninit)udrlm_spl_execute
(oninit)udrlm_exec_routine
(oninit)udr_execute
(oninit)exroutine
(oninit)execproc
(oninit)aud_execproc
(oninit)excommand
(oninit)dotrigs
(oninit)ferafttrig
(oninit)dodmlrow
(oninit)dodelupd
(oninit)aud_dodelupd
(oninit)excommand
(oninit)IPRA.$ip_evalsql
(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 |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Users of IDS versions prior to 11.70.xC10. *
****************************************************************
* PROBLEM DESCRIPTION: *
* TRIGGER CALLING A STORED PROCEDURE USING SET PARAMETER *
* CAUSES EXCEPTION IN INSONE_NEXT EXPRESSION EVALUATION *
****************************************************************
* RECOMMENDATION: *
* Fixed in IDS 11.70.xC10 if and when it becomes available. *
* If this fix is required, contact Informix Technical Support. *
**************************************************************** |
| Local Fix: |
|
| Solution |
|
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 26.12.2018
26.10.2019
26.10.2019 |
| Problem solved at the following versions (IBM BugInfos) |
11.70.xC10
|
| Problem solved according to the fixlist(s) of the following version(s) |
