In Windows 64bit DB2 10.1.0 / 10.1.2 I am experiencing the following error while doing some simple joins with a where clause:
TABLE_1 JOIN TABLE_2 ON TABLE_1.TABLE_2_ID = TABLE_2.ID JOIN TABLE_3 ON TABLE_1.TABLE_3_ID = TABLE_3.ID
WHERE (TABLE_2.NAME = 'name2' OR TABLE_2.NAME = 'name4') AND (TABLE_3.TABLE_3_ID = 'name6')
ASSERT ZZJN DIM TEMP TAOB HAS A DUMMY RESID
It looks like something is going astray in the ZigZag join. For now the ZigZag support got turned off:
db2set DB2_REDUCED_OPTIMIZATION=ZZJN OFF
but this doesn't feel like the right solution.
There is an article that addresses the issue, alas I cannot view it without paid support:
Does anyone know of a solution or what the article suggests? Is this a know issue that will be addressed?