DB2 FOR LUW / DB2FORLUW / 910 - DB2

The problem occurs when performing string comparisons between 
two columns and referencing any one or both of these columns in 
the output column list. Column can be of datatypes char, 
varchar, graphic, vargraphic and any user defined types. 
 
eg. To demonstrate the incorrect results: 
 
SET SCHEMA TEAMS; 
 
CREATE TABLE "TEAMS  "."EMPLOYEE"  ( 
          "PER_ID1" VARCHAR(12) NOT NULL ); 
 
CREATE TABLE "TEAMS  "."EMPLOYEE_ASSIGNMENT"  ( 
          "PER_ID3" VARCHAR(12) NOT NULL ); 
 
CREATE TABLE "TEAMS  "."PERSON"  ( 
      "PER_ID2" VARCHAR(12) NOT NULL ); 
 
insert into employee values '1117592'; 
insert into person values '1117592 '; 
 
SELECT EMPLOYEE.PER_ID1 || '$' AS "EMPLOYEE.PER_ID1" , 
PERSON.PER_ID2 || '$' AS "PERSON.PER_ID2" 
,EMPLOYEE_ASSIGNMENT.PER_ID3 FROM EMPLOYEE LEFT OUTER JOIN 
PERSON ON EMPLOYEE.PER_ID1 = PERSON.PER_ID2 LEFT OUTER JOIN 
EMPLOYEE_ASSIGNMENT ON EMPLOYEE.PER_ID1 = 
EMPLOYEE_ASSIGNMENT.PER_ID3 WHERE PERSON.PER_ID2 = '1117592' ; 
 
EMPLOYEE.PER_ID1 PERSON.PER_ID2 PER_ID3 
---------------- -------------- ------------ 
1117592$         1117592$       - 
 
  1 record(s) selected. 
 
 
Note that the second output column PERSON.PER_ID2 should be 
'1117592 $' (with a blank character before $.)

**************************************************************** 
* USERS AFFECTED:                                              * 
* Query using case sensitive data.                             * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* Incorrectly blank padded, the problem occurs when performing * 
* string comparisons between two columns and referencing any   * 
* one or both of these columns in the output column list.      * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Please upgrade to the latest fixpack.                        * 
****************************************************************

DB2 Version 9.1 Fix Pack 10  for Linux, UNIX and Windows
 DB2 Version 9.1 Fix Pack 11  for Linux, UNIX and Windows
 DB2 Version 9.1 Fix Pack 12  for Linux, UNIX and Windows
 

Problem first fixed in V9.7 Fixpack 10

not known / see Local fix

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

14.10.2010
14.06.2011
03.04.2012

9.7.FP10