DB2 FOR LUW / DB2FORLUW / A10 - DB2

Under rare scenarios, DB2 might produce incorrect results if the 
following conditions are true: 
1) The query contains 2 or more quantified subqueries. There are 
subqueries of the form ALL, ANY, SOME 
2) The subqueries are part of an OR predicate 
3) The result set within one or more subqueries is empty 
 
eg. 
select * from t1 where 
(exists (select * from t3 where t1.c1 = t3.c1) OR 
 c1 = ANY (select c1 from t4));

**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Please upgrade to DB2 version 101 fix pack 4                 * 
****************************************************************

db2set -im DB2COMPOPT=NO_EORE

DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
 

Fixed in DB2 version 101 fix pack 4

not known / see Local fix

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

22.01.2014
02.06.2014
02.06.2014