SAP Knowledge Base Article - Preview

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

Symptom

  • 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




Read more...

Environment

SAP ASE 16.0

Product

SAP Adaptive Server Enterprise 16.0

Keywords

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

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.