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.
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.054 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.