SAP Knowledge Base Article - Preview

2654265 - Data Assurance is not comparing floats correctly - SRS

Symptom

In Data Assurance (DA), comparing data sets from SAP Adaptive Server Enterprise (ASE) to SAP IQ (IQ), float data with high precision is not reconciled.

From IQ:

select * from test_float
         id              a                           b                           c              d
-------------------------------------------------------------------------------------------------
          1      182.27972          182.27972650000000         182.279726499999980      182.27972

From ASE:

1> select * from test_float
2> go
 id          a                           b         c                            d
 ----------- --------------------------- ----------------------------         ---------------------------- ---------------------------
           1                  182.279726           182.27972649999998                  182.279726499999980                  182.279724

After the comparison, the data in IQ is not reconciled.


Read more...

Environment

SAP Replication Server (SRS) Data Assurance (DA) Option, version 15.7.1 SP 306

Product

SAP Replication Server 15.7 ; SAP Replication Server 16.0

Keywords

KBA , BC-SYB-REP , Sybase Replication Server (standalone) , Bug Filed

About this page

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

Search for additional results

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