suche 36x36
  • Admin-Scout-small-Banner
           

    CURSOR Admin-Scout

    das ultimative Tool für Informix

    pfeil  
Neueste VersionenFixList
14.10.xC10 FixList
12.10.xC16.X5 FixList
11.70.xC9.XB FixList
11.50.xC9.X2 FixList
11.10.xC3.W5 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

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
Informix EditionenInformix Editionen
Informix Editionen
DokumentationDokumentation
Dokumentation
IBM NewsletterIBM Newsletter
IBM Newsletter
Current BugsCurrent Bugs
Current Bugs
Bug ResearchBug Research
Bug Research
Bug FixlistsBug Fixlists
Bug Fixlists
Release NotesRelease Notes
Release Notes
Machine NotesMachine Notes
Machine Notes
Release NewsRelease News
Release News
Product LifecycleProduct Lifecycle
Lifecycle
Media DownloadMedia Download
Media Download