|
Problem IT11370
|
Status: Closed |
SELECT STATEMENT WITH A CORRELATED SUBQUERY WITH GROUP BY ROWID CRASHES THE ENGINE
|
| product: |
INFORMIX SERVER / 5725A3900 / B70 - IDS 11.70 |
| Problem description: |
Normally, we cannot include a ROWID in a GROUP BY clause but
with a correlated subquery we can include .rowid in
the group by clause. Instead of -201 syntax error returned, the
database crashes in function group2cb().
Running the following query would crash the server:
create table t1
(
c1 serial not null,
c2 char(20));
select a.c1 from t1 a where a.rowid in (select max(rowid) from
t1 group by a.rowid);
AF stacks as follow:
-15:19:41 Stack for thread: 69 sqlexec
base: 0x0000000058d76000
len: 102400
pc: 0x0000000001317a03
tos: 0x0000000001c2a970
state: running
vp: 8
(oninit) afstack
(oninit) mt_ex_throw_sig
(oninit) afsig_handler
(Linux)
(oninit) group2cb
(oninit) sel2cb
(oninit) subq2cb
(oninit) subq2expr
(oninit) expr2expr
(oninit) buildexpr
(oninit) expr2expr
(oninit) cond2expr
(oninit) sel2cb
(oninit) qblk2cb
(oninit) stmt2cb
(oninit) p_sp2cb
(oninit) parsecmd
(oninit) sqcmd
(oninit) sq_cmnd
(oninit) sq_prepare
(oninit) sqmain
(oninit) spawn_thread
(oninit) th_init_initgls
(oninit) startup
ucontext: 0x0000000001c2af00
siginfo: 0x0000000001c2b030
si_signo: 11 si_code: 1 si_errno: 0 si_pid: 2
si_uid: 0
si_addr: 0x0000000000000002 si_value:
0x0000000000000000 si_fd: 0
15:19:42
15:19:42 IBM Informix Dynamic Server Version 11.70.FC8 Software
Serial Number AAA#B000000
=== End of AF ===
If the sub-query is run directly in dbaccess, err -201 is
returned.
select max(rowid) from t1 group by rowid. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Users having rowid in group by clause inside subquery. *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Update to IBM Informix Server 11.70.xC9 *
**************************************************************** |
| Local Fix: |
|
| Solution |
|
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 22.09.2015
09.06.2017
09.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) |
