[Libreoffice-bugs] [Bug 130532] New: Relationship graph does not show up one to one relationship

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=130532

            Bug ID: 130532
           Summary: Relationship graph does not show up one to one
                    relationship
           Product: LibreOffice
           Version: 6.3.4.2 release
          Hardware: x86-64 (AMD64)
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Base
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: cthomassin at hotmail.com

Description:
After setting a FK field to unique via SQL command, the relationship graph
still  shows up a one to many relationship between my two tables.

https://ask.libreoffice.org/en/question/228432/one-to-one-relation-relationship-graph-does-not-show-up/
https://ask.libreoffice.org/fr/question/228412/graphe-de-relation-ne-montrant-pas-une-relation-11/

Steps to Reproduce:
1.create two tables with a PK in each one
2.create a FK in one table
3.set the FK to unique with SQL command to create a one to one relationship
between the two tables
4.consult the relationship graph that shows a 1,N relation instead of a 1,1
relation

Actual Results:
the relationship graph shows a 1,N relation instead of 1,1 relation

Expected Results:
The relationship graph should shows up a 1,1 relation


Reproducible: Always


User Profile Reset: Yes



Additional Info:
The relationship graph shows up a 1,N relation

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200208/99785ce5/attachment.htm>