IC68386: SELECT WITH "FOR UPDATE OF COLUMN" AGAINST A VIEW WHEN COLUMN IS RESULT OF A FUNCTION EXPRESSION CRASHES THE ENGINE

APAR status

• Closed as program error.

Error description

• The server crashes with the following stack trace:
  
  mapcolgroupby()
  process_select()
  process_view_colltbl_expr()
  processview()
  foldviews()
  sqbind()
  sq_common_bind()
  sq_bind()
  sqmain()
  listen_verify()
  spawn_thread()
  startup()
  
  The esql/c app was trying to prepare a cursor with a select
  statement that used the for update of column_name syntax as an
  alternative to declaring a update cursor.
  
  The test case view is defined as the following:
  
  create table jr_basetab (col1 char(20), col2 int);
  
  create view jr_view (hld_info, col2) as
          select
  jr_func(x0.col1,USER,'hld_info','col1')::char(25),x0.col2
          from jr_basetab x0;
  
  Then the select that is trying to get prepared in the esql/c app
  is as follows:
  select hld_info from jr_view where col2 = ? for update of
  hld_info
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * IDS 9.40 and above                                           *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * A query statement with "FOR UPDATE OF <column>" clause       *
  * against a view where the column doesn't map directly to the  *
  * base table column (i.e. casting, UDR, etc) causes server to  *
  * SEGV.                                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to 11.50.xC8 when available.                         *
  ****************************************************************
  

Problem conclusion

• The problem is first fixed in IDS 11.50.xC8.
  

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 PSY

     UP