Data migration from mysql to postgres is not converting the datatype smallint(mysql) to Boolean(postgres)

[hero78]

While migrating from mysql Database to Postgres. The Data type smallint which is meant to capture values like 1,0 (True/false respectively) is failing to be coverted to BOOLEAN. In Postgres it's maintained as Smallint

[manakov-dev]

In my case it was tinyint and adding

    "tinyint" : {
        "increased_size"           : "boolean",
        "type"                     : "boolean",
        "mySqlVarLenPgSqlFixedLen" : true
    },

to the data_types_map.json helped. But check that you use Smallint only for boolean values before this hack.

[hero78]

Thanks @manakov-dev . This helped. We can close this Ticket