MySQL Bugs: #5164: drop column not reflected

Bug #5164	drop column not reflected
Submitted:	23 Aug 2004 10:10	Modified:	25 Aug 2004 17:17
Reporter:	Andreas Götz	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Administrator	Severity:	S2 (Serious)
Version:	1.0.9	OS:	Windows (WinXP SP2)
Assigned to:	Michael G. Zinner	CPU Architecture:	Any

Description:
When dropping a column in query browser and creating a new one, then refreshing the table data in administrator, the new column is not visibl,e but the old one is gone.

How to repeat:
1) open administrator, edit schema, open table editor-> all columns visible
2) run qb, drop one column, create another one (via sql)
3) in administrator, refresh scheme, open table editor-> old column is gone (ok), new one is not visible (issue)

Suggested fix:
fix refresh to take new columns into account

Please upgrade to 1.0.10.2 available from

ftp://ftp.mysql.com:/pub/mysql/download/mysql_administrator_gpl.msi

Did you leave the Table Editor open in MA while editing the table in QB? Or did you close the table in MA, drop it in QB and then reopened the table in MA?

Thanks.

Michael,
no longer sure- main point was the I explicitly clicked 'Refresh' but this still didn't notice the change. Anyway, seems to be fixed with this build- thanks!

Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html