MySQL Bugs: #52893: Adding comments to a column does not work when "apply" button is clicked

Bug #52893	Adding comments to a column does not work when "apply" button is clicked
Submitted:	16 Apr 2010 17:39	Modified:	28 May 2010 13:20
Reporter:	Anil Natha	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench: SQL Editor	Severity:	S3 (Non-critical)
Version:	5.2.18	OS:	MacOS (10.6.3)
Assigned to:	Alfredo Kojima	CPU Architecture:	Any
Tags:	apply button, column, comment

Description:
If you try to add a comment to a column of a table, the comment is not saved when the "apply" button is clicked.

How to repeat:
1) Connect to a database
2) Select a schema
3) Right click a table
4) Choose "Alter table..." to open the dialog box to edit a table.
5) Select the "Columns" tab
6) Choose a column you wish to add a comment to
7) On the right side of the dialog box are two fields, one for "Collation" the other is the "Comments" field.
8) type a comment into the "Comments" field
9) Click the "Apply" button.

Notice that nothing happens when the "Apply" button is clicked.  If you click "Close" and go back to the table and view the column's properties that you tried to update, you'll see that the comments you added were not saved.

Thank you for the problem report. Verified just as described.

Found something interesting going on.

If you follow my directions, we've already verified that the "Apply" button does not work.

Instead, follow my directions, but after you enter the comment, simply click the column name you are attempting to edit and then click the Apply button.  You'll see then that the Apply button works as it should.

I think the problem is that the program doesn't check to see if the field has been edited unless you take focus away from the field.  However, if you enter the comment, click on a column other than the one you are trying to edit, and then click the column you wanted to edit, you'll see the comments field is empty, but this time, if you enter a comment and click the apply button, it works as well.

Fixed

Set bug #53844 as duplicate of this one

fix confirmed in repository

An entry has been added to the 5.2.22 changelog:

In the Alter Table dialog of the SQL Editor, when a comment was entered for a column in the Comments tab, and the changes applied, the comment was not saved.