DB2 FOR LUW / DB2FORLUW / B10 - DB2

In the CDE hash join, the type and length must exactly match
between the two joining keys.
This is because the comparison is done in binary.

In the following example, DB2 does not cast the join columns
correctly, leading to a -901 error in CDE:

create table coltab1 (ssn varchar(20)) organize by column;
create table coltab2 (ssn decimal(9,0)) organize by column;


db2 "SELECT  base.ssn
		FROM    coltab1  base
		INNER JOIN coltab2 mn
  			ON TO_CHAR(base.ssn) = TO_CHAR(mn.ssn)"

SSN
--------------------
SQL0901N  The SQL statement or command failed because of a
database system
error. (Reason "unexpected error at
GetJoinPayloadEvaluator.cpp:136".)
SQLSTATE=58004

****************************************************************
* USERS AFFECTED:                                              *
* ALL                                                          *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to Db2 11.1 Mod 2 Fix Pack 2 or higher               *
****************************************************************

not known / see Local fix

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

10.07.2017
24.10.2017
24.10.2017