DB2 FOR LUW / DB2FORLUW / 970 - 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 
 
PROBLEM SUMMARY: 
 
see ERROR DESCRIPTION

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

DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

The complete fix for this problem first appears in DB2 UDB 
Version 9.7 FixPak 3.

keiner bekannt / siehe Local-Fix

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

04.05.2010
24.09.2010
24.09.2010

9.7.