DB2 - Problem description
Problem IT18815 | Status: Closed |
COMPARING LARGE VARYING CHARACTER AND GRAPHIC STRINGS CAN CAUSE WRONG RESULTS IN UNICODE DATABASES | |
product: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problem description: | |
When comparing large VARCHAR and VARGRAPHIC strings in a Unicode database, DB2 may cause wrong results. Example: create table vc(c1 VARCHAR(32672)); create table vg(c2 VARGRAPHIC(16336)); insert a 32672 character string containing a distinct 1 byte character into vc insert the same string above into vg but with a size of 16336 characters select 1 from vc,vg where vc.c1 = vg.c2; Expected Result: 1 ----------- 0 record(s) selected. Actual Result: 1 ----------- 1 1 record(s) selected. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * COMPARING LARGE VARYING CHARACTER AND GRAPHIC STRINGS * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to the latest release of Db2. * **************************************************************** | |
Local Fix: | |
avoid comparing varchar to vargraphic columns in the sql | |
Solution | |
Workaround | |
not known / see Local fix | |
BUG-Tracking | |
forerunner : IT18762 follow-up : | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 13.01.2017 05.12.2019 05.12.2019 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |