<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><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">123879</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Nested Queries using MySQL(JDBC) fail
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.1.5.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>x86-64 (AMD64)
</td>
</tr>
<tr>
<th>OS</th>
<td>Linux (All)
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Base
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>tim@tim-passingham.co.uk
</td>
</tr></table>
<p>
<div>
<pre>Created <span class=""><a href="http://bugs.documentfoundation.org/attachment.cgi?id=149749" name="attach_149749" title="Test database">attachment 149749</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=149749&action=edit" title="Test database">[details]</a></span>
Test database
In version Version: 6.1.5.2
Build ID: 1:6.1.5~rc2-0ubuntu0.18.10.1~lo3
CPU threads: 8; OS: Linux 4.18; UI render: default; VCL: x11;
Locale: en-GB (en_GB.UTF-8); Calc: group threaded
I have a problem with some queries when using MySQL(JDBC). MySQL(Native) works
fine.
In the sample, using JDBC, Query NIC4RatesPivot works, but NIC4RatesPivotOld
fails, stating that table NIC4Rates does not exist. But it does, as a query in
the LibreOffice database.
Changing to MySQL(Native) fixes the problem.
I don't know how old this issue is, but it affects many of my nested queries.
SQL for the underlying tables is attached separately. The database is actually
MariaDB 10.3.</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>