MySQL Bugs: #74708: Can't see Stored Procedures in Navigator pane on Workbench 6.2

Bug #74708	Can't see Stored Procedures in Navigator pane on Workbench 6.2
Submitted:	6 Nov 2014 8:40	Modified:	24 May 2018 15:27
Reporter:	Graham Charlton	Email Updates:
Status:	QA review	Impact on me:	None
Category:	MySQL Workbench	Severity:	S2 (Serious)
Version:	6.2.3/6.3.4	OS:	Any (OSX 10.10, Windows 7 Pro)
Assigned to:		CPU Architecture:	Any

Description:
In version 6.2.1 & 6.2.3 no stored procedures are showing in the navigator pane for any schemas. Logging on as a user with full privileges or as root makes no difference.

However, I can create a new stored procedure and it appears in the navigator. The definer details generated are identical to the ones in the procedures that don't show up.

If I click the 'i' icon that appears to the right of the schema name in the navigator, and then open the stored procedures tab, all my stored procedures are displayed.

If I revert to previous versions (e.g. 6.1.7) I can see the all stored procedures.

The only thing I've changed is to update the version of Workbench.

I have installed 6.2.3 on Mac OSX 10.9 & 10.10 and on Windows 7 Pro, all showing the same result.

How to repeat:
Install and run Workbench 6.2.3. Open an existing connection that contains stored procedures. Stored procedures are not visible in the navigator pane.

Note. Although I can create a new stored procedure, if I close workbench 6.2.3 and re-open, the new procedure does not show.

Showing stored procedures

Attachment: stored_procedures.png (image/png, text), 63.62 KiB.

Thank you for the bug report. I couldn't repeat on OS X Yosemite please see attached pictures showing Stored Procedures called sp1 and sp2. Thanks.

screen showing missing stored procedures

Attachment: Screen Shot 2014-11-10 at 12.30.35.png (image/png, text), 172.31 KiB.

The image I've posted shows the problem I'm seeing.

Graham.

Thank you for the feedback. Are you able to provide a minimal file dump including stored procedures which present that issue (private if you wish). Thanks.

I've posted a table and the routines dumped from one schema. The routines don't show up in the navigator.

Graham.

Thank you for the feedback. Applying your scripts are created 5 stored procedures and only 2 are showed.

Same for me. Stored procedures or functions are only visible until I refresh or re-open Workbench. They do show up in schema information and can be called but I have to drop and re-create them if they need to be altered. Using Yosemite 10.10.1.

best,
Tom

Similar issue here, cannot see stored procedures after refresh. Able to view the procedures using the same login credentials with version 6.1.7.11891 Build 1788.

Bug is still there in 6.2.5

6.3.2rc still has the same bug

Bug still exists in 6.3.3. Any timeline on when this will get fixed?

I found a way around this issue. I noticed that if my schema name has a mixture of upper and lower case characters I cannot see the procedures I create in the Workbench.

But if I have a schema name with *only* lower case characters, I can see the new procedures I create in the Workbench and everything behaves as expected.

Figured I'd share this in case anyone else notices this behavior...

Just checked out your suggestion and re-imported the schema with a new name with only lower case letters. It seems to work perfectly, thanks. Should also help the devs to nail it down. Thanks, Tom

Well spotted Shaun.

I also notice that if I click on the spanner (wrench) icon beside the schema in the navigator, the Schema Name field in the main work tab is always shown in lower case. I wonder if this is where the mismatch lies.

Thanks for the follow up and extra validation Tom and Graham. This will surely help the developers nail down this issue!!

http://bugs.mysql.com/bug.php?id=78171 marked as duplicate of this one.

http://bugs.mysql.com/bug.php?id=78691 marked as duplicate of this one.

http://bugs.mysql.com/bug.php?id=79168 marked as duplicate of this one.

This problem still exists. If the schema has a mixture upper and lower cases in name, stored procedures don't display though they exist. They are visible in other MySQL clients. However when schema has an all lower case name, procedures appear. Using OS X EL Capitan. It's interesting this problem has been there since a year ago.

Same situation here. OS X El Capitan 10.11.2 and MySQL Workbench 6.3.6 build 511.

Confirmed to still be a bug in MySQL WB 6.3.6 (511) on El Capitan 10.11.3 - very frustrating.

Gave up and went with a bunch of RENAME TABLE action to get around this.

Also, you can workaround by using Schema Inspector > Stored Procedures > right-click > Alter, etc.  But that's still lame...  

keywords:  missing stored procedures, workbench, mysql, osx

http://bugs.mysql.com/bug.php?id=80738 marked as duplicate of this one.

Using Workbench 6.3.6 build 511 OS X El Capitan V 10.11.4

Cannot see stored procedures for a local mysql server "5.6.24 MySQL Community Server" compiled for osx10.8, when schema name contains Uppercase letters 

However on the same workbench can see stored procedures for production mysql server "5.6.23-log MySQL Community Server" compiled for Linux for any schema with or without uppercase letters.

Also unlike others, on clicking the wrench next to schema name, schema name does show uppercase letters for bot local and production server.

http://bugs.mysql.com/bug.php?id=81028 marked as duplicate of this one.

v. 6.3.8
stored procedures not showing into "Stored Procedures" node.