IC61686: ENGINE CRASH WITH A SELECT IF TABLE NAME IS A DOTTED COLLECTION TYPE (LIST, SET, MULTISET)

APAR status

• Closed as program error.

Error description

• If a table name is one of the following ... set, list or
  multiset (collection types)... then a select statement which
  uses the table name dot column name will crash the engine.  You
  may need to drop the table and re-create it to see the crash.
  The first time through, you will see an error.   examples ...
  
  create table list (name char(5));
  select list.name from list;
  drop table list;
  create table list (name char(5));
  select list.name from list;
  
  The stack is
  
  rcaseshift
  spparse
  parsecmd
  sqcmd
  sq_cmnd
  sq_prepare
  sqmain
  listen_verify
  spawn_thread
  startup + 0xa8
  
  The system does not crash if the sql is changed to "select name
  from list".
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users of IDS 11.50XC4                                        *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Engine Crashes when Collection type keywords are used as a   *
  * table name in a select through a dotted column.              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IDS 11.50.xC5 and above.                          *
  ****************************************************************
  

Problem conclusion

• Problem first fixed in IDS 11.50 XC5.
  

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