Schema Comparison 7.4.201 – identical objects shown as different

[Sławek]

Some identical tables are shown as different and there is no difference shown explicitly in the source/target split window and there is really no difference between the DDL scripts.

It does not occur in 7.2.78 (used for the same physical databases !)

[alexa]

Could you please execute the queries below against the Source and Target servers and provide us the generated CREATE definitions for the tables you are experiencing issues with:

Code: Select all

SHOW CREATE TABLE <table_name>;

Also, please specify the versions of the Source and Target servers.

[Sławek]

I found out that the DDL scripts of the tables concerned are different.

It means that my statement that they are identical was false.
Anyway, the statement was based on the identical content displayed in the source/target windows in the "Compare Schema" interface.

The conclusion is that there is a bug in 7.4.201 (I suppose it concerns also other 7.3 and 7.4 releases) causing displaying improper content for some objects.

[alexa]

We would still need the CREATE definitions of the tables so we can reproduce the issue on our side.

Also, please specify the versions of the compared Source and Target servers.

You can send a reply straight to our support system at alexaATdevartDOTcom and supportATdevartDOTcom .