DB2 FOR LUW / DB2FORLUW / A50 - DB2

The following is an example of a UDF which might return 
incorrect results: 
CREATE FUNCTION PSearch (a pair, b pair) 
   RETURNS Integer 
   LANGUAGE SQL 
   DETERMINISTIC 
   NO EXTERNAL ACTION 
   PREDICATES 
( 
     WHEN = 1 
       SEARCH BY EXACT INDEX EXTENSION PairExt 
         WHEN KEY (a) USE  RetrieveKey (b) 
         WHEN KEY (b) USE  RetrieveKey (a) 
) 
   RETURN (0) 
 
The following is a query using the UDF as a predicate: 
SELECT * FROM mytable AS a 
WHERE PSearch(a.column, 1) = 1 
 
If the index does not exist, the SEARCH BY expression is not 
processed and the function PSearch returns the value 0 which 
results in no rows being returned.  Due to the error in function 
processing, all table rows might be returned.

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Update to 10.5.0.3                                           * 
****************************************************************

Ensure that the index exists if the function is intended to be 
used with a table that has a defined index extension.

DB2 Version 10.5 Fix Pack 3 for Linux, UNIX, and Windows
 DB2 Version 10.5 Fix Pack 3a for Linux, UNIX, and Windows
 DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
 DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows
 

Problem Fixed In 10.5.0.3

keiner bekannt / siehe Local-Fix

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

15.10.2013
28.02.2014
07.04.2015