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:	None
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

Description:
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.

Thank you for the problem report. Verified on Mac OS X also.

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.

Page generated in 0.050 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.