DB2 FOR LUW / DB2FORLUW / 970 - DB2

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.

****************************************************************
* USERS AFFECTED:                                              *
* ALL                                                          *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* See Local Fix or upgrade to next release                     *
****************************************************************

avoid comparing varchar to vargraphic columns in the sql

not known / see Local fix

forerunner  : IT18762 
follow-up : 

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

13.01.2017
07.03.2017
07.03.2017