Bug #63828 Object browser doesn't update table definition after altering a table
Submitted: 21 Dec 2011 18:30 Modified: 7 Feb 2012 21:50
Reporter: Bob Dankert Email Updates:
Status: Closed Impact on me:
Category:MySQL Workbench: SQL Editor Severity:S3 (Non-critical)
Version:5.2.36 OS:Any (W7 64, Mac OS X)
Assigned to: CPU Architecture:Any
Tags: ALTER TABLE, Object Browser, refresh, regression

[21 Dec 2011 18:30] Bob Dankert
After applying a changes to a table from an alter table, it would be nice if the object browser displaying the table would update with the changes you just made.  It would be nice if only the table you updated would get refreshed, since it can take some time to refresh all tables on a remote database, especially if there are a lot of tables/columns.

I beleive that older versions of Workbench performed did this after altering a table.

How to repeat:
Alter a table.  Look at the table definition in the object browser, and the changes you just made will not be reflected.  You must do a "Refresh all" on the object browser to see the change.

Suggested fix:
Refresh the table that was updated after an alter table command.
[21 Dec 2011 18:38] Valeriy Kravchuk
Thank you for the problem report. Verified on Mac OS X also.
[7 Feb 2012 21:50] Philip Olson
Fixed as of 5.2.38:

The main schema information found within the object browser now
updates after a table is altered, and collapses the expanded
details. And selecting an object now reloads the data, which
means the current (altered) data is displayed.