DB2 FOR LUW / DB2FORLUW / B10 - DB2

Wrong result might output from queries containing
join on columnar tables and implicit column equivalence and join
predicates with expressions

Wrong results might occur when running a query with the
following characteristics:
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:                                              *
* Columnar Organized tables                                    *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description. Please, install v11 Fixpak 4.         *
****************************************************************
* RECOMMENDATION:                                              *
* See Error Description. Please, install v11 Fixpak 4 on DB2   *
* Server                                                       *
****************************************************************

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

Vorgänger  : 
Nachfolger : IT26439 

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

18.09.2018
23.12.2018
23.12.2018