2431691 - Signal 11 in OptGlobal::OptGlobal() or BmLight<VbmPeIdHidden>::~BmLight() and stacktrace raised by a query with multiple left joins - SAP ASE

• Signal 11 and an assertion error:
   
  Current process (0x1b000e) infected with signal 11 (SIGSEGV)
  Address 0x0x00000000008c90a7 (OptGlobal::OptGlobal(Node <Lop>*, tree*, OptPool*)+0x1742f), siginfo (code,address) = (1, 0x0x0000000000000008)
   
• Raised by a query with multiple left joins, for example:
   
  SELECT
          c.comment_id,
          c.comment_text,
          c.id_number,
          c.comment_type,
          c.date_added,
          dp.title,
          ci.content_item_id AS post_content_item_id,
          ci2.content_item_id AS board_content_item_id,
          isnull(cat.display_name, cat.category_name) AS board_name,
          (Case when (upper(e.first_name) like '[A-Z].' OR upper(e.first_name) like '[A-Z]')
                      then e.first_name + ' ' + e.middle_name + ' ' + e.last_name
              else e.first_name + ' ' + e.last_name
          end) as author_name,
            isnull(t.total_replies, 0) AS new_replies,
            isnull(a.pg_organization,'') AS pg_org
      FROM s2_comments c
      LEFT JOIN s2_content_items ci ON c.content_item_id=ci.content_item_id AND ci.content_type_id
      IN (SELECT c.content_type_id
           FROM s2_content_types c LEFT JOIN s2_content_types cp ON c.parent_content_type_id = cp.content_type_id
           WHERE cp.parent_content_type_id=37)
           LEFT JOIN s2_discussion_posts dp ON ci.content_item_foreign_key=dp.discussion_post_id
           LEFT JOIN s2_discussions d ON dp.discussion_id = d.discussion_id
           LEFT JOIN s2_content_items ci2 ON ci2.content_item_foreign_key=d.discussion_id AND ci2.content_type_id
           IN ( SELECT content_type_id FROM s2_content_types WHERE parent_content_type_id=37)
                LEFT JOIN s2_categories cat ON d.category_id=cat.category_id
                LEFT JOIN entity e ON c.id_number = e.id_number
                LEFT JOIN (
                 SELECT count(content_item_id)-1 AS total_replies, content_item_id FROM s2_comments
                 WHERE date_added<='2014-11-17 09:25:30.029'
                 GROUP BY content_item_id ) t ON c.content_item_id = t.content_item_id
                LEFT JOIN s_association a ON ci2.qualifier_value_char = a.association_id
                   WHERE c.comment_id=46809
   
• The stacktrace shows fucntions:
   
  OptGlobal::OptGlobal
  PopReptnIndScan<ParallelCost, ParallelProps>::popGenCgp
  CgpGlobal::CgpGenerate
  TpopTabScan::TpopTabScan
  CgpMergeJoin::_cgpInit

In later versions of ASE the stacktrace presents differently due to code changes in other areas. When testing against ASE 16.0 SP02 PL07 we see a stacktrace including these functions instead:

BmLight<VbmPeIdHidden>::~BmLight()
PopIndScan<SerialCost, SerialProps>::popGenCgp(OptMap<short, tree*, _STL::less<short> >*)
CgpGlobal::CgpGenerate()
Optimize

• SAP Adaptive Server Enterprise (ASE) 15.7 SP130 and higher
• SAP Adaptive Server Enterprise (ASE) 16.0 GA PL03 and higher

CR776404, 776404, CR#776404, OptGlobal, PopReptnIndScan, TpopTabScan, allrows_oltp_ase_default, allrows_oltp_ase_current, allrows_oltp_ase1503esd2, allrows_oltp_ase1503esd3 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed