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