MySQL Bugs: #76368: Sync Function

Bug #76368	Sync Function
Submitted:	18 Mar 2015 7:31	Modified:	11 Jun 2018 22:57
Reporter:	hEnDRa DiNatA	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench	Severity:	S3 (Non-critical)
Version:	6.3.4	OS:	Windows (Microsoft Windows 8.1 Enterprise)
Assigned to:		CPU Architecture:	Any
Tags:	Synch, WBBugReporter

Description:
This is about Synch problem toward Function or Store Procedure.
I have an EER Model. In the EER Model, I place a new Routine Group. Ok that's fine. Then I click Synchronize Model (Ctr+Shift+Z), synch from model to source (Update Source). No Error at all. I connect to local instant using Workbench. I didn't see any function e in Navigator Pane in the Sidebar. But actually the function is exist. I can use it in my query, i.e. Select MyFunc();
No error at all. The function is just does not appear in Navigator panel.

Another case, I created a Function from Workbench after I connect to my local instance. The Function appear in the Navigator pane. No error at all. Now I move to EER Diagram. I click Synchronize Model, and I see that there is a new Function in the source but no Function in the model. So I choose Update Model. Done, no error at all. But I didn't see any routine in Catalog Tree.

How to repeat:
1. Open EER Model, create a routine (Function), click Synchronize Model. Choose Update Source on the Function. Done. There is a routine in Catalog Tree. Now connect to Local Instance using Workbench. Try to locate your schema (database), and you won't found any function in Navigator panel.

2. Connect to local instance, Create new SQL tab. Create a Function in the tab. The function created will be found in the Navigator panel. Now open your EER Model, click Synchronize Model. Find your new Function, and Update Model. Finish. But you won't find any routine in Catalog Tree.

Suggested fix:
I can Synchronize table and view very well. So I should be able to synchronize any function or store procedure also as well as the table or view.

Please try version  6.2.5 and 6.3.2 rc. Thanks.

I already use version 6.2.5 now.
There is no different between 6.2.4 and 6.2.5.
Synchronizing Function still weird

Please try version 6.3.4 if you continue with the issue please provide a model file project as test case. Thanks.

My Workbench version is 6.3.4 now. But the Routine Group is still empty in Catalog Tree Panel.
I submit my model file. There are eleven Functions there, and 22 Views.

Thank you for the feedback.

Posted by developer:
 
Fixed as of the upcoming MySQL Workbench 8.0.12 release, and here's the changelog entry:

Stored procedures when added to a model and synchronized with a database
were not listed in the Navigator area of the sidebar panel. New functions
were not represented in the Catalog Tree after synchronization, although
each function did appear in the Navigator area and in source.

Thank you for the bug report.