DB2 FOR LUW / DB2FORLUW / A50 - DB2

Starting with 10.5 FP3, wrong results may be returned from
queries containing
join on columnar tables with the following conditions:

1) the query joins multiple column organized tables
2) the join predicates reference expressions
3) implicit column equivalence can be derived from these join
predicates

****************************************************************
* USERS AFFECTED:                                              *
* ALL                                                          *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to Db2 10.5 Fix Pack 11 or higher                    *
****************************************************************

Work-around:
1) Lower optlevel
2) force the join order to join tables with join predicate first
3) rewrite the query to add join predicates to express the
implicit column equivalence

See LOCAL FIX

forerunner  : IT26322 
follow-up : 

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

27.09.2018
25.02.2020
25.02.2020