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

keiner bekannt / siehe Local-Fix

Vorgänger  : 
Nachfolger : IT25735 

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

16.07.2018
29.11.2018
29.11.2018