Bug #12478 % in stored procedure will block editing of the stored procedure
Submitted: 10 Aug 2005 2:05 Modified: 11 Aug 2005 21:01
Reporter: J D Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Query Browser Severity:S3 (Non-critical)
Version:1.1.13-win OS:Windows (winxp sp2)
Assigned to: CPU Architecture:Any

[10 Aug 2005 2:05] J D 
Description:
An error prevents a user from editing a stored procedure if it contains a % in it.  

In the 'schemata' window, if you right click on a stored procedure (containing a %)and select 'edit procedure', the error message shown at the bottom of the screen is 
  No Argument for format '%"

How to repeat:
Create the stored procedure below, then try to edit it by right-clicking the stored procedure in the schemata window and selecting 'edit procedure'.

CREATE PROCEDURE sp_myTestProcedure(
  IN dName VARCHAR(45)
)
BEGIN
     select blah
     from myTable
     where myValue like CONCAT('%',dName,'%' );
END$$

Suggested fix:
The workaround is to select 'Script' from the menu at the top of the My Query Browser window and then select 'Edit All Stored Procedures / Functions'
[11 Aug 2005 21:01] MySQL Verification Team 
Duplicate for #11860