Cannot separate two relations on same column to two separate child colums in another table

Bug #513943 reported by AD5XJ
8
This bug affects 1 person
Affects Status Importance Assigned to Milestone
DB modeling tool
New
High
Unassigned

Bug Description

If you attempt to add two relations from the same column in table 1 to two separate columns of table 2, the edit of one relation is stored for both relations. There is no separation of conditions.

Environment:
Ubuntu Linux 9.10 (Karmic Koala) Gnome 2.28.1 Kernel 2.6.31-17
CPU: Intel P4 2.8 Ghz 1 Gb ram
Qt SDK 4.6.1 QtCreator 1.3.1

Revision history for this message
Lukáš Lalinský (luks) wrote :

Yes, this is a known problem. The way relationships work will have to be reworked.

Changed in dbmodel:
importance: Undecided → High
milestone: none → 0.4
Revision history for this message
deep42thought (deep42thought) wrote :

I was bothered by the same. The attached patch fixes the "crossing links" issue:
So far links were ordered by direction and if that was identical, then they were ordered by the link references. Since links between the same tables have same directions, this leads to crossing links.
I changed the ordering to:
1st: by direction (as before)
2nd: by wether we are start or end of the link
3rd: by reference of link ascending if we're the start and descending if we're the end.

Note, that links may still be behind tables and in seemingly ugly places, but at least they do not cross anymore.

Revision history for this message
deep42thought (deep42thought) wrote :

sry, I wrote this to the wrong bug report :-/

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.