DB2 FOR LUW / DB2FORLUW / 950 - DB2

Incorrect results are possible when doing nested math operations 
on columns that are defined with NOT NULL and using functions. 
 
Example (pseudo-code): 
 
create function3(col1 bigint,col2 bigint) 
{ 
    return function1(col1)-function2(col2); 
} 
 
SELECT SUM(function3(column1,column2)) from table; 
<-- intermittent incorrect results are possible on databases 
with smaller non-automatic SORTHEAP.

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* Wrong results are possible when doing nested math operations * 
* on                                                           * 
* non-nullable columns and using functions.                    * 
* Example (pseudo-code):                                       * 
*                                                              * 
* create function3(col1 bigint,col2 bigint)                    * 
* {                                                            * 
*     return function1(col1)-function2(col2);                  * 
* }                                                            * 
*                                                              * 
* SELECT SUM(function3(column1,column2)) from table;           * 
* <-- intermittent wrong results are possible.ly to happen on  * 
* databases with smaller non-automatic SORTHEAP.               * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 UDB version 9.5 fixpack 10.                   * 
****************************************************************

select SUM(col1) - SUM(col2) from table

Problem was first fixed in DB2 UDB Version 9.5 Fix Pack 10.

keiner bekannt / siehe Local-Fix

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

22.05.2012
21.08.2012
07.12.2012

9.5.FP10