Bug #41378 Insert statements don't update when changing table name
Submitted: 10 Dec 2008 22:21 Modified: 19 Mar 2009 12:33
Reporter: Andrew Collington Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:5.0.28SE OS:Any
Assigned to: Susanne Ebrecht CPU Architecture:Any

[10 Dec 2008 22:21] Andrew Collington
Description:
If you create a table, add insert statements and then change the table name, the insert statements (as seen in the 'Inserts' tab) still shows the old name.  You'd expect it to update.  If you click on the 'open editor' and close it again without updating any data then it will update the table name.

How to repeat:
Create a table named 'test' with any number of fields.
Insert some data so that it shows under the Inserts tab.  For example:

    INSERT INTO `test` (`id`, `name`) VALUES (1, 'Test name');

Rename table to 'example' and view the Inserts tab again. It'll show:

    INSERT INTO `test` (`id`, `name`) VALUES (1, 'Test name');

instead of:

    INSERT INTO `example` (`id`, `name`) VALUES (1, 'Test name');
[11 Dec 2008 7:38] Valeriy Kravchuk
Thank you for a problem report. Please, describe how exactly you had renamed the table. When I had used Table tab and changed name there INSERTs were updated at the Insert tab.
[11 Dec 2008 11:19] Andrew Collington
This renaming issue only seems to happen if you right-click on the table icon and select 'rename' from the context menu, or left-click on the icon name so that it becomes editable.  Change the text, hit return to end, and the inserts don't update.
[11 Dec 2008 13:49] Valeriy Kravchuk
Verified as described in the last comment.
[19 Mar 2009 12:33] Susanne Ebrecht
Thank you for your bug report. This issue has already been fixed in the latest released version of that product, which you can download at

  http://www.mysql.com/downloads/