|
Problem IT40762
|
Status: Closed |
INCORRECT RESULT WITH QUERY HAVING UNION
|
| product: |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 |
| Problem description: |
Db2 may generate wrong results when the following conditions are
met:
-There is GROUP BY in the query
-The GROUP BY is above a sub select with UNION |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 Version 11.5.8 fp0 *
**************************************************************** |
| Local Fix: |
Manual query rewrite |
| Solution |
|
| Workaround |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 Version 11.5.8 fp0 *
**************************************************************** |
| Comment |
First fixed in DB2 Version 11.5.8 fp0 |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 27.04.2022
04.05.2022
04.05.2022 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
