Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IC72768 Status: Closed

INCORRECT RESULTS WHEN A CUSTOMER HAS A LONG (BIGINT) XML VALUE IN THE
PREDICATE

product:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
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"))));
Problem Summary:
**************************************************************** 
* 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.                                * 
****************************************************************
Local Fix:
N/A
available fix packs:
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

Solution
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"))));
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
23.11.2010
28.04.2011
28.04.2011
Problem solved at the following versions (IBM BugInfos)
9.7.FP4
Problem solved according to the fixlist(s) of the following version(s)
9.7.0.4 FixList
This site uses cookies to make it easier for us to provide you with our services. By using our site you agree to the use of cookies.