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

Wrong change in translation of "is not null" clause (regression in release 24.3) #1787

Closed edelanoe closed 1 month ago

edelanoe commented 1 month ago

Hello Darold,

When I tried release 24.3, I saw a new way of translating "IS NOT NULL" clause: It once was "(myVar IS NOT NULL AND myVar::text <> '') Now I see "(myVar AND myVar::text <> '')

It looks like a change linked to boolean variables or columns...

I attach a small probe package zip with 3 files: Oracle, migrated with ora2pg 23.1 and migrated with ora2pg 24.3. (you will see that this sample code is common with my previous issue)

Best Regards, Eric PCK_PROBE-20240530.zip

darold commented 1 month ago

This is a regression, commit 7e52fa7 solves this issue.