MySQL Bugs: #68988: Information panel does not reflect table alterations

Bug #68988	Information panel does not reflect table alterations
Submitted:	17 Apr 2013 21:55	Modified:	31 Jul 2013 13:42
Reporter:	Teodor Hadjiev	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench: SQL Editor	Severity:	S3 (Non-critical)
Version:	5.2.47	OS:	Windows (Win7 x64)
Assigned to:		CPU Architecture:	Any
Tags:	alter, information, panel, refresh, sql editor, table

Description:
Tables DDL does not get reflected in the Information panel in SQL Editors, even after Refresh All.
The Refresh All command seems totally broken. It is very buggy and doesn't refresh many aspects when something changes. I've already filed few related bugs, but other minor ones are just on the tip of my fingers to file.
E.g. altering a table to add new columns - the new columns do not appear in the Information panel below the tree.

How to repeat:
Open SQL Editor with some DB tables.
Click a table in the tree and the Information panel shows its properties/fields.
In an sql tab alter the table to add a new field (alter table ... add....).
The info panel remains silent and static. Do a Refresh All - no difference, no way for the Info panel to show the changes other than completely closing the global sql editors and reopen.

Suggested fix:
As always - at least Refresh All should do what it is supposed to do - to refresh everything in the tree (and its Info panel) so we can see the most current state of the tree/info, correctly.

Win7x64
WB 5.2.47
--------------
were your using root user? (or what user privileges you used)
which Mysq Server version are you using?
is a remote conection?

We'd really appreciate if you could provide these details in order to try to reproduce it.

Thank you for your interest in MySQL.

could you please provide details requested before?

Hi.
Mysql version is 5.5.8, local installation on a dev machine.
Always using the root user in administration procedures for any database, with fullest possible privileges.
It's just the Info panel (below the tree) doesn't reflect changes in tables until the sql editor gets closed and reopened.
If I remember correctly, this is an old bug.

Win7x64
WB 5.2.47
----------------------
1.- Open SQL Editor
2.- Right Click on a Table and select "Alter Table..."
3.- Do any change on table (example: varchar(45)-> varchar(60) )
4.- Click Apply changes.
5.- Even though table was altered, the "Object Info" Window (left-bottom window, below "Object Browser" windows) is still not updated BUT until we select other object and go back to object (table) just altered.

Fixed: 
 Do a refresh in "Object Info" ... right after an "alter table.."

This will be fixed in .48, right?

And why not just make it update its info after a global tree Refresh All?
In your way we'll have to refresh twice (two things - the tree, and the info panel) - less than optimal, to say the least.
Moreover the tree/info panels should monitor when there is an ALTER (at least) and autoupdate the relevant properties without the need for a manual refresh.
If this is hard to implement, I'd understand.

Fixed as of MySQL Workbench 6.0.4, and here's the changelog entry:

A table's current information was not always reflected in the
"Information" panel for the SQL editors, even after clicking "Refresh
All".

Thank you for the bug report.