When running the Data Compare tool to compare the records in a table on source and target databases, it returned wrong data comparison result.
It looks like the Data Compare tool chose the wrong record with different primary key. The same record with same primary key value exists on source and target database.
For example, the correct primary key value is 1334644304804724, but data comparison chose the primary key value is 1334644304804723.
It looks like the Data Compare tool is comparing the primary values with a scientific notation format (1.33464430480472E15).
