Procedure comparison lists procedures without differences

[erikav]

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.

[alexa]

Could you please provide us the CREATE definitions of the compared procedures being generated with standard MySQL tools or with some third-party tools, but not with dbForge?

To make sure your data is kept confidential, please send a reply straight to our support system at supportATdevartDOTcom, and we will keep further correspondence with you on this issue via that system.