IC71973: AN ASSERT FAIL CAN BE OBSERVED WITH A SELECT FROM A DERIVED TABLE.

APAR status

• Closed as program error.

Error description

• Here is an example:
  
  select (select * from table(sp(b)))
  from   (select * from test);
  
  where 'sp' is a stored procedure, 'test' is a table, and 'b' is
  one of the table columns.
  
  
  The stack in the AF file may look like this:
  
  afstack
  mt_ex_throw_sig
  afsig_handler
  rdatavalChar
  valload
  geval
  routine_evalargs
  udr_evalcurs
  ip_evalprchead
  ip_open
  itscan_open
  prepselect
  subqprep
  exsubq
  ev_cb
  new_eval
  evalcols
  getrow
  fetchrow
  exfetch
  sql_nfetch
  sq_nfetch
  sqmain
  spawn_thread
  startup
  
  Please note, you may see another function instead of
  'rdatavalChar', depending on the data type being used in the
  stored procedure.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users having table function with correlated column reference *
  * to a Derived table/View                                      *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * When user query has table function ( or iterator function)   *
  * with correlated column referring to a derived table, server  *
  * may give crash during subquery execution.                    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to 11.50.xC9.                                        *
  ****************************************************************
  

Problem conclusion

• Fixed in 11.50.xC9.
  

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 ENTRP E

• Fixed component ID

  5724L2304

Applicable component levels

• RB15 PSN

     UP