DB2 - Problem description
Problem IT19197 | Status: Closed |
DB2 MIGHT PRODUCE INCORRECT RESULT WHEN EXECUTING XQUERY WITH MULTIPLE OR SUBTERMS | |
product: | |
DB2 FOR LUW / DB2FORLUW / B10 - 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 11.1 Mod 2 Fix Pack 2 or higher * **************************************************************** | |
Local Fix: | |
available fix packs: | |
DB2 Version 11.1 Mod 2 Fix Pack 2 for Linux, UNIX, and Windows | |
Solution | |
First fixed in DB2 11.1 Mod 2 Fix Pack 2 | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 09.02.2017 23.06.2017 23.06.2017 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |