incorrect data type mapping for mysql->postgres sync

[ardabeyazoglu]

Summary

Airbyte mysql source to postgres sync creates "boolean" columns on destination for "tinyint" columns in mysql. This is incorrect. tinyint is 8-bit column that can take 256 values while boolean is 0-1, and it may cause data loss. I think tinyint should be smallint/int2 on postgres, which is the closest data type.

I set up a self-hosted airbyte to see if it is the same, and it made all integer columns bigint in postgres, regardless of the size. This is also inconvenient but at least it is safe to use.

System configuration and versions

Jitsu next 2.9 airbyte/mysql 3.11.9