DB2 - Problembeschreibung
Problem IT17941 | Status: Geschlossen |
POSSIBLE WRONG RESULTS WHEN THE INPUT PARAMETERS OF AN INLINED SQL SCALAR UDF CONTAINS AN OLAP SPECIFICATION | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 | |
Problembeschreibung: | |
When the input parameters of an inlined SQL scalar UDF contains an OLAP specification, and under any of the following situations, wrong results are possible. (1) When such UDF appears in select clause, and the select clause also has "distinct" keyword. (2) When such UDF appears in order by clause You can work around the issue by modifying the query. For example, if the query is: select C2 from T1 order by F1(min(C1) over (partition by C2)) You can modify the query to: select C2 from ( select C2, F1(min(C1) over (partition by C2)) as CC from T1 ) order by CC If the query is select distinct F1(min(C1) over (partition by c2)) * F1(count(C1) over (partition by c2)) from T1 You can modify the query to: select distinct F1(CC1) * F1(CC2) from ( select min(C1) over (partition by c2) as CC1, count(C1) over (partition by c2) as CC2 from T1 ) | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * All * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 Version 11.1.1.1 * **************************************************************** | |
Local-Fix: | |
Modify the query; see "Error Description" | |
verfügbare FixPacks: | |
DB2 Version 11.1 Mod1 Fix Pack1 iFix001 for Linux, UNIX, and Windows | |
Lösung | |
First fixed in DB2 Version 11.1.1.1 | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 14.11.2016 20.12.2016 20.12.2016 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
11.1.1.1 |