https://bugs.documentfoundation.org/show_bug.cgi?id=157916
Bug ID: 157916
Summary: MySQL/MariaDB direct Connection: Impossible to input
data in a query for more than one table
Product: LibreOffice
Version: unspecified
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Base
Assignee: [email protected]
Reporter: [email protected]
Open any *.odb-file connected to MariaDB with direct connection.
There should be 2 tables, which could be connected by a query.
Connect this 2 tables in a query.
Query is write protected every time you create a query.
Now change to edit SQL.
You have to delete databasename and alias tablename and the query will be work
well.
If name of database is the same for all tables in a query editing should be
allowed like for internal HSQLDB, internal Firebird or, for example, MariaDB
with JDBC-connection. MariaDB for JDBC connection also allows the Alias for a
combination of database.table and query could be filled with data…
Bug appears in LO 7.6.2.1, but also in all other versions I could test since we
have included direct connection for MariaDB.
--
You are receiving this mail because:
You are the assignee for the bug.
