3150632 - Large UNION ALL query report signal 11 at BmLight - SAP ASE

• A large select query with UNION ALL and many subquery terminated with Infected with signal 11.
• Errorlog report the following stacks which is an incorrect stack:
  
  Current process (0xaf32c42) infected with signal 11 (SIGSEGV)
  Address 0x0x000000000188de64 (Optimize+0x1b154), siginfo (code, address) = (2, 0x0x0000000003aa0290)
  pc: 0x000000000188de64 Optimize+0x1b154()
  pc: 0x0000000001a04e93 PopRidJoin<ParallelCost, ParallelProps>::_popAvailPartCompute()+0xb55b3()
  pc: 0x0000000001a0d05c PopRidJoin<ParallelCost, ParallelProps>::_popAvailPartCompute()+0xbd77c()
  pc: 0x0000000001a0b255 PopRidJoin<ParallelCost, ParallelProps>::_popAvailPartCompute()+0xbb975()
  pc: 0x0000000001a072fe PopRidJoin<ParallelCost, ParallelProps>::_popAvailPartCompute()+0xb7a1e()
  pc: 0x00000000019a331e PopRidJoin<ParallelCost, ParallelProps>::_popAvailPartCompute()+0x53a3e()
  pc: 0x0000000001fca257 CgpGlobal::CgpGenerate()+0xe7()
  pc: 0x0000000001873077 Optimize+0x367()
  pc: 0x0000000001da83a7 s_compile_stmt+0x787()
  pc: 0x0000000001da5811 s_compile+0x8f1()
  
  
  
• After translation using gdb on the addresses above, the correct stack is as followed:
  

  Current process (0xaf32c42) infected with signal 11 (SIGSEGV)
  Address 0x0x000000000188de64 (BmLight<VbmTcIdHidden>::BmLight), siginfo (code, address) = (2, 0x0x0000000003aa0290)
  pc: 0x00000000017fe0cc terminate_process+0x1b6c()
  pc: 0x0000000001305de2 kisignal+0x6fc()
  pc: 0x000000000188de64 BmLight<VbmTcIdHidden>::BmLight(BmManager<BmLight<VbmTcIdHidden>, BmObject<BmLight<VbmTcIdHidden> > >*)
  pc: 0x0000000001a04e93 PopBase::popGetFilterPred()
  pc: 0x0000000001a0d05c PopScalar<SerialCost, SerialProps>::popGenCgp(OptMap<short, tree*, _STL::less<short> >*) const
  pc: 0x0000000001a0b255 PopSubqNary<SerialCost, SerialProps>::popGenCgp(OptMap<short, tree*, _STL::less<short> >*) const
  pc: 0x0000000001a072fe PopMergeUnionAll<SerialCost, SerialProps>::popGenCgp(OptMap<short, tree*, _STL::less<short> >*) const
  pc: 0x00000000019a331e PopEmit<SerialCost, SerialProps>::popGenCgp(OptMap<short, tree*, _STL::less<short> >*) const
  pc: 0x0000000001fca257 CgpGlobal::CgpGenerate()+0xe7()
  pc: 0x0000000001873077 Optimize+0x367()
  pc: 0x0000000001da83a7 s_compile_stmt+0x787()
  pc: 0x0000000001da5811 s_compile+0x8f1()

  
   

SAP Adaptive Server Entreprise ASE 16 SP02 PL08 

BmLight,PopBase::popGetFilterPred,Optimize,PopRidJoin<ParallelCost, ParallelProps>::_popAvailPartCompute , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Known Error