|
Problem IT31619
|
Status: Closed |
IN DPF AGAINST COLUMNAR TABLES WRONG RESULT IS POSSIBLE FOR SQL WITH LIMIT WHEN OVER(PARTITION BY) AND ORDER BY IS USED
|
| product: |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 |
| Problem description: |
If the DPF configuration sql query could return wrong results if
:
- query is against columnar tables
- query has LIMIT
- query has OLAP : OVER(PARTITION BY) AND ORDER BY
example of the query:
example:
"select count(c2) over(), count(c2) over(partition by c2) from
CDE_TABLE order by c2 limit 3" |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* DPF CDE OLAP *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* See Error Description and install fixpak with this fix. *
**************************************************************** |
| Local Fix: |
N/A |
| Solution |
|
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 22.01.2020
24.04.2020
24.04.2020 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
