DB2 - Problem description
Problem IT30251 | Status: Closed |
WRONG RESULTS ARE POSSIBLE FOR FEDERATED OR COLUMNAR QUERY WITH AGGREGATION OVER DISTINCT OUTER JOIN | |
product: | |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 | |
Problem description: | |
WRONG RESULTS ARE POSSIBLE FOR FEDERATED OR COLUMNAR QUERY WITH AGGREGATION OVER DISTINCT OUTER JOIN The following query yields wrong results if the source tables are either federated nicknames or column-organized tables. with v(a, b) as (select distinct t1.c2, t2.c1 from t1 left join t2 on t1.c1=t2.c2) select sum(b) as sumofb, a from v group by a ; e.g. say t1 contains rows (1, 1), (1, 2) and t2 contains rows (1, 1), (2, 1), (2, 1) If t1 and t2 are nicknames or if t1 and t2 are column-organized tables this incorrectly returns: SUMOFB A ----------- ----------- 5 2 5 1 2 record(s) selected. But the correct result is this: SUMOFB A ----------- ----------- 3 1 3 2 2 record(s) selected. This problem is specific to Outer Join. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 11.5 Mod 2 Fixpack 0 or higher * **************************************************************** | |
Local Fix: | |
N/A | |
Solution | |
Workaround | |
not known / see Local fix | |
BUG-Tracking | |
forerunner : IT30249 follow-up : | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 11.09.2019 18.02.2020 18.02.2020 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |