DB2 FOR LUW / DB2FORLUW / 950 - DB2

A SQL/XML or XQuery with condition expression could return 
SQL16012N instead of the expected result data. 
 
For example: 
 
CREATE TABLE T  ( 
   ID  INT , 
   DOC XML 
); 
 
 
select i.ID, X.* 
from T i, 
     xmltable ('$c' passing i.DOC as "c" 
      columns 
        key VARCHAR(20) PATH 
         'let $j := (if (.//*:test1) 
                     then (fn:substring(.,1,5)) 
                     else (.//*:test2)) 
           return $j') as X 
where ID = 5;

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* A SQL/XML OR XQUERY WITH CONDITION EXPRESSION COULD RETURN   * 
* SQL16012N INSTEAD OF THE EXPECTED RESULT DATA                * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 LUW Version 9.5 Fix Pack 10                   * 
****************************************************************

DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
 DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows
 

Problem was first fixed in Version 9.5 Fix Pack 10

keiner bekannt / siehe Local-Fix

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

15.10.2010
05.07.2011
05.07.2011

9.5.FP10