MySQL Bugs: #40333: QB adds "DROP PROCEDURE" when edits FUNCTION

Bug #40333	QB adds "DROP PROCEDURE" when edits FUNCTION
Submitted:	26 Oct 2008 8:07	Modified:	25 Feb 2009 14:21
Reporter:	Sveta Smirnova	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Query Browser	Severity:	S3 (Non-critical)
Version:	1.2.12	OS:	MacOS
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
Query Browser adds "DROP PROCEDURE" clause instead of "DROP FUNCTION" when edits stored function. This leads to "function exists" error.

How to repeat:
1. Create a function in the test database.
2. Connect to test database using Query Browser
3. Right-click function, choose "Edit Stored Procedure"
4. Find in the Script view:

DROP PROCEDURE IF EXISTS `f1`;
DELIMITER $$
CREATE DEFINER=`root`@`localhost` FUNCTION `f1`(seed  VARCHAR(100)) RETURNS int(11)
BEGIN
.....

Suggested fix:
s/DROP PROCEDURE/DROP FUNCTION/

Thank you for your bug report. This issue has already been fixed in the latest released version of that product, which you can download at

  http://www.mysql.com/downloads/