SAP Knowledge Base Article - Preview

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

Symptom

  • 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()


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 16  

Product

SAP Adaptive Server Enterprise 16.0

Keywords

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

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.