DB2 FOR LUW / DB2FORLUW / B50 - DB2

Queries with following characteristic may return incorrect
results:
- GROUP BY query over base tables
- FROM references the same table more than once using aliases
- multiple columns in GROUP BY clause referencing same table
using different aliases
- one of GB column is primary/unique key and one column comes
from different alias of the same table
- PK column is referenced in SELECT, while column from different
alias is not referenced in SELECT

Sample query (tab1.id is primary key):
SELECT a.id FROM tab1 a, tab1 b WHERE a.c1 = b.c1 GROUP BY a.id,
b.c2 HAVING COUNT(*) > 1

****************************************************************
* USERS AFFECTED:                                              *
* ALL                                                          *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to Db2 11.5 Mod 2 Fixpack 0 or higher                *
****************************************************************

not known / see Local fix

forerunner  : 
follow-up : IT31208 

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

09.12.2019
18.02.2020
18.02.2020