[Libreoffice-bugs] [Bug 122437] MySQL native connector: 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

--- Comment #5 from Dan Lewis <elderdanlewis at gmail.com> ---
(In reply to Alex Thurgood from comment #4)
> Dan :
> 
> You don't mention how you created the relations.
> 
> 1) Via the mysql commqnd line or another DBMS tool ;
> 2) Via drag and drop using the LO relations editor
> 3) Via the Relations menu dialog (Add relation button).
> 
> I'm assuming via the LO GUI but it would be nice to have those details fro
> reproducibility.

    The relationships were created in a new database back in 2014 or earlier
using whatever LibreOffice was current at the time. I have been using this
database ever since upgrading LO as new versions became available. If my memory
is correct, I was still using the MySQL connector extension last spring that I
had created back in 2013 to connect to MySQL.
    I should also mention that at the time I filed this bug, I was using MySQL
5.7. along with MySQL Workbook 8.0.13. The relationships were working in
Workbook then. However, after making sure I had a connection between Workbook
and Base and had saved these relationships, I opened a Base database using the
native MySQL connector. That is when I saw that the relationships were wrong.
    I have since upgraded MySQL to version 8.0.13 and also have the MySQL(JDBC)
8.0.13 driver which I can use with LO 6.2.0.1 to access MySQL with apparently
no problems. (The native MySQL connector will no longer connect to the MySQL
database. A different problem, I know.)

-- 
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/20190106/0b5e50b9/attachment.html>