Bug #49289 ALTER ROUTINE wizard fail
Submitted: 1 Dec 2009 19:28 Modified: 14 Dec 2009 18:10
Reporter: Todd Farmer (OCA) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench Severity:S2 (Serious)
Version:5.2.10 r4680 OS:Windows (XP)
Assigned to: Alexander Musienko CPU Architecture:Any
Tags: regression

[1 Dec 2009 19:28] Todd Farmer 
Description:
Using the ALTER ROUTINE wizard to modify an existing routine now fails in 5.2.10 where it did not in 5.2.9.  Specifically noted:

1.  Missing DELIMITER $$ statement
2.  Missing DROP PROCEDURE IF EXISTS statement

Resulting DDL script fails.

How to repeat:
Try ALTER ROUTINE wizard.
[4 Dec 2009 0:45] Dave Nechodom 
Created new procedure by changing name of existing one. In this instance the "DELETE PROCEDURE ..." command was included before the "CREATE PROCEDURE ...". When attempting to apply changes, got error 1064. To correct errors:
Add "delimiter $$" at beginning.
Add "$$" after "DELETE PROCEDURE IF EXISTS ...".
Add "$$" after the last "END".
Add "delimiter ;" at end of script.
[9 Dec 2009 10:00] Mathieu Massebœuf 
I confirm this bug on MacOSX as well.
[11 Dec 2009 15:17] Johannes Taxacher 
this has been fixed. fix will be included in 5.2.11
[14 Dec 2009 18:10] Tony Bedford 
An entry was added to the 5.2.11 changelog:

In the SQL Editor, using the Alter Routine wizard to generate a script to modify an existing routine in the live database results in errors, due to incorrect script code being emitted. For example, the statement DELIMITER $$ was missing from the start of the script.