------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.
http://bugs.kde.org/show_bug.cgi?id=138139
Summary: Incorrect export to SQL
Product: umbrello
Version: unspecified
Platform: Gentoo Packages
OS/Version: Linux
Status: UNCONFIRMED
Severity: normal
Priority: NOR
Component: general
AssignedTo: umbrello-devel.kde.org
ReportedBy: alexeyp gmail com
Version: (using KDE KDE 3.5.5)
Installed from: Gentoo Packages
Compiler: gcc 4.1.1
OS: Linux
The SQL export is incorrect as soon as the diagram is over about 50 objects, and associations between objects were dropped and recreated.
The following problems are detected:
1) Export to SQL ignores associations when a field of the table refers to another field of the same table.
2) With the large diagram (over 70..90) objects, some associations are repeated during the export multiple times (as CONSTRAINT .. FOREIGN KEY)
3) The generated CREATE TABLE statement contains CONSTRAINTS. That requires to execute output .sql files in certain order.
4) .XMI file contains hundreds of bogus connections. Some edit+save operations cause file size to double. I've given name to all the connections, yet hundreds of connections with name="" exist in the file. I didn't find any workaround for this yet.
I have a patch that fixes 1)..3). I'll try to attach it here if I find how.