DB2 FOR LUW / DB2FORLUW / 980 - DB2

Incorrect results may be returned if following conditions are 
satisfied: 
 
1) FULL OUTER JOIN (FOJ) used in query 
2) COALESCE function used on two or more columns after 
application of FOJ 
3) The first parameter column to COALESCE sources from a 
not-nullable base-table column 
4) The inputs to FOJ are nested subselects 
5) One or both nested subselects either: 
5.a) Output a constant literal as a column, which is used after 
application of FOJ, OR 
5.b) Contain a GROUP BY clause where the output columns of the 
subselect are columns, literals, column functions or 
deterministic functions only

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* see ERROR DESCRIPTION                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.8 Fix Pack 4.                       * 
****************************************************************

Rewrite any problematic queries to preclude any of the 
conditions above, e.g., use a CASE expression instead of 
COALESCE

DB2 Version 9.8 Fix Pack 4 for AIX and Linux
 DB2 Version 9.8 Fix Pack 5 for AIX and Linux
 

First fixed in DB2 Version 9.8 Fix Pack 4.

keiner bekannt / siehe Local-Fix

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

04.05.2010
09.08.2011
09.08.2011

9.8.FP4