Bug #60504 invalid index names are created (with mysql server 5.5)
Submitted: 17 Mar 2011 10:06 Modified: 17 Mar 2011 13:06
Reporter: Henrik Gemal Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Workbench: Modeling Severity:S3 (Non-critical)
Version:5.2.33.7506 OS:Any
Assigned to: CPU Architecture:Any

[17 Mar 2011 10:06] Henrik Gemal
Description:
when I create table that have a reference to another table I get the following SQL code:

-------------
CREATE  TABLE IF NOT EXISTS `table_statuses` (
  `id` INT UNSIGNED NOT NULL AUTO_INCREMENT ,
  `restaurant_id` INT UNSIGNED NOT NULL ,
  `tableName` VARCHAR(90) NULL ,
  `lastModified` DATETIME NULL ,
  PRIMARY KEY (`id`) ,
  CONSTRAINT `fk_table_statuses_restaurants1`
    FOREIGN KEY (`restaurant_id` )
    REFERENCES `restaurants` (`id` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;

CREATE UNIQUE INDEX `id_UNIQUE` ON `table_statuses` (`id` ASC) ;

CREATE INDEX `fk_table_statuses_restaurants1` ON `table_statuses` (`restaurant_id` ASC) ;
-------------

when I try to execute that on my MySQL server 5.5 I get:

"SQL ERROR 1280: Incorrect index name 'fk_table_statuses_restaurants1'"

How to repeat:
create a table with reference to another table
forward to server
[17 Mar 2011 11:02] Valeriy Kravchuk
This is probably a duplicate of Bug #51580.
[17 Mar 2011 13:06] Henrik Gemal
dont thinks so it's a dupe of that bug.

Since this is about workbench creating a invalid index name.
and it's only invalid on mysql version 5.5. Works on 5.1