MySQL Bugs: #23084: MySQL Administrator Stored Procedure List Not Showing stored procedures

Bug #23084	MySQL Administrator Stored Procedure List Not Showing stored procedures
Submitted:	8 Oct 2006 0:57	Modified:	9 Apr 2009 12:59
Reporter:	Ted Lewis	Email Updates:
Status:	Unsupported	Impact on me:	None
Category:	MySQL Administrator	Severity:	S2 (Serious)
Version:	1.2.5rc	OS:	MacOS (MAC OSX 10.4.8)
Assigned to:		CPU Architecture:	Any

Description:
Add a new stored procedure to a database.  When the procedure is saved, it does not appear in the Stored Procedure List even if you press the "Refresh" button.

How to repeat:
Create a new stored procedure using the Create Procedure Button.  Add a simple select statement to the statement. You can save it using the 'new_procedure' name or change the name to something else. Save the stored procedure by pressing OK.  The stored procedure will not show up in the procedure list even after pressing the refresh button.

Thank you for a problem report. Please, try to repeat with a newer version, 1.2.5 rc, and inform about the results.

I tested this bug with the new 1.2.5rc and I get the same results

Thank you for the report.

I can not repeat it using current 1.2.5rc MySQL Administrator.

I still can not get the stored procedures to show up.  Is there some trick to it?

There is not any trick to show procedures: all works as expected.

Please try using current MySQL Administrator from MySQL GUI Tools 5.0.r6 package and if you can repeat error reopen bug and provide content of the dialog window contains CREATE PROCEDURE statement.

I have downloaded 5.0.r6 and tried again.  I added the following stored procedure:

CREATE PROCEDURE `Mexicana`.`my_procedure`()
BEGIN
      SELECT propertyname FROM properties;
END

Pressed OK and procedure saved with no error.

Pressed Refresh on the stored procedures window and newly added procedue does not show up.
(Selected Schema is Mexicana).

Open MySQL Query Browser

Select Shema "Mexicana"

Entered "call 'my_procedure'();"

procedure call returns three rows.

This indicates to me that the stored procedure is in the database.  It still does not show up in the MySQL Admistrator Stored Procedure list even with the "Mexicana" schema selected.

Please provide output of SHOW GRANTS for user you use to connect via MySQL Administrator and create procedure.

As requested

SHOW GRANTS;
GRANT ALL PRIVILEGES ON *.* TO
GRANT ALL PRIVILEGES ON 'mexicana'.* TO
GRANT ALL PRIVILEGES ON 'test'.* TO
GRANT ALL PRIVILEGES ON 'mysql'.* TO
GRANT ALL PRIVILEGES ON

I still can not repeat the problem.

Are you sure you look into Stored Procedures tab and not to Functions tab?

I am looking at the stored procedures tab.  

I just tried creating a new function by pressing "Create Function" on the functions tab.  I just pressed OK on the function that was brought up in the new function window.  It saved it OK but guess what?  The functions don't display either.  I tried adding the same function again and it displays an error that the function already exists.  It doesn't display in the functions list.

The Mac I am using is a iMac G5 if that makes any difference.

Could not repeat on PowerBook G4 using MySQL Administrator 1.2.6rc. (I'm 500km away from G5)

MySQL server I am using is 5.0.26, and the client apparently in MySQL Administrator is 5.0.22.

Looks like we all truly can not repeat the problem. So I mark this bug as "Can't repeat" again. But if you have any idea how to repeat it don't hesistate to add comment and reopen it.

I also see this on OS X 10.4.10 running MySQL 5.0.27-max on a Quad G5, with MySQL Admin 1.2.12 (and Query Browser 1.2.12).

The issue seems to be that if the database name contains upper-case characters, then the GUI clients do not recognize the procedure as being associated with that database. Even if the database name is specified in mixed/uppercase when creating the procedure, the proc table stores the database name in all lowercase. The account I am using can create and run the procedure just fine, and perform a select on the proc table, and see the procedure in there. But the procedure never shows up in the GUI (e.g., on the 'Catalogs->[catalog name]->Stored Procedures' tab) after being created.

If the database name is all lowercase, everything works as expected. 

The server has lowercase_table_names set to 2.

I have the same problem using Version 1.2.12 of the Administrator and Version 5.0.45 of MySQL under Windows XP. As Simon Oliver already said, it happens, when lowercase_table_names is set to 2 and the tables name is using mixed case.

Simon, Olaf,

thank you for the feedback. Verified as described.

To repeat:

1. $mysql     
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 6055
Server version: 5.0.45 MySQL Community Server (GPL)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> create database Bug23084;
Query OK, 1 row affected (0.09 sec)

mysql> use Bug23084;
Database changed
mysql> delimiter |
mysql> create procedure PRRRRocedure()  begin select * from test.Table1; end|
Query OK, 0 rows affected (0.30 sec)

2. Open MySQL Administrator and try to access to PRRRRocedure

So is there a timeline when this will be fixed?

Create a stored procedure via the  MySQL Query tool.
Open MySQL Administrator, go to stored procedures, click refresh, no stored procedures are listed
Creation of a stored procedure in MySQL Administrator using Create  Procedure, opens an editor. When Ok is clicked, MySQL Administrator quits with an error "application mysql administrator quit unexpectedly"

Using  mysql-gui-tools-5.0-r12-osx10.4
On Mac OS X Leopard v 10.5.2

Many thanks for writing a bug report. We are on the way to implement full functionality of MySQL Administrator into MySQL Workbench. Unfortunately you are using an unsupported platform. More information about supported platforms you will find here:

http://www.mysql.com/support/supportedplatforms/tools.html

More informations about MySQL Workbench you will find here:

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