Bug #56431 | MySql Workbench allows you to use reserve word for table name | ||
---|---|---|---|
Submitted: | 31 Aug 2010 23:05 | Modified: | 12 Mar 2014 3:42 |
Reporter: | Thomas Vincent | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Workbench: Modeling | Severity: | S2 (Serious) |
Version: | 5.2.25, 5.2.27 | OS: | MacOS |
Assigned to: | Assigned Account | CPU Architecture: | Any |
[31 Aug 2010 23:05]
Thomas Vincent
[1 Sep 2010 3:42]
Valeriy Kravchuk
Code generated by Workbench in this case will work: -- ----------------------------------------------------- -- Table `mydb`.`group` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `mydb`.`group` ( `id` INT NOT NULL , `c1` VARCHAR(45) NULL , PRIMARY KEY (`id`) ) ENGINE = InnoDB; because reserved word is quoted, so it's not a bug IMHO, but it would be a nice feature to warn about reserved word used.
[12 Mar 2014 3:42]
Philip Olson
Fixed as of the upcoming MySQL Workbench 6.1.3 release, and here's the changelog entry: MySQL Workbench would allow a table group to be renamed as a reserved MySQL keyword. Thank you for the bug report.