IT14557: INCORRECT USAGE OF TABLE EXPRESSIONS CAN LEAD TO AN ASSERT FAIL IN STCMPR WHEN AGGREGATES ARE INVOLVED

APAR status

• Closed as program error.

Error 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;
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * production envoironment                                      *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Update to IBM Informix Server 11.50.xC10                     *
  ****************************************************************
  

Problem conclusion

• Problem Fixed In IBM Informix Server 11.50.xC10
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  IBM IDS EXPRESS

• Fixed component ID

  5724L2305

Applicable component levels

• RB15 PSN

     UP