Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IC71916 Status: Closed

INCORRECTLY BLANK PADDED OR CASE INSENSITIVE RESULTS ARE RETURNE DWHEN
COMPARING COLUMNS OF CERTAIN DATATYPES

product:
DB2 FOR LUW / DB2FORLUW / 910 - DB2
Problem description:
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 $.)
Problem Summary:
**************************************************************** 
* 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.                        * 
****************************************************************
Local Fix:
available fix packs:
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

Solution
Problem first fixed in V9.7 Fixpack 10
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
14.10.2010
14.06.2011
03.04.2012
Problem solved at the following versions (IBM BugInfos)
9.7.FP10
Problem solved according to the fixlist(s) of the following version(s)
9.1.0.10 FixList
This site uses cookies to make it easier for us to provide you with our services. By using our site you agree to the use of cookies.