MySQL Bugs: #11357: Unable to create stored procedure

Bug #11357	Unable to create stored procedure
Submitted:	15 Jun 2005 17:20	Modified:	27 Jun 2005 14:33
Reporter:	Christopher Hazlett	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Query Browser	Severity:	S3 (Non-critical)
Version:	1.1.10	OS:	Windows (XP Pro)
Assigned to:	Vladimir Kolesnikov	CPU Architecture:	Any

Description:
When utilizing the script window to create a Stored Procedure, the automatically inserted text "DELIMITER $$" causes the script to error, and fail upon execution.  Changing the delimiter to a different delimiter does not change the error.

However, upon entering the same SQL into the command line interface, the script works fine. 

How to repeat:
Engage the Create Stored procedure dialog box from the shortcut menu.  After giving the stored procedure a name, create a simple procedure and attempt to execute the script.

It should fail on the first line that has "Delimiter" in it.

Suggested fix:
If the Delimiter statement is unneeded from within the browser, than eliminate its automatic insertion at the beginning and end.

Otherwise, correct the inaccurate error report.

1) selected create proceudre/function from menu
2) entered thetest

got:

DELIMITER $$

DROP PROCEDURE IF EXISTS ``.`thetest`\\
CREATE PROCEDURE ``.`thetest` ()
BEGIN

END$$

DELIMITER ;

it leads syntax error on \\

Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html