Bug #56834 Synchronizing copied tables
Submitted: 17 Sep 2010 7:49 Modified: 18 Sep 2010 14:48
Reporter: Paul Macdonnell Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench: Modeling Severity:S3 (Non-critical)
Version:5.2.25 OS:Linux (Ubuntu 10.04 x64)
Assigned to: CPU Architecture:Any

[17 Sep 2010 7:49] Paul Macdonnell
Description:
I made a copy of a table, then when I went to synchronize it with the actual MySQL server, the target (source) tablename is still the old tablename of the originally copied table.

How to repeat:
Open existing model
Go to ERR Diagram screen
Right click on existing table and select "Copy <tablename>"
Click "Edit" menu, select "Paste <tablename>"
Modify new table with new name, columns indexes, foreign keys, etc to match new table name
Click "Database" menu, select "Synchronize Model"
Follow wizard to "Select Changes to Apply" screen
Search for new tablename in left column (model), the tablename in the right column (source) remains with the original tablename (not the new tablename)

Suggested fix:
When updating/modifying a copied table, ensure the source tablename is updated
[17 Sep 2010 8:33] Valeriy Kravchuk
Please, check if the same problem happens with a newer version, 5.2.27.
[18 Sep 2010 11:30] Paul Macdonnell
Confirmed working as expected in 5.2.27.
Please close/remove this report.
[18 Sep 2010 14:48] MySQL Verification Team
Thank you for the feedback.