Schema Comparison 7.4.201 – identical objects shown as different

Discussion of open issues, suggestions and bugs regarding database management and administration tools for MySQL
Post Reply
Sławek
Posts: 9
Joined: Tue 06 Mar 2018 14:34

Schema Comparison 7.4.201 – identical objects shown as different

Post by Sławek » Thu 26 Apr 2018 08:56

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
Devart Team
Posts: 2830
Joined: Fri 24 Jun 2011 14:17

Re: Schema Comparison 7.4.201 – identical objects shown as different

Post by alexa » Thu 26 Apr 2018 09:43

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
Posts: 9
Joined: Tue 06 Mar 2018 14:34

Re: Schema Comparison 7.4.201 – identical objects shown as different

Post by Sławek » Thu 26 Apr 2018 14:00

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
Devart Team
Posts: 2830
Joined: Fri 24 Jun 2011 14:17

Re: Schema Comparison 7.4.201 – identical objects shown as different

Post by alexa » Fri 11 May 2018 08:06

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 .

Post Reply