DB2 FOR LUW / DB2FORLUW / 980 - DB2

Incorrect results are returned if a query contains RID(), 
RID_BIT() or ROWID. 
 
Example: 
 
db2 => CREATE TABLE  TA(C1 VARCHAR(30), C2 VARCHAR(3)) 
db2 => CREATE TABLE  TB(C1 VARCHAR(50), c2 VARCHAR(3)) 
 
db2 => INSERT INTO TA VALUES('EAD0401','abc') 
db2 => INSERT INTO TB VALUES('Z030_075','123') 
 
Incorrect result 1 row is returned for below SQL: 
 
SELECT 
    A.ROWID, 
    A.C1 
FROM TA A, TB B 
WHERE ( A.C2 = 'XX' 
        OR (A.C1 = 'EAD0401' AND B.C1 = 'XXX') 
        OR (A.C1 = 'XXX' AND B.C1 = 'XXX') 
      ); 
 
1                                  C1 
--------------------------------------------------------------- 
 
 
x'04000000000000000000A204F3040000' EAD0401 
 
The expected result is 0 row. 
 
This problem only occurs with DB2 V9.7 and does not affect V9.1 
or V9.5.

**************************************************************** 
* USERS AFFECTED:                                              * 
* The user who is running a query contains RID(),              * 
* RID_BIT() or ROWID.                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 V98FP5 or later.                              * 
****************************************************************

The problem is firstly fixed in V98FP5.

not known / see Local fix

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

14.05.2012
20.06.2012
20.06.2012

9.8.FP5