Bug #53844 Column comments are not stored when editing a table using "alter table"
Submitted: 20 May 2010 9:22 Modified: 23 May 2010 12:56
Reporter: Jan Ingvoldstad Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S3 (Non-critical)
Version:5.2.21 RC OS:MacOS
Assigned to: CPU Architecture:Any
Tags: ALTER TABLE, column comments

[20 May 2010 9:22] Jan Ingvoldstad
Description:
When adding a new column or editing an existing column using the "alter table" functionality, column comments are not stored when applying the changes or closing the table.

This is tested and reproducable with InnoDB tables on a MySQL 5.1.44 server.

How to repeat:
Select a schema, then tables, and the table you want to test with.

Right-click (if you have a mouse that allows it) or control-click on the table name, select "Alter table...".

Select "Columns" from the tabs on the bottom.

Choose a column to edit.

Try to enter a comment in the comment field and click "Apply"

Suggested fix:
Either enable table comments, or grey out the comment field.
[20 May 2010 19:02] Valeriy Kravchuk
Thank you for the bug report.
[23 May 2010 12:56] Alfredo Kojima
Duplicate of bug #52893