MySQL Bugs: #32520: Able to create two identical columns

Bug #32520	Able to create two identical columns
Submitted:	20 Nov 2007 13:50	Modified:	29 Nov 2007 14:09
Reporter:	marc castrovinci (Basic Quality Contributor)	Email Updates:
Status:	Won't fix	Impact on me:	None
Category:	MySQL Workbench	Severity:	S3 (Non-critical)
Version:	5.09 OSS BETA, 5.0.23 OSS	OS:	Windows (XP SP2)
Assigned to:		CPU Architecture:	Any
Tags:	add, create column, error, identical, qc

Description:
You can name two columns in a table the same name. Workbench doesn't alert the user to a problem. Then when loading the forward engineered script, you get an error.

How to repeat:
Create a new table. 
Add 3 columns, naming the last two the same and having the same data type.
Export to sql file.
Run the script on the MySQL server.

You will get an error about a duplicate column. 
(ERROR 1060 (42S21) at line 13: Duplicate column name 'foo')

Suggested fix:
After the user adds a column that is duplicate, alter the user with a pop up and make them change it.

Thank you for a bug report. Verified just as described.

Using the OSS Edition you should have a given level of knowledge and not make a mistake like this.

If you would like an additional safety net this is one of the main reasons we encourage people to upgrade to the Standard Editions which has a set of model validation features that will alert you about such cases.

Not having this validations in the OSS Edition does not cripple the product but allows the SE to add additional value. I hope this logic can be understood.