2329204 - Arithmetic overflow occurred when calling two user define functions - SAP ASE

• Run the two SQL statements in the following order, different errors are reported on ASE 15.7 SP136 and ASE 16.0:

select dbo._validate_iban(' ')
select dbo._validate_iban('BE58973134698779')

1. in ASE 15.7 SP136, the second call gives the 'arithmetic overflow' error.
2. in ASE 16 SP02PL03, the second call encounter signal 11 and ASE server crashed with this signal 11.

• For ASE 15.7 SP136:

1> select dbo._validate_iban(' ')
2> select dbo._validate_iban('BE58973134698779')
3> go
                                                                                                     
 ----------------------------------------------------------------------------------------------------
 Fout

(1 row affected)
Msg 3606, Level 16, State 0:
Server 'test_157', Procedure '_validate_iban', Line 20:
Arithmetic overflow occurred.

• For ASE 16 SP02 PL03:
          
        Receive "Infected with signal 11" in the com__exctnume_copy() module with stack trace:

Current process (0x250013) infected with signal 11 (SIGSEGV)
Address 0x0x0000000001f4f8c7 (com__exctnume_copy+0x77), siginfo (code, address) = (1, 0x0x0000000151702000)

Modules seen on the ASE stacktrace include:

com__exctnume_copy
mod_numeric
LeRun

• SAP Adaptive Server Enterprise 15.7 SP136
• SAP Adaptive Server Enterprise 16.0

com__exctnume_copy,Msg 3606,Arithmetic overflow , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed