DB2 FOR LUW / DB2FORLUW / A50 - DB2

Wrong results can be returned as shown: 
 
create table t1 (c1 int, c2 varchar(128)) organize by row 
distribute by (c1); 
insert into t1 values 
(1,'ROUND_HALF_EVEN'),(2,'ROUN'),(3,'ROUN'),(4,'ROUN'),(5,'ROUN' 
),(6,'ROUND_HALF_EVEN'),(7,'ROUND_HALF_EVEN'),(8,'ROUN'),(9,'ROU 
N'); 
 
 
In MPP(4 nodes) : 
 select * from t1 where CURRENT DECFLOAT ROUNDING MODE = t1.c2 
 
C1          C2 
 
----------- 
---------------------------------------------------------------- 
---------------------------------------------------------------- 
 
  0 record(s) selected. 
 
We expect this query to return 3 records.

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to Db2 10.5 Fix Pack 9 or higher                     * 
****************************************************************

n/a

First fixed in Db2 10.5 Fix Pack 9

not known / see Local fix

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

20.12.2016
29.09.2017
12.10.2017

9.0.