Default ignored on database comparison

[molino]

Hello,

just compared two databases. First database has default values on some columns set to 0, the other database has no default values declared. In the options it is not set to ignore default values.
The comparison returns no differences on both tables.

[alexa]

If the table was created without DEFAULT, by default it will be given DEFAULT NULL value. When adding data into such a table, the column will contain an empty value.

If, you have set DEFAULT 0 for such a column, the default value will be 0 upon adding data into the table.

In case you want to ignore the differences, you have to select the "Ignore column default values" option.

[mirunek]

If the table was created without DEFAULT, by default it will be given DEFAULT NULL value. When adding data into such a table, the column will contain an empty value.

If, you have set DEFAULT 0 for such a column, the default value will be 0 upon adding data into the table.

In case you want to ignore the differences, you have to select the "Ignore column default values" option.

Hello alexa,
molino ask for some different... I have the same problem:

Table1: (sql text in comparison result)
phone2 VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_czech_ci NOT NULL DEFAULT '',
Table2: (sql text in comparison result)
phone2 VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_czech_ci NOT NULL,

Comparison result show "no diferrences", table is the same and its not posible generate diferrence script, but this is huge difference (and in text fields is seen that table declaration is different).
Comparison have "Ignore column default values" UNCHECKED, so comparator should see this difference and see it (at least in text), but table is inaccurately included in section EQUAL.

dbForge studio for Mysql version 8.0.108 trial.

[alexa]

Thank you for the information.

We were able to reproduce this issue and will fix it in one of the next product builds. We will notify you once it's available for downloading.