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.