3191222 - Various stack patterns linked to complex queries with large number of joins - SAP ASE

• Various stack patterns linked to complex queries with large number of joins
• A common aspect is inclusion of module SsNeHyPerm, but this not always seen
• Below a number of patterns that have been reported when query is complex and number of joins is 6 or (much) greater
• A signal 11 (SIGSEGV) is raised and the address line may be empty or contain any of the sample code functions below
  
  Current process (0x573b5c98) infected with signal 11 (SIGSEGV)
  Address 0x0x0000000000000080 ()
  or (for example)
  Address 0x0x0000000000000080 (SsNeHyPerm::_SsNeHyPsEvalNCostOrdTree)
  
  

1. SsNeHyPerm::_SsNeHyPsEvalNCostOrdTree
   SsNeHyPerm::SsNeEvalMinorState
   SearchStratNodeElem::SsNeFindOptimal
   SsNeHyPerm::SsNeEvalMinorState
   SeHyPermStrat::SeEvalMajorState
   SearchEngine::SeFindOptimalOptBlockPlan
   
   
2. PopBase::popCompress
   PopRidJoin<ParallelCost, ParallelProps>::_popAvailPartCompute
   TopLogProps0::printlong
   EqcN::eqcJoin(EquivClass*, EquivClass*, int, bool)
   SsNeHyPerm::_SsNeHyPsEvalNCostOrdTree
   SsNeHyPerm::SsNeEvalMinorState
   
   
3. PopBase::popExpand(TopLogProps*)
   PopRidJoin<ParallelCost, ParallelProps>::_popAvailPartCompute()
   Pop<SerialCost, SerialProps>::popEnforceAll()
   EquivClass::eqcEagerEnforce()
   SsNeHyPerm::_SsNeHyPsEvalNCostOrdTree()

SAP Adaptive Server Enterprise (ASE) 16.0

KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Known Error