Bug #36916 schema name in routine definition is not updated

• Submitted: 23 May 2008 13:39
• Modified: 19 Dec 2013 18:49
• Reporter: Markus Axelsson
• Status: Can't repeat
• Category: MySQL Workbench
• Severity: S3 (Non-critical)
• Version: 5.0.21 OSS
• OS: Windows (XP Pro SP2)
• Assigned to: Assigned Account
• CPU Architecture: Any
• Tags: Catalog, routine, schema name

[23 May 2008 13:39] Markus Axelsson

Description:
The schema name in the routine definition is not updated if the schema name is changed using the "Catalog" window.

How to repeat:
1. Create a new Model 
2. Double click on "Add Routine" to create a new routine
3. Close the routine tab
4. Right click on the "mydb" schema in the "Catalog window" and select "rename"
5. Write a new schema name and press enter
6. Double click on the previously created routine to see that it has not been updated. It will however be marked with "_WRONG_SCHEMA" in the routine list.

[23 May 2008 13:48] MySQL Verification Team

Thank you for the bug report.

[27 May 2008 12:22] Sergei Tkachenko

Currently (as of WB v5.0) the only way to involve refactoring on schema name change is to press "lightning" button near the "name" field in schema editor (note: all other editors must be closed at that moment, since open editor prevents refactoring of underlying object).
Refactoring stuff will be significantly reworked in v5.1, WB will support also renaming of other catalog objects: tables/views/routines/etc..