DB2 - Problem description
Problem IT25195 | Status: Closed |
QUERIES CONTAINING OUTER JOINS AND GROUP BY CLAUSES MIGHT PRODUCE WRONG RESULTS | |
product: | |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 | |
Problem description: | |
Users might find wrong results from a query that has the following characteristics: 1. the query has at least one outer join 2. the row preserving side of this outer join outputs much less rows than the other side - the null producing side of the outer join 3. there is group by clause on the null producing side of the outer join 4. the row preserving side of the outer join cannot produce a unique key | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Db2 Version 11.1 * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 Version 11.1 Mod 4 Fix Pack 4. * **************************************************************** | |
Local Fix: | |
DB2COMPOPT=NO_GBPU | |
Solution | |
Workaround | |
not known / see Local fix | |
BUG-Tracking | |
forerunner : IT25147 follow-up : | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 29.05.2018 03.12.2018 03.12.2018 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |