When migrating from MySQL 5.5/5.6 to PostgreSQL, an exception occurs when the column type is ENUM.

[Code-UV]

MySQL Version: 5.5 PostgreSQL Version: 14 ora2pg Version: 3.24.0 MySQL Table: CREATE TABLE Untitled ( test_id bigint(20) , test_set set('1','2') , test_enum enum('1','3') , test_year year(4) , test_bit bit(64), ) Definition exported using ora2pg： CREATE TABLE Untitled ( test_id bigint, test_set text, test_enum，1, test_year smallint, test_bit bit(64), ) Error: The type of the column is enum, but it was converted to 1. The code that triggers this phenomenon is line 415 of MySQL. pm:

If ($row ->[1] eq 'enum'){
$row ->[1]=$row ->[-2];
}

This should be:

If ($row ->[1] eq 'enum'){
$row ->[1]=$row ->[-1];
}

[Code-UV]

When MySQL is 5.5/5.6, $row->[-2] is empty string；When MySQL > 5.7, $row->[-1] is empty string。

[darold]

Commit 49f7889 should fix the issue, please confirm.