|
Problem IC76679
|
Status: Closed |
INCORRECT RESULTS ARE RETURNED IF AN SQL QUERY CONTAINS RID(), RID_BIT() or ROWID |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
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. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* user of ROWID function *
****************************************************************
* PROBLEM DESCRIPTION: *
* 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. *
****************************************************************
* RECOMMENDATION: *
* Install this APAR *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
Install this APAR |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC83445
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 30.05.2011
01.11.2011
01.11.2011 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.5
|
 |
