suche 36x36
Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

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)