MySQL Bugs: #41378: Insert statements don't update when changing table name

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

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');

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.

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.

Verified as described in the last comment.

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/