home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
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
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IC71916 Status: Geschlossen

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

Produkt:
DB2 FOR LUW / DB2FORLUW / 910 - DB2
Problembeschreibung:
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-Zusammenfassung:
**************************************************************** 
* 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:
verfügbare FixPacks:
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

Lösung
Problem first fixed in V9.7 Fixpack 10
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
14.10.2010
14.06.2011
03.04.2012
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.FP10
Problem behoben lt. FixList in der Version
9.1.0.10 FixList