<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEEDINFO "
title="NEEDINFO - MySQL native connector: Creating foreign key creates a relationship to the foreign key itself"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=122437#c5">Comment # 5</a>
on <a class="bz_bug_link
bz_status_NEEDINFO "
title="NEEDINFO - MySQL native connector: Creating foreign key creates a relationship to the foreign key itself"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=122437">bug 122437</a>
from <span class="vcard"><a class="email" href="mailto:elderdanlewis@gmail.com" title="Dan Lewis <elderdanlewis@gmail.com>"> <span class="fn">Dan Lewis</span></a>
</span></b>
<pre>(In reply to Alex Thurgood from <a href="show_bug.cgi?id=122437#c4">comment #4</a>)
<span class="quote">> 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.</span >
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.)</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>