2002321 - Non-Fatal IQ Internal Error Detected at dfo_Join.cxx:452. SAP IQ

IQ failed to execute due to below internal error when IQ chose the Nested-Loop Pushdown as a join algorithm.

[SQL]

select COL001
from TAB001 T1, TAB002 T2
where
(1=1)
And (CASE WHEN COL001 IS NULL THEN COL002 ELSE COL001 END = T1.COL003);

[Error]

 ******************************************************** 
 ** 
 ** Non-Fatal IQ Internal Error Detected 
 ** at dfo_Join.cxx:452 on thread 3861047040 (TID 35) 
 ** Error detected at DFO #03 Join (Nested-Loop PushDown) 
 ** for expression: CAST(DUMMY.C$_0FIS_SHIP_CMPLD_WRK3.C12_HESAP_NO AS INT64) (qb:1, addr:0x7fafc801a348) 
 ** 
 ...
 ** Command text: 
 ***************** This is the STACKTRACE ***************
 ...
  dfo_Join::ValidateLocalInternalConsistency()….
  dfo::ValidateInternalConsistency()….
  dfo_Root::Prepare()….
  st_cursorIQtoSA::Prepare()….
  df_OpenCursor::Prepare()….

• SAP IQ 15.4 ESD1
• SAP IQ 15.4 ESD2
• SAP IQ 15.4 ESD3

dfo_Join.cxx, ValidateLocalInternalConsistency, 733441, dfo_Join.cxx:452, SAP IQ, SYBASE, CR #733441, CR 733441 , KBA , BC-SYB-IQ , Sybase IQ , BW-SYS-DB-IQ , BW on HANA with Sybase IQ Near-line Storage , Bug Filed