2654265 - Data Assurance is not comparing floats correctly - SRS

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
go
         id                                  a                                       b                                          c                         d
----------- --------------------------- -------------------------------      ----------------------------   ------------------
          1                     182.27972          182.27972650000000         182.279726499999980           182.27972

• From ASE:

select * from test_float
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.
• The same problem may exists with other systems, for example:
• ASE to ASE on a different Operating System Platform
• ASE to Oracle

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

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