| Latest versions | fixlist |
| 14.10.xC10 |
 |
| 12.10.xC16.X5 |
|
| 11.70.xC9.XB |
|
| 11.50.xC9.X2 |
|
| 11.10.xC3.W5 |
|
| Have problems? - contact us. | |
| Register for free |
|
| Contact form |
|
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) | |
