| Bug #38515 | Insert VALUES repeated when importing model from DBDesigner4 | ||
|---|---|---|---|
| Submitted: | 1 Aug 2008 7:05 | Modified: | 1 Aug 2008 7:06 |
| Reporter: | Simon Hodgson | Email Updates: | |
| Status: | Duplicate | Impact on me: | |
| Category: | MySQL Workbench | Severity: | S3 (Non-critical) |
| Version: | 5.0.23 | OS: | Any |
| Assigned to: | CPU Architecture: | Any | |
[1 Aug 2008 7:05]
Simon Hodgson
This file reproduces this problem
Attachment: example.xml (text/xml), 22.75 KiB.
[1 Aug 2008 7:06]
Johannes Taxacher
this is a duplicate of http://bugs.mysql.com/bug.php?id=38196
Description: When a model is imported from DBDesigner the VALUES section is repeated in the new workbench model, eg: INSERT INTO `table` (field1, field2) VALUES ('foo', 'bar'); Becomes... INSERT INTO `table` (field1, field2) VALUES ('foo', 'bar') VALUES ('foo', 'bar'); There is a workaround, once the model has been imported into Workbench, open the insert editor then close it and the inserts will be corrected. Repeat for every table in the schema that has inserts. How to repeat: Import the attached DBDesigner Model into Workbench