DB2 FOR LUW / DB2FORLUW / A50 - DB2

Queries may fail with -901 error when using a case expression 
that returns a decimal column. 
Description: 
Under rare scenarios in a columnar database, queries using may 
fail with a -901 error 
if the following conditions are true: 
1) The query uses a case expression that returns a decimal 
column and 
2) A NULL literal is used in one of the case condition and 
3) This case expression is the input for a aggregate function. 
 
eg. Select min(case when col1 = 1 
                then mincol 
                else null 
           end) 
	from bad 
	group by grpbycol;

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to v105 fp7                                          * 
****************************************************************

Fixed v105 fp7

not known / see Local fix

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

21.07.2015
25.01.2016
25.01.2016