[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

2019-09-05 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=127343

Alex Thurgood  changed:

   What|Removed |Added

 Ever confirmed|0   |1
 OS|Linux (All) |All
   Severity|normal  |major
   Priority|medium  |high
 Status|UNCONFIRMED |NEW
   Keywords||bibisectRequest, regression

--- Comment #6 from Alex Thurgood  ---
Confirming that tree view of schema, with tables listed underneath, appears in
LO6252, using the native, direct mysql connector.

Confirming the display of schema and tables as reported by Dan in LO6304.
Only the first alphabetically sorted schema displays any tables in my test, the
other schema being displayed, but no operable action on them is possible, i.e.
clicking on them does not unroll the tree.

This is a regression over the behaviour in LO62, especially seeing as the first
alphabetically sorted schema may not even be the one defined in the connection
properties.

-- 
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

[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

2019-09-05 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=127343

--- Comment #5 from Alex Thurgood  ---
@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.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[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

2019-09-05 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=127343

Xisco Faulí  changed:

   What|Removed |Added

 CC||caol...@redhat.com,
   ||xiscofa...@libreoffice.org

--- Comment #4 from Xisco Faulí  ---
I don't know how to test it but the dialog was weld in
https://cgit.freedesktop.org/libreoffice/core/commit/?id=c5edb541337054412fb1d5037de6c50397ab053f

@Caolán, I thought you might be interested in this issue!!

@Dan Lewis, Does it only happen with MySQL ?

-- 
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

[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

2019-09-05 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=127343

Xisco Faulí  changed:

   What|Removed |Added

 CC||mr...@mckanes.com

--- Comment #3 from Xisco Faulí  ---
*** Bug 127358 has been marked as a duplicate of this bug. ***

-- 
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

[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

2019-09-04 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=127343

--- Comment #2 from Dan Lewis  ---
Created attachment 153878
  --> https://bugs.documentfoundation.org/attachment.cgi?id=153878=edit
Screen shot for LO 6.2.6.1

-- 
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

[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

2019-09-04 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=127343

--- Comment #1 from Dan Lewis  ---
Created attachment 153877
  --> https://bugs.documentfoundation.org/attachment.cgi?id=153877=edit
Screen show for LO 6.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