[Libreoffice-bugs] [Bug 127343] When creating a query in design view using MySQL as a backend (Connector/J), I can not access any tables in the Add Tables dialog

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #5 from Alex Thurgood <iplaw67 at tuta.io> ---
@Xisco : with an embedded hsqldb, only the tables are shown, not the schema.

Historically, the fact that all of the schema are shown with a mysql JDBC
connection is an error, as the connection setup requires a schema to be
selected before connection. The fact that the specific choice of schema was not
used to filter out the others in the displays of tables, queries, views, etc
is/was a bug. This is why mutliple schema were displayed with a tree structure
to allow the user to select any given table from any of the available schema.
The issues of only displaying the pre-defined schema was addressed by the
introduction of a working filter for the schema, allowing a user to exclude
from view the other schema (menu Tools > Table Filter), and required a refresh
of the tables, or in some circumstances, a reconnection to the database
(closing/re-opening ODB file).

This doesn't happen with embedded hsqldb because it is, to all intents and
purposes, single schema, the hsqldb system information schema is hidden from
the user within LO and only accessible via SQL.

-- 
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/20190905/0bb7fa67/attachment.html>