DB2 FOR LUW / DB2FORLUW / A10 - DB2

Depending on the data, XML query may return incorrect results. 
 
Here is a sample result. In this case, the count() should return 
100. 
 
$ db2 import from data.del of del xml from xmls insert into 
transact 
$ db2 -tvf a.txt 
SELECT count(id) FROM TRANSACT WHERE 
xmlexists('$root/transact[action/assignor/@loginNameResponseCode 
="573076-1" and @transactState=1]' passing data as "root") 
 
1 
----------- 
         91 
 
  1 record(s) selected. 
 
$ db2 -tvf b.txt 
SELECT count(id) FROM TRANSACT WHERE 
xmlexists('$root/transact[action/assignor/@loginNameResponseCode 
="573076-1"]' passing data as "root") and 
xmlexists('$root/transact[@transactState=1]' passing data as 
"root") 
 
1 
----------- 
        100 
 
  1 record(s) selected. 
 
$ db2 -tvf d.txt 
SELECT count(id) FROM TRANSACT WHERE 
xmlexists('$root/transact[./action/assignor/@loginNameResponseCo 
de="573076-1" and @transactState=1]' passing data as "root") 
 
1 
----------- 
        100 
 
  1 record(s) selected. 
 
$ db2 -tvf c.txt 
SELECT count(id) FROM TRANSACT WHERE 
xmlexists('$root/transact[@transactState=1 and 
./action/assignor/@loginNameResponseCode="573076-1"]' passing 
data as "root") 
 
1 
----------- 
        100 
 
  1 record(s) selected.

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 10.1 Fix Pack 1.                      * 
****************************************************************

DB2 Version 10.1 Fix Pack 1 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 2 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
 

First fixed in DB2 Version 10.1 Fix Pack 1.

keiner bekannt / siehe Local-Fix

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

14.06.2012
13.11.2012
13.11.2012