[Libreoffice-bugs] [Bug 45257] EDITING postgreSQL-SDBC Relation designer does not pick up all existing relationships

[bugzilla-daemon at freedesktop.org]

https://bugs.freedesktop.org/show_bug.cgi?id=45257

--- Comment #2 from Alex Thurgood <iplaw67 at yahoo.co.uk> 2012-07-23 08:05:15 UTC ---
Drew,

I can confirm similar behaviour with regard to the native mysql connector
extension and a mysql server.

The problem appears to indeed lie with the Relationship designer tool/dialog.

In my own case :

- dragging and dropping to create a relationship between two tables appears to
work, but only once between any two tables - in reality, the relationship is
not created, the graphical UI representation always default to the first entry
in the first table's field list, and if you click on the link to edit the
relationship displays only one half, as it turns out the second table to which
the link was made without referencing any field from the first table !!!

- trying to manually create a relationship by clicking on the Define button
allows one to choose the fields from the tables to be linked, but when
validated, fails to do this correctly, i.e. we get a repeat of the scenario
above, whereby only the first field of one table appears, and this link only
includes one field from one table, and not even the one that was defined by the
user !!!

The whole relationship design tool/dialog seems broken, at least for external
db's, I haven't tried with hsqldb internal.



Alex

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.