Informix - Problem description
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) |