DB2 - Problem description
Problem IT09673 | Status: Closed |
XML QUERY MAY RETURN INCORRECT RESULT WHEN IT HAS OLAP AND ORDER BY | |
product: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problem description: | |
An XML query may return incorrect result when it has all the following characteristics 1. The query has a sub-select referencing OLAP function, such as rownum in Ora comparability mode, row_number() over (), etc. 2. There is ORDER BY clause in the same or outer sub-select of the OLAP, and the columns in ORDER BY clause have expressions whose out-most function is XMLCAST. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * DB2 UDB Version 10.5 * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Version 10.5 FixPack 8. * **************************************************************** | |
Local Fix: | |
Manually rewrite the query to compute the ORDER BY XMLCAST expression as close as possible to the base table access, and replace ORDER BY expression with simple column returned from inner sub-select. | |
available fix packs: | |
DB2 Version 11.1 Mod1 Fix Pack1 iFix001 for Linux, UNIX, and Windows | |
Solution | |
Problem was first fixed in DB2 UDB Version 10.5 FixPack 8. | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 24.06.2015 11.01.2017 11.01.2017 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) | |
11.1.1.1 |