1966851 - IQ aborted at "dfo::CheckMarkInvariant" - SAP IQ

A Query (which used a Nested loop pushdown (NLPD) join with more than one uncorrelated IN subquery) leads to server crash.

[iqmsg]

SELECT a11.KEY_COL001 k1,
....
WHERE (((a11.KEY_COL001) in ( SELECT c22.KEY_COL002
FROM ONWER.TAB002 c21
JOIN ONWER.TAB001 c22
on (c21.KEY_COL003 = c22.KEY_COL004)
WHERE c21.KEY_COL003 not in ('Y')))
AND ((a11.KEY_COL001) in ( SELECT c22.KEY_COL005
FROM ONWER.TAB003 c21
JOIN ONWER.TAB004 c22
on (c21.KEY_COL006 = c22.KEY_COL007)
...
GROUP by a11.KEY_COL001

  Dump all thread stacks at st_server.cxx:1412 for PID: 24707566
 
  ***************** This is the STACKTRACE ***************
 
  ===== Thread Number 36752 (IQ connID: 0000156739) =====
  ...pcstkwalk(stk_trace*,int,db_log*,hos_fd*)+0x170()
  ...ucstkgentrace(int,int)+0xb0()
  ...DumpAllThreads(const char*,unsigned int,int)+0x1bc()
  ...hos_ABORT(const char*,unsigned int,const char*,char*,char*)+0x160()
  ...SigHndlr+0x54()
  ...dfo::CheckMarkInvariant(const hos_vector_noerror&,int)+0x90()
  ...dfo_Join::CheckMarkInvariant(const hos_vector_noerror&,int)+0x1a4()
  ...dfo::CheckMarkInvariant(const hos_vector_noerror&,int)+0x90()
  ...dfo_SubQuery::CheckMarkInvariant(const hos_vector_noerror&,int)+0xb4()
  ...dfo::CheckMarkInvariant(const hos_vector_noerror&,int)+0x90()
  ...dfo::CheckMarkInvariant(const hos_vector_noerror&,int)+0x90()

• SAP IQ 15.2
• SAP IQ 15.4

CheckMarkInvariant, Nested loop pushdown, st_server.cxx:1412, uncorrelated subquery, IQ, CR #705510, CR 705510, 705510 , KBA , BC-SYB-IQ , Sybase IQ , BW-SYS-DB-IQ , BW on HANA with Sybase IQ Near-line Storage , Bug Filed