Bug #40059 Create an empty index is allowed
Submitted: 15 Oct 2008 15:38 Modified: 15 Oct 2008 16:03
Reporter: moi meme Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:5.0.26 OS:Any
Assigned to: CPU Architecture:Any

[15 Oct 2008 15:38] moi meme 
Description:
Empty indexes generates incorrect scripts

How to repeat:
create a table with a column A
create an unique index and "forget" to tick the A checkbox
Export the script and try to execute it

Suggested fix:
Forbid empty indexes
[15 Oct 2008 16:03] Johannes Taxacher 
there's a validation feature in SE version that informs the user about an issue like this. In OSS version you'll have to take care of this yourself. But when you have the corresponding tables sitting on a diagram, you'll recognize that as long as the FK isn't defined completely, the connection is not drawn (as indicator that there's not yet a valid connection), in all WB versions.
[15 Oct 2008 16:08] Johannes Taxacher 
sorry, my comment was about a similar handling for FKs (i mixed it up). theres no indicator for indexes which have no columns assigned in OSS version, but there still is a check in SE version that warns the user about it.