DB2 FOR LUW / DB2FORLUW / 910 - DB2

When a SQL/XML or XQuery query uses nested LET/FOR, it may cause 
the db2 instance crash. 
The stack trace looks like: 
ossDumpStackTrace 
OSSTrapFile 
sqlo_trce 
sqloEDUCodeTrapHandler 
sqlnq_qun::correlation_fromqun 
sqlnr_clusterQunsFindCluster 
sqlnr_clusterQuns 
sqlnr_optprepP9sqlnq_qur 
 
The example query is: 
 
create table T( i int, data xml); 
 
XQUERY 
let $b := db2-fn:xmlcolumn('T.DATA')/a 
let $bp := db2-fn:xmlcolumn('T.DATA')/p 
for $o in  $b/o 
let $one := $b[o = $o] 
return 
   <List> 
   { 
      for $aList in $bp[o = $one/o] 
       return 
        <m><a>{$aList/a/text()}</a></m> 
   } 
   </List> 
; 
 
This problem does not exists on later DB2 version, V9.5 or 
later.

**************************************************************** 
* USERS AFFECTED:                                              * 
* DB2 UDB Version 9.1                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error description field for more information.            * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to Version 9.1 FixPack 10.                           * 
****************************************************************

DB2 Version 9.1 Fix Pack 10  for Linux, UNIX and Windows
 DB2 Version 9.1 Fix Pack 11  for Linux, UNIX and Windows
 DB2 Version 9.1 Fix Pack 12  for Linux, UNIX and Windows
 

Problem was first fixed in DB2 UDB Version 9.1 FixPack 10.

not known / see Local fix

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

25.08.2010
14.06.2011
14.06.2011

9.1.FP10