Informix - Problem description
Problem IT10878 | Status: Closed |
ANSI JOIN WITH ROW EXPRESSION SEGVS IN CHECKEXPR | |
product: | |
INFORMIX SERVER / 5725A3900 / B70 - IDS 11.70 | |
Problem description: | |
reported on comp.databases.informix select trim(systables.owner) owner, trim(systables.tabname) tabname, trim(sysconstraints.constrname) constrname, sysindexes.part1, sysindexes.part2, sysindexes.part3, sysindexes.part4, sysindexes.part5, sysindexes.part6, sysindexes.part7, sysindexes.part8, sysindexes.part9, sysindexes.part10, sysindexes.part11, sysindexes.part12, sysindexes.part13, sysindexes.part14, sysindexes.part15, sysindexes.part16 from sysconstraints join systables on sysconstraints.tabid = systables.tabid join sysindexes on row (sysconstraints.owner, sysconstraints.idxname) = row (sysindexes.owner, sysindexes.idxname) order by sysconstraints.owner asc, systables.tabname asc, sysconstraints.constrname asc segvs with (oninit) afstack (oninit) mt_ex_throw_sig (oninit) afsig_handler (Linux) <signal frame> (oninit) checkexpr (oninit) checkexpr (oninit) checkexpr (oninit) checkexpr (oninit) checkexpr (oninit) tlp2tnode (oninit) tbl2tab (oninit) sel2cb (oninit) qblk2cb (oninit) stmt2cb (oninit) p_sp2cb (oninit) parsecmd (oninit) sqcmd (oninit) sq_cmnd (oninit) sq_prepare (oninit) sqmain (oninit) spawn_thread | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users using unnamed ROW types in predicates * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to 11.70.xC9 or earlier PID if available * **************************************************************** | |
Local Fix: | |
Avoiding either row clauses or ansi joins is a valid workaround. | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 24.08.2015 10.06.2017 10.06.2017 |
Problem solved at the following versions (IBM BugInfos) | |
11.70.xC9 | |
Problem solved according to the fixlist(s) of the following version(s) |