2993854 - Query spid becomes stuck in compiling state and never finishes - SAP ASE

• After migrating to ASE 16.0 SP02 PL09 HF1, spid from query never finishes
• Query worked fine in ASE 15.7 SP140
• Not able to kill spid in isql using:
  kill XXX
• Not able to kill spid from application side
• dbcc stacktrace(XXX) - shows
  pc: 0x0000000001f79e8f upyield+0x28f()
  pc: 0x0000000001bb31c2 memalloc+0x772()
  pc: 0x0000000001fe2da8 CgEvals::_CgCompOp(tree*)+0x118()
  pc: 0x0000000001fe3127 CgEvals::_CgCompLogOp(tree*)+0xa7()
  pc: 0x0000000001fe1c4e CgEvals::_CgCompExpr(tree*)+0xee()
  pc: 0x000000000191a413 EvalConstExpr(tree*, proc_hdr*, proc_hdr*, int, int)+0x63()
  pc: 0x000000000187e6f0 IsOrSarg(tree*, PesState*, short, bool, bool)+0x18d0()
  pc: 0x000000000171be82 PecConjPredicate::_PecCompareValue(PecConjPredicate&, int)+0x92()
  pc: 0x000000000171e7af PecConjPredicate::PecChoseBetterBound_PLT_PGE(PesState*, PecConjPredicate&, int, ColCmpType, PeCompareValueCode)+0xcf()
  pc: 0x000000000171e8ba PecConjPredicate::PecChoseBetterBound_PGE_PLT(PesState*, PecConjPredicate&, int, ColCmpType, PeCompareValueCode)+0x2a()
  pc: 0x000000000171ef58 PecConjPredicate::PecChoseHeteroBound(PesState*, PecConjPredicate&, int, ColCmpType)+0xf8()
  pc: 0x0000000001874183 RgInterval::_AnyFinalRefineRange(_STL::_List_iterator<PecConjPredicate*, _STL::_Nonconst_traits<PecConjPredicate*> >, _STL::_List_iterator<PecConjPredicate*,
  _STL::_Nonconst_traits<PecConjPredicate*> >)+0x1a3()
  pc: 0x0000000001874448 RgInterval::AnyRefineEachList()+0xd8()
  pc: 0x0000000001871e75 AnyInterval::AnyRefineAndCrtColBounds()+0x45()
  pc: 0x000000000171cb4a PesState::PesRefinePredList(OptBlock*)+0xea()
  pc: 0x00000000018b942f OptBlock::OptDoPredElim()+0x7f()
  pc: 0x000000000167bfdf OptCriteria::ocInit(int)+0x80f()
  pc: 0x000000000167847d OptGlobal::_GblSearchEngine(int*)+0x33d()
  pc: 0x0000000001679069 OptGlobal::GblOptimize(int*)+0x239()
  pc: 0x0000000001679f0b Optimize+0x1bb()
  pc: 0x0000000001d94474 s_compile_stmt+0x784()
  pc: 0x0000000001d918e1 s_compile+0x8f1()
  [Handler pc: 0x0x0000000001e072f0 hdl_stack installed by the following function:-]
  [Handler pc: 0x0x0000000001dcd500 s_handle installed by the following function:-]
  pc: 0x0000000001dd14c7 sequencer+0x8c7()
  pc: 0x00000000015e0c0f tdsrecv_language+0x1df()
  [Handler pc: 0x0x0000000001f0d010 ut_handle installed by the following function:-]
  pc: 0x00000000015f54f8 conn_hdlr+0xf18()
  
  

SAP Adaptive Server Enterprise (ASE) 16.0

KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed