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

Bug #27708	Stored Procedures are not visible in MySQL Query Browser
Submitted:	9 Apr 2007 6:57	Modified:	9 Apr 2007 9:47
Reporter:	Sanjay Chaudhari	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Query Browser	Severity:	S3 (Non-critical)
Version:	1.2.10	OS:	Windows (Windows XP Pro SP2)
Assigned to:		CPU Architecture:	Any
Tags:	lower_case_table_names, query browser, stored procedure, Visible

Description:
I had already raised this issue in bug id 27458. But Miguel Solorzano set the status of the bug as can't repeat. Then I added a comment to reproduce the bug but, the issue was not attended. So I have again added  this bug with proper procedure to repeat it.

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

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

You can use the following scripts to create Database and Stored Procedure:

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 ;

Please do not submit the same bug more than once. An existing bug report already describes this very problem. Even if you feel that your issue is somewhat different, the resolution is likely
to be the same. Because of this, we hope you add your comments to the original bug instead.

Thank you for your interest in MySQL.

Bug #27548 has been verified.