|
Problem IT14557
|
Status: Closed |
INCORRECT USAGE OF TABLE EXPRESSIONS CAN LEAD TO AN ASSERT FAIL IN STCMPR WHEN AGGREGATES ARE INVOLVED
|
| product: |
IBM IDS EXPRESS / 5724L2305 / B15 - IDS 11.50 |
| Problem description: |
Where incorrect usage of table expressions might normally lead
to an error like -7607 being returned
(-7607 Invalid row literal value.),
an assert fail, requiring a restart of the database server, can
happen if an aggregate is involved.
The stack looks like this:
(oninit)afstack
(oninit)mt_ex_throw_sig
(oninit)afsig_handler
(oninit)stcmpr
(oninit)chkgrpby
(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)startup
A sample query which would cause such an assert failure:
select all_fields, sum(f1) from (
select f2 from t1 group by 1
) as all_fields, t1
where t1.f2 = all_fields.f2; |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* production envoironment *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Update to IBM Informix Server 11.50.xC10 *
**************************************************************** |
| Local Fix: |
|
| Solution |
|
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 31.03.2016
15.06.2017
15.06.2017 |
| Problem solved at the following versions (IBM BugInfos) |
11.50.xC10
|
| Problem solved according to the fixlist(s) of the following version(s) |
