3339850 - Erro 702 / 724 or signal 11 with treecpynames in stack on a query with views - SAP ASE

• A query involving views that include derived tables with UNION/UNION ALL
• Causes error 702, error 724 and/or a signal 11 (SIGSEGV) in treecpynames
• Examples or error sequences
  
  

1. Signal 11
   
   Current process (0x4f0028) infected with signal 11 (SIGSEGV)
   Address 0x0x00000000020e28b8 (treecpynames+0x18), .....
   
   with stack trace including modules:
   
   treecpynames
   cpynamelist
   tree_copynames
   vu_viewcopy
   vu_getviewdefn
   vu_analyze_view
   vu_call_analyze_view
   vu_view_driver
   vu_maincmdloop
   vu_findviews
   vu_res_view
   pre_aggview
   
   
2. Error 702
   
   Error: 702, Severity: 20, State: 1
   Memory request for 1701077384 bytes exceeds the size of single page of 16384 bytes.
   
   
3. Error: 724, Severity: 20, State: 1
   Internal Error: Function 'memalloc' was passed an illegal size value (-330229738)
   
   with stack trace including modules:
   
   exc_raise
   memalloc
   treecpynames
   cpynamelist
   tree_copynames
   vu_viewcopy
   vu_getviewdefn
   vu_analyze_view
   vu_call_analyze_view
   vu_view_driver
   vu_maincmdloop
   vu_findviews
   vu_res_view
   pre_aggview

SAP Adaptive Server Enterprise (ASE) 16.0

CR828068, CR#828068, #828068 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem