Procedure comparison lists procedures without differences
Posted: Wed 13 Nov 2013 11:11
I have the same set of DBs/tables/procedures on 6 different MySQL servers, and just bought schema compare to ease the synchronization work. However, there seems to be a bug in procedure comparison, as I have quite a few procedures listed as different, but no actual differences showing up. This seems to be connected with MySQL server versions, and the columns present in "show create procedure" result.
For a 5.0.90 server, show create procedure lists 3 columns: Procedure, sql_mode, Create Procedure
For a 5.1.57 server, show create procedure lists 6 columns: Procedure, sql_mode, Create Procedure, character_set_client, collation_connection, Database Collation
The actual procedure content and definer is equal.
Is this something that can/will be handled correctly in the near future? Optimally, I'd like to see an option that decides whether these procedures should be listed as different (of course, with the actual difference visible somewhere) or whether these procedures should be considered equal by disregarding information available in only one of the server versions.
For a 5.0.90 server, show create procedure lists 3 columns: Procedure, sql_mode, Create Procedure
For a 5.1.57 server, show create procedure lists 6 columns: Procedure, sql_mode, Create Procedure, character_set_client, collation_connection, Database Collation
The actual procedure content and definer is equal.
Is this something that can/will be handled correctly in the near future? Optimally, I'd like to see an option that decides whether these procedures should be listed as different (of course, with the actual difference visible somewhere) or whether these procedures should be considered equal by disregarding information available in only one of the server versions.