Red Gate forums :: View topic - Comparison keeps flagging index changes
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
MySQL Compare
MySQL Compare forum

Comparison keeps flagging index changes

Search in MySQL Compare forum
Post new topic   Reply to topic
Jump to:  
Author Message
bstewart



Joined: 31 Jul 2012
Posts: 11

PostPosted: Wed Oct 17, 2012 11:58 am    Post subject: Comparison keeps flagging index changes Reply with quote

I'm currently using a development database which is running the following MySQL version:

protocol_version;10
version;5.1.46-community
version_comment;MySQL Community Server (GPL)
version_compile_machine;unknown
version_compile_os;Win64

The UAT server I'm deploying to is as follows:

protocol_version;10
version;5.5.24-0ubuntu0.12.04.1
version_comment;(Ubuntu)
version_compile_machine;x86_64
version_compile_os;debian-linux-gnu

Whenever I do a compare between these two databases, any table with an index will get flagged as being changed. In the MySQL compare GUI when looking at the comparison between the CREATE statements for the two tables, the only difference is in the database prefix before the table name. However, the deployment script just contains a load of statements like this:

Code:
DROP INDEX `idx_usergroup_adjacency_lookup` ON `scie-uat`.`jos_usergroups`;
CREATE INDEX `idx_usergroup_adjacency_lookup` ON `scie-uat`.`jos_usergroups`(`parent_id`);
DROP INDEX `idx_usergroup_nested_set_lookup` ON `scie-uat`.`jos_usergroups`;
CREATE INDEX `idx_usergroup_nested_set_lookup` ON `scie-uat`.`jos_usergroups`(`lft`, `rgt`);
DROP INDEX `idx_usergroup_title_lookup` ON `scie-uat`.`jos_usergroups`;
CREATE INDEX `idx_usergroup_title_lookup` ON `scie-uat`.`jos_usergroups`(`title`);


Regardless of how many times I run the deployment, it always thinks those same tables have changes and generates similar DROP INDEX/CREATE INDEX statements in the deployment.

Any ideas how I can fix this?
Back to top
View user's profile Send private message
Michael Christofides



Joined: 20 Apr 2011
Posts: 94
Location: Red Gate Software

PostPosted: Thu Oct 18, 2012 5:34 pm    Post subject: Reply with quote

Thanks for the report. Could you check you're using the latest version (Help -> Check for updates) and if not update and try again.

Apologies for the inconvenience, I'll look into whether this is something we thought we'd fixed.
Back to top
View user's profile Send private message
bstewart



Joined: 31 Jul 2012
Posts: 11

PostPosted: Fri Oct 19, 2012 8:13 am    Post subject: Reply with quote

Sorry, I should have mentioned the version number. 1.0.0.409 which should be the latest version (running on Win 7 Enterprise SP1 x64).
Back to top
View user's profile Send private message
Michael Christofides



Joined: 20 Apr 2011
Posts: 94
Location: Red Gate Software

PostPosted: Fri Oct 19, 2012 3:55 pm    Post subject: Reply with quote

No problem, thank you.

I'm afraid it looks like its an bug we'll need to fix in the tool. Please do let me know if you're evaluating or an existing customer. Feel free to email us at mysql@red-gate.com
Back to top
View user's profile Send private message
helrod



Joined: 15 Nov 2012
Posts: 1

PostPosted: Thu Nov 15, 2012 12:12 am    Post subject: Exact same problem Reply with quote

I see the exact same issue. Also running 1.0.0.409 (trial). Also running Windows 7 64-bit. Against MSSQL

It's kind of a deal-breaker, as in this schema, I get about 200 false positive changes because there's an index -- even though the index is identical. Toad doesn't seem to have this problem.
Back to top
View user's profile Send private message
Michael Christofides



Joined: 20 Apr 2011
Posts: 94
Location: Red Gate Software

PostPosted: Thu Nov 15, 2012 2:07 pm    Post subject: Reply with quote

Thanks for letting us know helrod, I'll update here when we have a fix available.

When you say "Against MSSQL", what do you mean? I've normally seen this as the abbreviation of Microsoft SQL Sever.
Back to top
View user's profile Send private message
Michael Christofides



Joined: 20 Apr 2011
Posts: 94
Location: Red Gate Software

PostPosted: Mon Dec 10, 2012 8:25 pm    Post subject: Reply with quote

Thanks all for your patience, this issue has now been fixed. You can get the latest versions by checking for updates within the tool or from our website here:
http://downloads.red-gate.com/MySQLComparisonBundle.exe
Back to top
View user's profile Send private message
bstewart



Joined: 31 Jul 2012
Posts: 11

PostPosted: Tue Dec 11, 2012 10:47 am    Post subject: Re: Reply with quote

Michael Christofides wrote:
Thanks all for your patience, this issue has now been fixed. You can get the latest versions by checking for updates within the tool or from our website here:
http://downloads.red-gate.com/MySQLComparisonBundle.exe


I downloaded the latest version (1.0.0.425) and the issue appears to be resolved. Thanks for the update Michael.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group