Bug #64990 | New table in model with Double datatyp..Synchronize generates invalid syntax sql | ||
---|---|---|---|
Submitted: | 16 Apr 2012 1:25 | Modified: | 24 Jul 2012 0:40 |
Reporter: | David Oliver | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Workbench: Modeling | Severity: | S2 (Serious) |
Version: | 5.2.38, 5.2.39 | OS: | Any |
Assigned to: | CPU Architecture: | Any |
[16 Apr 2012 1:25]
David Oliver
[16 Apr 2012 8:59]
Valeriy Kravchuk
Yes, the following code is generated: Executing SQL script in server ERROR: Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') NULL DEFAULT NULL , PRIMARY KEY (`id`) ) ENGINE = InnoDB DEFAULT CHARACTER S' at line 3 CREATE TABLE IF NOT EXISTS `mydb`.`table2` ( `id` INT(11) NOT NULL , `c1` DOUBLE(11) NULL DEFAULT NULL , PRIMARY KEY (`id`) ) ENGINE = InnoDB DEFAULT CHARACTER SET = latin1 COLLATE = latin1_swedish_ci SQL script execution finished: statements: 3 succeeded, 1 failed Proper code is generated during forward engineering though.
[16 Apr 2012 9:04]
Valeriy Kravchuk
Bug #64920 was marked as a duplicate of this one.
[24 Jul 2012 0:40]
Philip Olson
This has been fixed as of the soon-to-be-released Workbench 5.2.41, and here's the changelog entry: Creating and then synchronizing a table in a model with a "DOUBLE" typed column would generate invalid SQL, thus generating an "Invalid SQL syntax" error.