<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body>
<p>
<div>
<b><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Nested Queries using MySQL(JDBC) fail"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=123879#c7">Comment # 7</a>
on <a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Nested Queries using MySQL(JDBC) fail"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=123879">bug 123879</a>
from <span class="vcard"><a class="email" href="mailto:iplaw67@tuta.io" title="Alex Thurgood <iplaw67@tuta.io>"> <span class="fn">Alex Thurgood</span></a>
</span></b>
<pre>(In reply to tim from <a href="show_bug.cgi?id=123879#c5">comment #5</a>)
<span class="quote">> I need a bit more help with this. I'm not sure exactly what you mean.
>
> In my java class paths I have:
>
> /usr/share/java/mysql-connector-java.jar
> /usr/share/java/mariadb-java-client-2.4.0.jar
>
> Should I try something different?
> </span >
In my experience, having both of the above confuses LO leading to inconsistent
results when using the underlying database. I encountered strange behaviour
when I had a similar setup, which is unfortunate, as one of my LAN database
servers is mariadb, whereas my localhost server (running on the same machine as
LO) is mysql.
Try removing the first path entry, applying the changes, closing LO completely,
then restarting.</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>