|
Problem IT13692
|
Status: Closed |
VARIATIONS OF SUCH QUERY: SELECT COL1 C1, COL2 FROM TEST GROUP BY C1, 1, 2 CRASHES ENGINE
|
| product: |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 |
| Problem description: |
Variations of the query
select col1 c1, col2 from test group by c1, 1, 2;
can crash the engine.
dbaccess session may return:
172: ISAM error: Unexpected internal error
And engine crashes with following stack:
(oninit) afstack
(oninit) mt_ex_throw_sig
(oninit) afsig_handler
(Linux)
(oninit) ev_colret_int
(oninit) new_eval
(oninit) next_row
(oninit) get_first_row_from_producer
(oninit) hash_process_all_groups
(oninit) group_open
(oninit) prepselect
(oninit) open_cursor
(oninit) sql_open
(oninit) sq_open
(oninit) sqmain
(oninit) spawn_thread
(oninit) th_init_initgls
(oninit) startup |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* select with group by on column alias specified as a *
* duplicate *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Update to IBM Informix Server 12.10.xC7 *
**************************************************************** |
| Local Fix: |
Work around: Rewrite the query so that there is no repetition in
the 'group by' parameter list.
Please refer to the SQL syntax guide for further help. |
| Solution |
|
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 09.02.2016
28.06.2016
28.06.2016 |
| Problem solved at the following versions (IBM BugInfos) |
12.10.xC7
|
| Problem solved according to the fixlist(s) of the following version(s) |
