DB2 - Problembeschreibung
Problem IC65715 | Status: Geschlossen |
Query that uses OLAP specification OVER clause with 0 FOLLOWING might return wrong results. | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
A query that uses the OLAP specification "OVER" clause and also contains "0 FOLLOWING" might give wrong results. The following is an example query that can give wrong results: SELECT C1, C2, COUNT(C2) OVER (ORDER BY C1 ROWS BETWEEN 0 FOLLOWING AND 1 FOLLOWING) from t1 In the case of wrong results, for the above query the 3rd column that is output (i.e. count(c2)) might show an incorrect number for the count. To workaround you can rewrite your query to not use "0 FOLLOWING". "CURRENT ROW" or "0 PRECEDING" can be used instead. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * OLAP SQL with 0 FOLLOWING * **************************************************************** * PROBLEM DESCRIPTION: * * A query that uses the OLAP specification "OVER" clause * * andalsocontains "0 FOLLOWING" might give wrong results.The * * following is an example query that can give * * wrongresults:SELECT C1, C2, COUNT(C2) OVER (ORDER BY C1 ROWS * * BETWEEN 0FOLLOWING AND 1 FOLLOWING) from t1In the case of * * wrong results, for the above query the 3rdcolumnthat is * * output (i.e. count(c2)) might show an incorrectnumberfor the * * count.To workaround you can rewrite your query to not use * * "0FOLLOWING"."CURRENT ROW" or "0 PRECEDING" can be used * * instead. * **************************************************************** * RECOMMENDATION: * * rewrite the query to not use 0 FOLLOWING or install thisAPAR * **************************************************************** | |
Local-Fix: | |
rewrite the query to not use 0 FOLLOWING or install this APAR | |
Lösung | |
A query that uses the OLAP specification "OVER" clause and also contains "0 FOLLOWING" might give wrong results. The following is an example query that can give wrong results: SELECT C1, C2, COUNT(C2) OVER (ORDER BY C1 ROWS BETWEEN 0 FOLLOWING AND 1 FOLLOWING) from t1 In the case of wrong results, for the above query the 3rd column that is output (i.e. count(c2)) might show an incorrect number for the count. To workaround you can rewrite your query to not use "0 FOLLOWING". "CURRENT ROW" or "0 PRECEDING" can be used instead. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 20.01.2010 24.06.2010 24.06.2010 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version |