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@lists.freedesktop.org
Reporter: t...@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.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs