[Libreoffice-bugs] [Bug 122437] New: creating foreign key creates a relationship to the foreign key itself

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 122437
           Summary: creating foreign key creates a relationship to the
                    foreign key itself
           Product: LibreOffice
           Version: 6.2.0.1 rc
          Hardware: x86-64 (AMD64)
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Base
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: elderdanlewis at gmail.com

Created attachment 147959
  --> https://bugs.documentfoundation.org/attachment.cgi?id=147959&action=edit
It's the relationship created by the native MySQL connector

I am using the new built in native MySQL Connector. When creating a new
relationship between two tables, rather than relating the foreign key of one
table to the primary key of the other; a relationship is created between the
foreign key and itself! This is seen in Tools > Relationship in the main
database window where every primary-foreign relationship shows this.

Example: "tableA"."primary key" should be related to "tableB"."foreign key"
Instead:
          "tableB"."foreign key: is related to "tableB"."foreign key"

 The problems seems to be in the new MySQL connector. When connecting to the
same database using either MySQL(JDBC) [mysql-connector-java-5.1.45,
mysql-connector-java-8.0.13], Tools > Relationships shows the proper
primary-foreign key pairs.

The database was created in the following way: 
1) Using the database wizard, I selected "Connect to an existing database and
selected "MySQL from the drop down menu.
2) Selected "Connect directly"
3) I entered the database name and listed localhost as the server.
4) I entered my user name and checked "password required"
5) Selected "Yes, register the database for me." I checked "Open the database
for editing."

-- 
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/20190103/8d7d63f1/attachment-0001.html>