3401253 - SUM() gives different result from 2 tables which have the same data - SAP ASE

• The 2 tables test_sql_decomp & test_sp_decomp have the same data in column ul_mv
• The 2 tables test_sql_decomp & test_sp_decomp have the same table shema, like this:-
  Column_name     Type          Length Prec Scale Nulls Not_compressed Default_name Rule_name Access_Rule_name Computed_Column_object Identity
  --------------- ------------- ------ ---- ----- ----- -------------- ------------ --------- ---------------- ---------------------- ----------
  pnl_date        smalldatetime      4 NULL  NULL     0              0 NULL         NULL      NULL             NULL                            0
  ......
  ul_mv           float              8 NULL  NULL     1              0 NULL         NULL      NULL             NULL                            0
• SUM() gives different result:
  

  fsql-1) select sum(ul_mv) ul_mv from test_sql_decomp
  fsql-2) select sum(ul_mv) ul_mv from test_sp_decomp
  fsql-3) go
                              ul_mv
  ---------------------------------
                  2.12617123907e-09

  (1 row affected)
                              ul_mv
  ---------------------------------
                 -1.01158548205e-09

  
  
  

SAP ASE 16.0

KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , Problem