[Libreoffice-bugs] [Bug 123879] New: Nested Queries using MySQL(JDBC) fail

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 123879
           Summary: Nested Queries using MySQL(JDBC) fail
           Product: LibreOffice
           Version: 6.1.5.2 release
          Hardware: x86-64 (AMD64)
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Base
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: tim at tim-passingham.co.uk

Created attachment 149749
  --> https://bugs.documentfoundation.org/attachment.cgi?id=149749&action=edit
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.

-- 
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/20190305/23ae511a/attachment.html>