Bug #70059 EER modelling - can't update Routine Groups
Submitted: 16 Aug 2013 13:57 Modified: 6 Nov 2013 0:13
Reporter: Chris Brown Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench: Modeling Severity:S2 (Serious)
Version:6.0.6.11184 OS:Windows (Windows 7 64-bit)
Assigned to: CPU Architecture:Any
Tags: routine groups, save, stored procedures, UPDATE

[16 Aug 2013 13:57] Chris Brown 
Description:
I updated my workbench to 6.0.6 about 15 minutes ago.
I can now no longer update stored routine groups.  When changing the code, it is lost upon either A. closing the routine group, B. opening another routine group, or even C. forward engineering.

The actual "save" button works, but just for exporting the table - the actual saving that isn't working is usually automatic.

How to repeat:
1: Create a new model.
2: Create a new EER diagram
3: Add a routine group element to the diagram
4: Add a test procedure to the diagram, eg
"CREATE PROCEDURE `test` (IN param INT)
BEGIN
	SELECT param;
END$$"

5: Close the group routine (or switch to another group routine)
6: Reopen the routine and the code is gone.
[16 Aug 2013 23:20] MySQL Verification Team 
Thank you for the bug report. Verified as described.
[26 Aug 2013 10:13] Xavier GENDREAU 
Could we know when it would be corrected ?
[27 Aug 2013 11:19] Chris Brown 
Yes, that would be helpful.  I've had to revert back to a previous version of Workbench, as it's now completely unusable for my purposes.
It's probably more accurately described as S1 severity - as there is no workaround.
[27 Aug 2013 12:37] Mike Lischke 
Posted by developer:
 
Fixed in code repository. In the meantime use individual routine group editors for each routine to get the job done. Drag the routine objects into the members list of the routine group editor to group them.
[27 Aug 2013 17:15] Chris Brown 
Many thanks!
[29 Aug 2013 11:20] Xavier GENDREAU 
Could we know when new version of MySQL Workbench will be available ?
[27 Sep 2013 14:13] Chris Brown 
This still isn't quite right.

Using 6.0.7 now, and the autosaving doesn't work when combined with Find & Replace, which leads to some very annoying debugging.

Example:
1. Make some misc. routine groups.
2. Find & Replace some value(s)
3. Close/change routing group
4. Reopen to find old value

Workaround: hit Ctrl+S before you leave the routine group.
[30 Oct 2013 20:16] Armando Lopez Valencia 
Posted by developer:
 
FIXED.
Verified in:
Windows 7x64
Ubuntu 12.04x64
MySQL Server 5.6
WB 6.0.8.11345
The code persist after close/open the group tab.
[6 Nov 2013 0:13] Philip Olson 
Fixed as of MySQL Workbench 6.0.8, and here's the changelog entry:

Stored routine groups could not be updated via the group editor in the EER
diagram. 

A workaround is to use individual routine group editors for
each routine, by dragging the routine objects into the members list of the
routine group editor to group them.

Thank you for the bug report.