Bug #57645 Option to ignore stored procedure DEFINER when generating Catalog Diff Report
Submitted: 22 Oct 2010 3:33 Modified: 13 Nov 2014 2:10
Reporter: Zbigniew Helak Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench: Modeling Severity:S4 (Feature request)
Version:5.2.27 OS:Microsoft Windows (XP)
Assigned to: CPU Architecture:Any

[22 Oct 2010 3:33] Zbigniew Helak
Description:
The "Catalog Diff Report" generated for two live database servers works well for tables but it is often useless for stored procedures and functions. This is due to the DEFINER part being different for my two servers. One of them is local development server (DEFINER='user'@'%'), the other one is my live server in a shared hosting environment (DREAMHOST.COM, DEFINER='user'%.abc.verizon.net'). Even though stored procedures may by identical in names, parameters and body - the definer portion being returned by the servers causes compare function to fail and always lists effectively all stored procedures as being different in the two environments. 

I would like to have an option to ignore the DEFINER part and be able to compare only the differences in the body and parameters of the procedures and functions. 

How to repeat:
Create two sets of identical stored procedures in two different hosting environments, e.g. local server and on-line shared hosting environment.

Suggested fix:
Have an option to ignore the DEFINER part and be able to compare only the differences in the body and parameters of procedures and functions.
[22 Oct 2010 4:10] Valeriy Kravchuk
Thank you for the feature request.
[11 Apr 2011 10:18] Francois-Louis Mommens
+1
[13 Nov 2014 2:10] Philip Olson
Posted by developer:
 
Fixed as of the upcoming MySQL Workbench 6.2.4 release, and here's the changelog entry:

A new " Skip checking of Routine Definer" option was added to the "Catalog
Diff Report" wizard. This improves functionality for stored procedures and
functions.

Thank you for the bug report.