MySQL Bugs: #27575: Odd error mesage for duplicate column names in Table Editor

Bug #27575	Odd error mesage for duplicate column names in Table Editor
Submitted:	1 Apr 2007 20:23	Modified:	26 May 2009 11:53
Reporter:	Robert Sinton	Email Updates:
Status:	Unsupported	Impact on me:	None
Category:	MySQL Administrator	Severity:	S3 (Non-critical)
Version:	5.0r11	OS:	MacOS (Mac OS X 10.4)
Assigned to:		CPU Architecture:	Any

Description:
If you try to add a column with the same name as an existing column, the error message is "No modifications to be applied".

In a large table, the user might accidentally try to add a column with the same name as an existing column. This error message would be confusing, and they might not know that they had tried to re-use an existing colum name.

Worse: if the user added two columns, one of which was a duplicate name, the change would be accepted without complaint, but the column with the duplicate name would be silently ignored.

(In this case, the user would see the proposed SQL command, with only the unique column being listed, but this would be easy to miss.)

How to repeat:
Edit an existing table and add a new column.
Give it the same name as an existing column, and hit [Enter].
Add another new column, with a unique name, and hit [Enter].
Click 'Apply' button.

Suggested fix:
Error message should make it clear that there is a duplicate column name.

Thank you for the report.

Verified as described.

Many thanks for writing a bug report. We are on the way to implement full functionality of MySQL Administrator into MySQL Workbench. Unfortunately you are using an unsupported platform. More informations about supported platforms you will find here:

http://www.mysql.com/support/supportedplatforms/tools.html

More informations about MySQL Workbench you will find here:

http://dev.mysql.com/workbench/