DB2 FOR LUW / DB2FORLUW / B10 - DB2

A query might generate wrong results when the query contains the
following characteristics:
1) it contains at least one outer join
2) on the null producing side of this outer join, there is at
least one aggregation and this null producing side at most
produces one row
3) the row preserving side of this outer join also at most
produces one row

Ex.
select A.a1, B.sum
from a
A              -- row preserving side
left join
(select sum(B.b3) as sum from b B where B.b1=1 and B.b2=2) B  --
null producing side
on 1=1
where A.a1=1

Where A.a1 contains unique key so the predicate - "A.a1=1"
ensures that there is at
most one row output from A, and the row preserving side also
only outputs at most one row due to the aggregation.

****************************************************************
* USERS AFFECTED:                                              *
* All                                                          *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description and install the fix.                   *
****************************************************************
* RECOMMENDATION:                                              *
* See Error Description and install the fix.                   *
****************************************************************

db2set -im DB2COMPOPT=NO_GBPU

not known / see Local fix

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

10.04.2019
29.11.2019
23.03.2020