|
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
|
 |
