Allow Schema Comparison to ignore differences in integer "size"
In versions of MySQL prior to 8.0, integer values were specified with a "size", such as "INT(11)". In MySQL 8.0 and newer, the size property of integers is removed, resulting in the same value having the type "INT". This results in Schema Comparison across MySQL versions (5.7 vs 8.0) reporting false-positive differences for tables.
The "ignore data types" option in Schema Comparison does not resolve the false positives, and is also probably too blunt, because column size does matter for text and binary data. Please add an option to specifically ignore differences in the "size" of integers.
-
AdminDevart (_, Devart) commented
Dear User,
Thank you for your post!
We want to assure you that our team is aware of this issue and they are working on it.
As soon as we have any new information, we'll be in tough right away.
Best,
Devart Team