Bug #26730 query browser doesnt quote names of stored procedure
Submitted: 28 Feb 2007 20:03 Modified: 29 Jan 2009 12:13
Reporter: Martin Friebe (Gold Quality Contributor) (OCA) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Query Browser Severity:S3 (Non-critical)
Version:1.2.9rc, 1.2.12 OS:Microsoft Windows (Windows XP)
Assigned to: Mike Lischke CPU Architecture:Any
Tags: qc, quoting

[28 Feb 2007 20:03] Martin Friebe
Description:
it is possible to create stored procedures with names that must be quoted when used.

If you select (by double click from the schema selection) such a stored procedure, mysql QB, will create invalid SQL. This leads to an error when trying to execute

How to repeat:
# via mysql command line client
create procedure `+`() select 1;

# in QB: select the schema, double click the stored procedure.
# the sql created looks like this
Call  +();

Suggested fix:
It should look like:

Call `+`();
[1 Mar 2007 0:32] MySQL Verification Team
Thank you for the bug report.
[13 Mar 2007 9:28] Jared S
Also Mike..there is a very similar bug here..

1. CREATE VIEW `-` AS SELECT 1;
2. (Select above view by double click)

RESULT QB.EXE wont auto generate text.
[29 Jan 2009 12:13] Mike Lischke
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/
[1 Feb 2009 21:39] Jared S
Can't see the fix in 1.2.16 release.
[3 Feb 2009 13:51] Mike Lischke
It was only partially fixed (for views, but not for procedures). It is now, in our source repository.