MySQL Bugs: #22808: MySQL Administrator 1.2.3 rc does not allow me to edit existing stored procedure

Bug #22808	MySQL Administrator 1.2.3 rc does not allow me to edit existing stored procedure
Submitted:	29 Sep 2006 5:36	Modified:	27 Oct 2006 8:49
Reporter:	Edward Chan	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Administrator	Severity:	S2 (Serious)
Version:	1.2.3 rc	OS:	Windows (Windows XP SP2)
Assigned to:	Mike Lischke	CPU Architecture:	Any
Tags:	mysql administrator, stored procedure

Description:
The problem happens when I try to edit my existing stored procedures.
* This problem does not happen in MySQL Administrator 1.1.9, but it happens in the newer version (eg. MySQL Administrator 1.2.3 rc).

How to repeat:
1: Click on "Edit Stored Proc" button to edit any existing mysql stored procedure.
2: Click on "Execute SQL" button after finishing editing stored procedure
3: The following error message will prompt up.

==========================================================
Error while executing query

CREATE DEFINER='root'@'localhost' PROCEDURE 'SelectUser'()
BEGIN
  SELECT * FROM USER;
END

MySQL Error Number 1304
PROCEDURE SelectUser already exists

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 bug fix. More information about accessing the source trees is available at

    http://dev.mysql.com/doc/en/installing-source.html