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

[6 Nov 2014 8:40] Graham Charlton
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.
[6 Nov 2014 8:45] Graham Charlton
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.
[10 Nov 2014 11:28] Miguel Solorzano
Showing stored procedures

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

[10 Nov 2014 11:31] Miguel Solorzano
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.
[10 Nov 2014 14:54] Graham Charlton
screen showing missing stored procedures

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

[10 Nov 2014 14:55] Graham Charlton
The image I've posted shows the problem I'm seeing.

Graham.
[10 Nov 2014 15:33] Miguel Solorzano
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.
[11 Nov 2014 10:27] Graham Charlton
I've posted a table and the routines dumped from one schema. The routines don't show up in the navigator.

Graham.
[11 Nov 2014 11:22] Miguel Solorzano
Thank you for the feedback. Applying your scripts are created 5 stored procedures and only 2 are showed.
[16 Jan 2015 20:20] Tom Goschütz
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
[10 Feb 2015 16:21] Joe Frizzell
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.
[25 Mar 2015 10:48] Tom Goschütz
Bug is still there in 6.2.5
[22 Apr 2015 11:37] Tom Goschütz
6.3.2rc still has the same bug
[23 May 2015 15:38] Shaun Wood
Bug still exists in 6.3.3. Any timeline on when this will get fixed?
[28 May 2015 0:49] Shaun Wood
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...
[28 May 2015 7:13] Tom Goschütz
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
[29 May 2015 10:46] Graham Charlton
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.
[29 May 2015 21:20] Shaun Wood
Thanks for the follow up and extra validation Tom and Graham. This will surely help the developers nail down this issue!!
[23 Aug 2015 20:45] Miguel Solorzano
http://bugs.mysql.com/bug.php?id=78171 marked as duplicate of this one.
[12 Oct 2015 4:06] Miguel Solorzano
http://bugs.mysql.com/bug.php?id=78691 marked as duplicate of this one.
[7 Nov 2015 19:51] Miguel Solorzano
http://bugs.mysql.com/bug.php?id=79168 marked as duplicate of this one.
[8 Nov 2015 15:39] Leonard Eshun
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.
[21 Dec 2015 17:51] Miguel Ángel Artaso-Landa
Same situation here. OS X El Capitan 10.11.2 and MySQL Workbench 6.3.6 build 511.
[17 Feb 2016 6:06] Ryan Mann
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
[15 Mar 2016 10:22] Miguel Solorzano
http://bugs.mysql.com/bug.php?id=80738 marked as duplicate of this one.
[6 Apr 2016 15:09] Sundeep Narang
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.
[11 Apr 2016 12:55] Miguel Solorzano
http://bugs.mysql.com/bug.php?id=81028 marked as duplicate of this one.
[14 Nov 2016 8:16] Den Parygin
v. 6.3.8
stored procedures not showing into "Stored Procedures" node.