|
Problem IT32447
|
Status: Closed |
A QUERY WITH JOIN AND UNION WHICH USES SAME ALIAS ON PROJECTION LIST GIVES 26088 ERROR
|
| product: |
INFORMIX SERVER / 5725A3900 / E10 - |
| Problem description: |
A query like:
SELECT e.col1 , e.col2
FROM table_e AS e
INNER JOIN
(
SELECT i.col1 AS col1
FROM table_t t, table_a i
WHERE t.invoice = i.invoice
AND i.period_end = "10/15/2017"
UNION
SELECT i.col1 AS col1
FROM table_t t, table_a i
WHERE t.invoice = i.invoice
AND i.period_end = "10/31/2017"
) AS t
ON e.col1 = t.col1
Throws:
26088: A CTE must have a non-recursive sub-query and at most one
recursive sub-query.
trapping the error
19:11:28 Stack for thread: 284 sqlexec
base: 0x0000000048539000
len: 102400
pc: 0x00000000014e501d
tos: 0x000000004854e9c0
state: running
vp: 8
0x00000000014e501d (oninit) afstack
0x00000000014e9d5d (oninit) afhandler
0x00000000014ea372 (oninit) affail_interface
0x0000000000f12f40 (oninit) check_traperror
0x0000000000797631 (oninit) sqerr
0x00000000006aa1b4 (oninit) union2cb
0x00000000006a96fe (oninit) union2cb
0x00000000006ad965 (oninit) unionsubq2cb
0x00000000006e7c59 (oninit) usubq2expr
0x00000000006e84ad (oninit) collsubq2expr.isra.24
0x00000000006f5d31 (oninit) expr2expr
0x00000000006d676a (oninit) tlgetcolltab
0x00000000006d8c3f (oninit) tlgetddtab_trace
0x00000000006d8fe8 (oninit) spgettab
0x00000000006d92ba (oninit) tlp2tnode
0x00000000006da1ac (oninit) tbl2tab
0x00000000006a7cdd (oninit) sel2cb
0x00000000006acf11 (oninit) qblk2cb
0x00000000006c0fac (oninit) stmt2cb
0x00000000006c3d9d (oninit) p_sp2cb
0x0000000000ade335 (oninit) parsecmd
0x0000000000adea13 (oninit) sqcmd
0x0000000000adf09d (oninit) sq_prepare
0x0000000000bc655e (oninit) sqmain
0x0000000001613a7a (oninit) spawn_thread
0x00000000014d5cf2 (oninit) th_init_initgls
0x000000000151c00f (oninit) startup |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Users of Informix Server prior to 14.10.xC4. *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Update to Informix Server 14.10.xC4. *
**************************************************************** |
| Local Fix: |
|
| Solution |
|
| Workaround |
****************************************************************
* USERS AFFECTED: *
* Users of Informix Server prior to 14.10.xC4. *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Update to Informix Server 14.10.xC4. *
**************************************************************** |
| Comment |
Fixed in Informix Server 14.10.xC4. |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 03.04.2020
09.06.2020
09.06.2020 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
