MySQL Bugs: #36587: Editing Stored Procedures

Bug #36587	Editing Stored Procedures
Submitted:	8 May 2008 8:44	Modified:	8 Jun 2008 11:29
Reporter:	Ivan Tsankov	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Query Browser	Severity:	S3 (Non-critical)
Version:	1.1.2	OS:	Windows (XP SP2)
Assigned to:		CPU Architecture:	Any
Tags:	define stored procedures, edit stored proceduers, stored procedures

Description:
I'm using Mysql Query Browser v 1.1.2 (Mysql 5.0.45). I have created a stored procedure that I can manipulate in Mysql shell (view, alter, drop). The procedure is executable and dropable in Mysql Query Browser. But when I try to edit it in Mysql Query Browser the following error appears:
  No argument for format '%`' 
Parsing problem I guess. I haven't defined the owner explicitly (when creating the procedure) and when I check the 'show create procedure' in Mysql shell the following appears: 
  CREATE DEFINER=`user`@`192.168.20.3%` PROCEDURE `sent_msg`(MessageID int) ...
The problem seems to be caused by the privileges my user have for the range of ip addresses in the network.

Do you think that this could be fixed?

Thanks in advance.

How to repeat:
Create explicitly procedure owned by mysql user with all access privileges to host with ip like xxx.xxx.xxx.3% or any range of ip addresses with similar definition.

Suggested fix:
Escape the '%' characters somehow when parsing the procedure.

MySQL Query Browser runs on Windows XP SP2, while DB server (mysql 5.0.45) runs on Fedora 9.

Thank you for the bug report. Could you please provide a complete test case,
create user and create procedure. Thanks in advance.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".