DB2 FOR LUW / DB2FORLUW / B10 - DB2

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:                                              *
* INCORRECT RESULTS WITH OUTER JOINS AND EXPRESSIONS IN JOIN   *
* COLUMNS                                                      *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to Db2 11.1 mod 4 fixpack 4 or later                 *
****************************************************************

N/A

not known / see Local fix

forerunner  : 
follow-up : IT25735 

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

16.07.2018
29.11.2018
29.11.2018