2239176 - Crash at s_fetchGroup with GROUP BY HAVING or WHERE - SAP IQ

• SAP IQ 16 systems running queries using the index-based GROUP BY algorithm in combination with a HAVING clause condition, or a WHERE clause condition on one of the GROUP BY columns may cause a server failure from s_fetchGroup::s_fetchGroup

Dump all thread stacks at stcxtlib/st_server.cxx:1709 for PID: 27251

    ***************** This is the STACKTRACE ***************

 ===== Thread Number  824  (IQ connID: 0000000071) =====
pc: 0x0 (0x0, 0x0)
pc: 0xfffffd7f64571187 void DumpAllThreads(const char*,unsigned,int)+0x29f(0xe8, 0xfffffd7f66beff50)
pc: 0xfffffd7f64256cca void hos_ABORT(const char*,unsigned,const char*,char*,char*)+0x1a2(0x7320746867756163, 0x3131206c616e6769)
pc: 0xfffffd7f6522f1e5 SigHndlr+0x41(0xfffffd7f4e1dd120, 0xfffffd7ffd7125e2)
pc: 0xfffffd7ffd71dd16 _fini+0x97208f56(0xfffffd7f4e1dd4d0, 0xb00b8bf5b)
pc: 0xfffffd7ffd7125e2 _fini+0x971fd822(0x0, 0x0)
pc: 0xfffffd7ffd71280e _fini+0x971fda4e(0xb, 0xfffffd7f4e1dd4d0)
pc: 0xffffffffffffffff _fini+0x1284c6f(0x32f0000000c, 0x5c1c495f1)
pc: 0xfffffd7f65499b41 s_fetchGroup::s_fetchGroup #Nvariant 1(const s_bm*,int,s_index**,s_index**,dfp**,unsigned*,unsigned,s_aggInfo*,unsigned,vp_GroupedProjection*,df_Heap*,ThreadTimingStats*)+0x661(0x5c1af6038, 0x1)
pc: 0xfffffd7f654b5450 void vp_GroupedProjection::PrepareFetch(int)+0x2d4(0x1cc2a9eb4000, 0x5c0f73528)
pc: 0xfffffd7f65498190 void vp_Cursor::Execute()+0x94(0x0, 0x5c1b0bac8)
...

SAP IQ 16

KBA , BC-SYB-IQ , Sybase IQ , Problem