MySQL Bugs: #27548: Stored Procedures are not visible in MySQL Query Browser

Bug #27548	Stored Procedures are not visible in MySQL Query Browser
Submitted:	30 Mar 2007 13:06	Modified:	12 May 2009 12:39
Reporter:	Sanjay Chaudhari	Email Updates:
Status:	Won't fix	Impact on me:	None
Category:	MySQL Query Browser	Severity:	S3 (Non-critical)
Version:	1.2.10, 1.2.11	OS:	Windows (Windows XP Pro SP2, Mac OS X)
Assigned to:		CPU Architecture:	Any
Tags:	lower_case_table_names, query browser, stored procedure, Visible

Description:
Currently I am working on Community Server version 5.0.37-community-nt. 

I created my new database, and tables. When I tried to create Stored Procedures on my detabase, I found that these stored procedures are not visible in the browser. However, I could found them in 'proc' table of 'mysql' schema.

I want to use mixed case names, so I have set the variable lower_case_table_names = 2.

How to repeat:
1. Set the variable lower_case_table_names = 2
2. Restart the MySQL Server
3. Create a Database
4. Create a Stored Procedure

Check expanding the Database in the Schemata, the Stored Procedure name is not shown in the browser.

Suggested fix:
This is not the solution in fact, it's a work around I found:

1. Set the variable lower_case_table_names = 1
2. Restart the MySQL Server
3. Create a Database
4. Set the variable lower_case_table_names = 2
5. Restart the MySQL Server
6. Create a Stored Procedure

Now it is shown in the browser under the Database. It allows to have the table names in required case, but the database name remains in lower case.

QB and Stored Procedures

Attachment: qb-and-sp.png (image/x-png, text), 65.19 KiB.

Thank you for the bug report. I followed your intructions and I was not
able to repeat (see picture I attached). Could you please provide the
script of one of the SP which presents that issue on your side?. Thanks
in advance.

You might have tried with lowercase database name, this problem happens only when you create the database containing any uppercase character in it's name.

You can reproduce the error using following scripts:

1. Create Database script
CREATE DATABASE `Temp1` /*!40100 DEFAULT CHARACTER SET utf8 */;

2. Create Stored Procedure script
DELIMITER $$

DROP PROCEDURE IF EXISTS `Temp1`.`test` $$
CREATE PROCEDURE `Temp1`.`test` ()
BEGIN

END $$

DELIMITER ;

Thank you for the additional comment.

Verified as described.

Mac version is affected too.

This also causes the stored procedures not to display in MySQL Administrator  1.2.12 on OS X.

Many thanks for writing a bug report. We are on the way to implement full functionality of
MySQL Query Browser into MySQL Workbench. We won't fix this bug anymore because it works
different in MySQL Workbench already.

More informations about MySQL Workbench you will find here:

http://dev.mysql.com/workbench/