DB2 - Problembeschreibung
Problem IT09673 | Status: Geschlossen |
XML QUERY MAY RETURN INCORRECT RESULT WHEN IT HAS OLAP AND ORDER BY | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problembeschreibung: | |
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-Zusammenfassung: | |
**************************************************************** * 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. | |
verfügbare FixPacks: | |
DB2 Version 11.1 Mod1 Fix Pack1 iFix001 for Linux, UNIX, and Windows | |
Lösung | |
Problem was first fixed in DB2 UDB Version 10.5 FixPack 8. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 24.06.2015 11.01.2017 11.01.2017 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
11.1.1.1 |