DB2 - Problem description
Problem IT30249 | Status: Closed |
WRONG RESULTS ARE POSSIBLE FOR FEDERATED OR COLUMNAR QUERY WITH AGGREGATION OVER DISTINCT OUTER JOIN | |
product: | |
DB2 FOR LUW / DB2FORLUW / B10 - 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.1 Mod 4 Fixpack 5 or higher * **************************************************************** | |
Local Fix: | |
N/A | |
Solution | |
Workaround | |
not known / see Local fix | |
BUG-Tracking | |
forerunner : follow-up : IT30251 IT30252 | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 11.09.2019 16.01.2020 16.01.2020 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |