IBM IDS ENTRP E / 5724L2304 / B15 - IDS 11.50

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".

**************************************************************** 
* 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 first fixed in IDS 11.50 XC5.

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

23.06.2009
21.01.2010
21.01.2010

11.50.0,
11.50.xC5