Informix - Problembeschreibung
Problem IT27756 | Status: Geschlossen |
UPDATE STATISTICS ON DATABASE WITH TRIGGER PRODEDRE WITH TRIGGERREFERENCE CAN LEAD TO ASSER FAILED IN COL2EXPR | |
Produkt: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problembeschreibung: | |
An An UPDATE STATISTICS on database with a trigger procedure with trigger reference can lead to AF with a stack like col2expr dotted2expr expr2expr elist2arg common_routine2expr expr2expr bldtabtrigs bldtrigs itbldquery itcallbldquery itbldroot sqoptim ip_sqloptim cmp_stmt pr_compile aud_pr_compile updprocstat excommand sq_execute Example: create procedure p1() ..... end procedure; create trigger t1 insert on tab1 ....; create trigger t2 update of tab2 execute procedure p1( ); insert into tab1 (....); | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * Users of IDS prior to 12.10.xC13. * **************************************************************** * PROBLEM DESCRIPTION: * * Update Statistics caused assert failure on 12.10.FC12AEE. * **************************************************************** * RECOMMENDATION: * **************************************************************** | |
Local-Fix: | |
Lösung | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 14.01.2019 26.09.2019 26.09.2019 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
12.10.xC13 | |
Problem behoben lt. FixList in der Version |