|
Problem IT27577
|
Status: Geschlossen |
TRIGGER CALLING A STORED PROCEDURE USING SET PARAMETER CAUSES EXCEPTION IN INSONE_NEXT EXPRESSION EVALUATION
|
| Produkt: |
INFORMIX SERVER / 5725A3900 / B70 - IDS 11.70 |
| Problembeschreibung: |
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-Zusammenfassung: |
****************************************************************
* 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: |
|
| Lösung |
|
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 26.12.2018
26.10.2019
26.10.2019 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
11.70.xC10
|
| Problem behoben lt. FixList in der Version |
