DB2 FOR LUW / DB2FORLUW / 970 - DB2

The incorrect results is returned when a SQL/XML query or XQuery 
has a LONG (bigint) XML value in the predicate. 
 
For example, 
 
create table TEST (ID  INT not null, DOC xml); 
 
SELECT H.ID 
FROM TEST AS H 
WHERE (((XMLEXISTS ('$H[/a/b = -1234567891234567890]' 
       passing H.DOC as "H"))));

**************************************************************** 
* USERS AFFECTED:                                              * 
* Users issue a SQL/XML query or XQuery with a LONG (bigint)   * 
* XML value in the predicate                                   * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* The incorrect results is returned when a SQL/XML query or    * 
* XQuery has a LONG (bigint) XML value in the predicate.       * 
*                                                              * 
* For example,                                                 * 
*                                                              * 
* create table TEST (ID  INT not null, DOC xml);               * 
*                                                              * 
* SELECT H.ID                                                  * 
* FROM TEST AS H                                               * 
* WHERE (((XMLEXISTS ('$H[/a/b = -1234567891234567890]'        * 
*        passing H.DOC as "H"))));                             * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to V97FP4 or Galileo.                                * 
****************************************************************

N/A

DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

Users can use xs:decimal in the query predicate. 
For example, 
SELECT H.ID 
FROM TEST AS H 
WHERE (((XMLEXISTS ('$H[/a/xs:decimal(b) = 
-1234567891234567890]' 
       passing H.DOC as "H"))));

keiner bekannt / siehe Local-Fix

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

23.11.2010
28.04.2011
28.04.2011

9.7.FP4