DB2 - Problem description
Problem IT25147 | Status: Closed |
QUERIES CONTAINING OUTER JOINS AND GROUP BY CLAUSES MIGHT PRODUCE WRONG RESULTS | |
product: | |
DB2 FOR LUW / DB2FORLUW / A50 - 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 UDB Version 10.5 * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Version 10.5 FixPack 10. * **************************************************************** | |
Local Fix: | |
DB2COMPOPT=NO_GBPU | |
Solution | |
Workaround | |
not known / see Local fix | |
BUG-Tracking | |
forerunner : follow-up : IT25195 | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 24.05.2018 11.07.2018 11.07.2018 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |