MySQL Bugs: #57645: Option to ignore stored procedure DEFINER when generating Catalog Diff Report

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:	Windows (XP)
Assigned to:		CPU Architecture:	Any

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.

Thank you for the feature request.

+1

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.