DB2 FOR LUW / DB2FORLUW / A10 - DB2

When comparing fixed character or graphic strings where either 
side uses a CASE statement, DB2 may return incorrect results in 
VARCHAR2 compatibility mode. 
 
Example: 
 
CREATE TABLE T(C1 CHAR(4)) 
INSERT INTO T VALUES ('M') 
SELECT * FROM T WHERE C1 = CASE WHEN 1=1 THEN 'M' END 
 
Incorrect Result: 
 
C1 
---- 
 
  0 record(s) selected.

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 10.1 Fix Pack 6                               * 
****************************************************************

From the example above, cast the CASE statement to a fixed 
character string of the desired length: 
 
SELECT * FROM T WHERE C1 = CAST((CASE WHEN 1=1 THEN 'M' END) AS 
CHAR(1)) 
 
C1 
-------- 
M 
 
  1 record(s) selected.

First fixed in DB2 10.1 Fix Pack 6

not known / see Local fix

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

13.12.2016
02.03.2017
02.03.2017