DB2 FOR LUW / DB2FORLUW / A50 - DB2

Selecting "<TIMESTAMP_COLUMN> + <DECIMAL_COLUMN> SECONDS" from a 
column-organized table might produce incorrect results for rows 
with <DECIMAL_COLUMN> < 0 and <DECIMAL_COLUMN> > -1.  For 
example, the following SQL statements return a value of 
2014-01-01-12.00.01.900000 when it should return a value of 
'2014-01-01-11.59.59.900000'. 
 
create table t1 (t1 timestamp, d2 decimal(10,5)) organize by 
column; 
insert into t1 values ('2014-01-01-12.00.00', -0.1); 
select t1 + d2 seconds from t1;

**************************************************************** 
* USERS AFFECTED:                                              * 
* All users                                                    * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 version 10.5.0.5.                             * 
****************************************************************

The problem is first fixed in DB2 version 10.5.0.5.

not known / see Local fix

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

16.09.2014
13.03.2015
09.04.2015