search

darold / ora2pg

Ora2Pg is a free tool used to migrate an Oracle database to a PostgreSQL compatible schema. It connects your Oracle database, scan it automatically and extracts its structure or data, it then generates SQL scripts that you can load into PostgreSQL.
http://www.ora2pg.com/
GNU General Public License v3.0
978 stars 341 forks source link

TEST_DATA findings for numeric values due to leading zero #1741

Closed es99-24 closed 4 months ago

es99-24 commented 4 months ago

As we couldn't find any hints in forums/net we're not sure where the problem is but assume a bug: when validating our migration with TEST_DATA mode we get error reported in the "fail"-section of the logfile like these:

ORACLEDB:TAB1:94:[001B4352-D3A4-45B8-8810-D6C379E7C92E|-.1507542214422403215046131208509905263781 POSTGRES:TAB1:94:[001B4352-D3A4-45B8-8810-D6C379E7C92E|-0.1507542214422403215046131208509905263781

Obviously the difference lies in the missing leading "0" for the PG-Value of the second column, which is a "numeric" (the first column is a varchar and the PK of the table). As there are also positive fractional "0.xxx" values in the table, which are not in the error-logfile, we assume this problem only occurs with negative values of x where: "-1 < x < 0"

Did we miss something or might this be a bug?

darold commented 4 months ago

This is now fixed by commit e164622.

es99-24 commented 4 months ago

Thanks a lot, Darold!