| Bug #47461 | Workbench generates faulty CREATE TABLE statements | ||
|---|---|---|---|
| Submitted: | 20 Sep 2009 18:35 | Modified: | 20 Sep 2009 18:37 |
| Reporter: | Rudy Pedraza | Email Updates: | |
| Status: | Duplicate | Impact on me: | |
| Category: | MySQL Workbench | Severity: | S1 (Critical) |
| Version: | 5.2.3 | OS: | MacOS (10.5.x or 10.6.x) |
| Assigned to: | CPU Architecture: | Any | |
| Tags: | Workbench CREATE TABLE missing partenthesis | ||
[20 Sep 2009 18:37]
Valeriy Kravchuk
Please do not submit the same bug more than once. An existing bug report, bug #47407, already describes this very problem. Even if you feel that your issue is somewhat different, the resolution is likely to be the same. Because of this, we hope you add your comments to the original bug instead. Thank you for your interest in MySQL.
Description: In the new Alpha 5.2.3 CREATE TABLE statements are generated incorrectly due to missing ')' after PRIMARY KEY. This happens in Export, or any of the Synchronization/Forward Engineer menu items. BTW: Much thanks and praise to the MySQL and Workbench team(s) for making such an incredible product! Exmaple below: -- ----------------------------------------------------- -- Table `test1`.`SoftwareUpdate` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `test1`.`SoftwareUpdate` ( `SoftwareID` INT NOT NULL AUTO_INCREMENT , `SoftwareURL` VARCHAR(45) NULL , `SoftwareName` VARCHAR(45) NULL , PRIMARY KEY (`SoftwareID`) ENGINE = InnoDB; How to repeat: Create table with a primary key, try to generate SQL or Forward Engineer model to live server. Suggested fix: make sure to add a ')' after the Primary Key so that tables get created.