DB2 FOR LUW / DB2FORLUW / B10 - DB2

Additional space is added in rewritten query to string predicate 
when we use "NOT IN" clause,  thus we get wrong results from 
query. 
This only happens when we have table organized by columns 
 
Example: 
     create table t(c varchar(5)) organize by column; 
     insert into t values('x'); 
 
     select substr(c,1) from t where substr(c,1) not in 
(CHAR('abc'),CHAR('x')); 
 
     1 
     ----- 
     x 
 
       1 record(s) selected. ==>incorrect result

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 105fp9 and higher version.                    * 
****************************************************************

Rewrite the query to avoid this condition.

Db2 Version 11.1 Mod2 Fix Pack2 iFix001 for Linux, UNIX, and Windows
 Db2 Version 11.1 Mod2 Fix Pack2 iFix002 for Linux, UNIX, and Windows
 Db2 Version 11.1 Mod 3 Fix Pack 3 for Linux, UNIX, and Windows
 Db2 Version 11.1 Mod3 Fix Pack3 iFix001 for Linux, UNIX, and Windows
 Db2 Version 11.1 Mod3 Fix Pack3 iFix002 for Linux, UNIX, and Windows
 

Upgrade to DB2 105fp9 and higher version.

not known / see Local fix

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

31.03.2017
09.10.2017
12.10.2017