2965623 - spid hanging in COMPILING status when executing a disjoint sql with like and or operators

• ASE spid hanging in COMPILING status when executing a disjoint sql with like and or operators
• SQL similar to (select dbid from sysdatabases where name like "m%" or name like "t%" and name like "s%") 
• You can see in sp_who

0      17     runnable         sa               sa         xxx34411371a                     0         test_db
         tempdb               COMPILING                   0            syb_default_pool

• dbcc stacktrace(17)

upyield
memalloc
memalloc_zero
mk_constant
IsOrSarg(tree*, PesState*, short, bool, bool)
IsOrSarg(tree*, PesState*, short, bool, bool)
PecConjPredicate::_PecCompareValue(PecConjPredicate&,int)
PecConjPredicate::PecChoseBetterBound_PLT_PGE(PesState*,
PecConjPredicate&, int, ColCmpType, PeCompareValueCode)
PecConjPredicate::PecChoseBetterBound_PGE_PLT(PesState*,
PecConjPredicate&, int, ColCmpType, PeCompareValueCode)
PecConjPredicate::PecChoseHeteroBound(PesState*,
PecConjPredicate&, int, ColCmpType)+0xf8()
MrgInterval::_AnyFinalRefineRange(_STL::_List_iterator<OptList<PecConjPredicate*>*, _STL::_Nonconst_traits<OptList<PecConjPredicate*>*> >, _STL::_List_iterator<PecConjPredicate*, _STL::_Nonconst_traits<PecConjPredicate*> >, _STL::_List_iterator<PecConjPredicate*, _STL::_Nonconst_traits<PecConjPredicate*> >)
MrgInterval::AnyRefineEachList()
AnyInterval::AnyRefineAndCrtColBounds()
PesState::PesRefinePredList(OptBlock*)
OptBlock::OptDoPredElim()
OptCriteria::ocInit(int)
OptGlobal::_GblSearchEngine(int*)
OptGlobal::GblOptimize(int*))
Optimize+0x1d4()
s_compile_stmt+0x8d1()
s_compile+0xa47()

SAP Adaptive Server Enterprise (ASE) 16  

disjoint,l ike, or, compiling, IsOrSarg, PecConjPredicate, CR 822682, CR822682, 822682 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed