DB2 FOR LUW / DB2FORLUW / A50 - DB2

This issue can only happen in Fixpaks 8,9 and 10.

Users might observe incorrect results when running a query with
the following characteristics:
1. the query has an outer join
2. the outer join columns contain expressions
3. the row preserving side of the outer join has a GB or UNION
4. the null producing side of the outer join has a GB, UNION or
CSE
5. there is at least one outer join predicate referencing only
the null producing columns

The wrong result set usually contains less rows than the correct
result set.

****************************************************************
* USERS AFFECTED:                                              *
* ALL                                                          *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to Db2 10.5 Fix Pack 11 or higher                    *
****************************************************************

N/A

not known / see Local fix

forerunner  : IT25706 
follow-up : 

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

18.07.2018
25.02.2020
25.02.2020