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:
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

[20 Nov 2007 13:50] marc castrovinci
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.
[20 Nov 2007 14:52] Valeriy Kravchuk
Thank you for a bug report. Verified just as described.
[29 Nov 2007 14:09] Michael G. Zinner
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.