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
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');


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
[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