Bug #3080 Column Name info is not updated until restart of MySQL Administrator
Submitted: 6 Mar 2004 4:19 Modified: 17 Mar 2004 10:40
Reporter: Oscar Bell Email Updates:
Status: Closed Impact on me:
Category:MySQL Administrator Severity:S3 (Non-critical)
Version:1.02a ALPHA OS:Linux (Linux)
Assigned to: Alfredo Kojima CPU Architecture:Any

[6 Mar 2004 4:19] Oscar Bell
The column information of a new created table is not shown until a restart of MySQL Administrator. 
After creating the new table via mysql client the new table is not visible until you select another database in the catalog tree on the left and return again to database you created the table in. The newly created table is visible and all tabs show information except the column tab.

If you alter the table the new column definition won't also be visible until a restart of MySQL administrator.

How to repeat:
Open MySQL Administrator and mysql client
Select a database of your choice in the catalog tree view, say D1
Create a new table (say T1) with a couple of columns in the choosen database D1 via mysql client. 
In MySQL Administrator the newly created table is not visible so select anothor database and return back to database D1
In the right view (Schemata of D1) the newly created table T1 will show up
Select table T1 and check the Column tab. This wil not show any information. Select one of the other tabs and check that there is information about the table.
Restart MySQL Administrator
Select database D1 in the Catalog tree
Select table T1 and check that the column information is visible in the view

Suggested fix:
When pointing at a table in the schemata view also read the column information and display it in the view.
Index information is updated within MySQL Administrator whenever you reselect the database in the catalog view. 
Check MySQL Server for schemata changes whenever you select the table and then update the tabs with this information.
In the manual there is a reference about right clicking to refresh the schemata but this is not available in Linux MySQL Administrator.
[17 Mar 2004 10:40] Alfredo Kojima

The problem you've described has been fixed in our bitkeeper tree.
I've added a Refresh button to the table list page and a popup menu to the Schemata list where you can refresh it too.

Thanks for the report.