https://bugs.documentfoundation.org/show_bug.cgi?id=165991
Bug ID: 165991
Summary: MySQL/MariaDB direct Connection: Forms need
Databasename.Tablename for connecting to tables
Product: LibreOffice
Version: 25.2.1.2 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Base
Assignee: [email protected]
Reporter: [email protected]
Open a database with direct connection to MariaDB.
Create a form and connect to one of the tables.
Try the connection - will work.
Now have a look at the connection. It will show in properties of the form
(Formnavigator) Databasename.Tablename
You could try to choose Tablename without Databasename but an error appears.
Now create a query:
SELECT * FROM "Tablename"
Note: The query will run without database name. It isn't needed but always
constructed by the BaseGUI, because the GUI could connect to all databases the
user has access to.
You could connect the form to this query without name of the database. Data
will be shown well.
Expected behavior: If no database name has been defined in a form the database,
which has been defined in the connection, should be used.
Problem: When database name is needed in a form everybody, who couldn't define
the database name on a server (but could create all the content for the
database) has to change all forms to the new name. Special for creating
databases for other people the only solution at this moment is: Create queries
for every table to get the forms independent of the database name.
--
You are receiving this mail because:
You are the assignee for the bug.
