2049286 - A select statement raises a signal 11 @ address (memhilo+0x12), siginfo (code, address) = (128, 0x(nil)) process terminates - SAP ASE

• Failure of a query that uses the same correlation name for multiple columns.
• An infected with signal 11 error and  stacktrace is output to the errorlog and the process will exit each time it is executed:
   
  select col1,col2,col3, col4,col5,col6, dbo.f_udf( 'BG',col7,col8,col9) as [xxx-BG],
  dbo.f_udf( '01',col7,col8,col9) as [xxx-01], dbo.f_udf( '02',col7,col8,col9) as [xxx-02],
  dbo.f_udf( '03',col7,col8,col9) as [xxx-03], dbo.f_udf( '04',col7,col8,col9) as [xxx-04],
  dbo.f_udf( '05',col7,col8,col9) as [xxx-05] ,dbo.f_udf( '06',col7,col8,col9) as [xxx-06],
  dbo.f_udf( '07',col7,col8,col9) as [xxx-08], dbo.f_udf( '08',col7,col8,col9) as [xxx-08],
  dbo.f_udf( '14',col7,col8,col9) as [xxx-08] from item_table where item_id = '0123456789' and cfg_code = '40x'
   
• Client side error: ASE is terminating this process
   
• From the ASE Errorlog:
  
  Current process (0x160016) infected with signal 11 (SIGSEGV)
  Address 0x0x00000000019fe302 (memhilo+0x12), siginfo (code, address) = (128, 0x(nil))
  ************************************
  SQL causing error : select col1, col2, col3...
  curdb = 4 tempdb = 2 pstat = 0x10000 p2stat = 0x101000
  p3stat = 0x800 p4stat = 0x0 p5stat = 0x8 p6stat = 0x10 p7stat = 0x10000
  lasterror = 0 preverror = 0 transtate = 1
  curcmd = 0 program = isql
  extended error information: hostname: test login: sa

pcstkwalk+0x30()
ucstkgentrace+0x1a5()
ucbacktrace+0x43()
terminate_process+0xd9f()
kisignal+0x356()
memhilo+0x12()
find_dup_corrname+0x1b2()
yyparse+0x181c()
00013afc90 pars_hdl installed by the following function:-]
sqlpars+0x357()
tdsrecv_language+0x70()

SAP Adaptive Server Enterprise (ASE) 15.5

find_dup_corrname, stack trace, signal 11 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed