DB2 - Problem description
Problem IT19095 | Status: Closed |
DB2 MIGHT PRODUCE INCORRECT RESULT WHEN EXECUTING XQUERY WITH MULTIPLE OR SUBTERMS | |
product: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problem description: | |
DB2 might produce incorrect result when executing a query with following: 1) The query must be of type XQuery 2) There must be at least one reference to XML table 3) The XML column is referenced in two or more OR subterm predicates. eg. select Col from SAMPLE_XMLTAB AS tablewithxml INNER JOIN XMLTABLE('$XMLDATA' passing XMLDATA AS XMLDATA COLUMNS Col DATE PATH 'cf/date/tc64171datem[1]/text()', Col2 VARCHAR(1024) PATH 'cf/text/tc64171textm[1] /text()') AS thexmltabletable ON 1 = 1 where ( Col > current timestamp or Col IS NULL ); | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 10.5 Fix Pack 9 or higher * **************************************************************** | |
Local Fix: | |
Solution | |
First fixed in Db2 10.5 Fix Pack 9 | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 03.02.2017 29.09.2017 12.10.2017 |
Problem solved at the following versions (IBM BugInfos) | |
9.0. | |
Problem solved according to the fixlist(s) of the following version(s) |