Bug #11860 stored procedure containing '%' can not be edited
Submitted: 11 Jul 2005 7:46 Modified: 20 Sep 2005 14:36
Reporter: Kai Sautter (Basic Quality Contributor) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Query Browser Severity:S3 (Non-critical)
Version:1.1.10 OS:Windows (Windows XP (SP2))
Assigned to: Vladimir Kolesnikov CPU Architecture:Any

[11 Jul 2005 7:46] Kai Sautter 
Description:
A stored procedure containing the literal '%' (single quote, percent. single quote) can not be edited. Query browser reports an error (No argument for format '%'').

How to repeat:
(1) Create a simple stored procedure, e.g. using the following code

     DELIMITER $$

     CREATE PROCEDURE `test`()
     BEGIN
       select * from table1where filed1 like '%';
     END$$

     DELIMITER ;

(2) Select Edit procedure form the context menu in the schema selector
[20 Sep 2005 14:36] Vladimir Kolesnikov 
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
[10 Oct 2005 23:34] Frank Maas 
Just downloaded version 1.1.15 (Windows) that installs as 1.1.14 and comprises libmysql* dated 05/09/25. This version still contains the bug as described.