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
• Status: Duplicate
• Category: MySQL Workbench: Modeling
• Severity: S3 (Non-critical)
• Version: 5.2.33.7506
• OS: Any
• 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