DB2 FOR LUW / DB2FORLUW / 970 - 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. Install release and fixpak that has   *
* this fix.                                                    *
****************************************************************
* RECOMMENDATION:                                              *
* Install release and fixpak that has this fix.                *
****************************************************************

n/a

not known / see Local fix

forerunner  : IT18500 
follow-up : 

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

20.12.2016
30.05.2017
30.05.2017