Informix - Problem description
Problem IT27756 | Status: Closed |
UPDATE STATISTICS ON DATABASE WITH TRIGGER PRODEDRE WITH TRIGGERREFERENCE CAN LEAD TO ASSER FAILED IN COL2EXPR | |
product: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problem description: | |
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 Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of IDS prior to 12.10.xC13. * **************************************************************** * PROBLEM DESCRIPTION: * * Update Statistics caused assert failure on 12.10.FC12AEE. * **************************************************************** * RECOMMENDATION: * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 14.01.2019 26.09.2019 26.09.2019 |
Problem solved at the following versions (IBM BugInfos) | |
12.10.xC13 | |
Problem solved according to the fixlist(s) of the following version(s) |