https://bugs.documentfoundation.org/show_bug.cgi?id=151875
Bug ID: 151875
Summary: MySQL/MariaDB direct Connection: Column Description
won't be saved
Product: LibreOffice
Version: 7.4.2.3 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Base
Assignee: [email protected]
Reporter: [email protected]
Created attachment 183388
--> https://bugs.documentfoundation.org/attachment.cgi?id=183388&action=edit
Screenshot of "Description" (saved in *.odb) and "Column Description" (saved in
MariaDB)
Open a *.odb-file connected by direct connection to MySQL/MariaDB.
Create a new table.
In dialog you could see "Field Name", "Filed Type", "Description" and "Column
Description".
Write down a "Description" and a "Column Description". Might be the same
content, better is a different content for getting the difference.
Save the table.
The "Column Description" won't be saved, the description has been lost.
Do the same connecting with JDBC driver to MariaDB (here:
mariadb-java-client-2.4.1.jar)
"Column Description" will be saved.
"Column Description" is saved by the command COMMENT in MariaDB. So you could
read this description when connecting to MariaDB with any other connector, not
only (like "Description") with a special *.odb-file.
Close the JDBC-connected file and reopen the direct connection.
Open the new created table for editing, not for input data.
You could read the column description with direct connection. So only saving
this description as COMMENT in the database has to be added.
Note: If you are using a LO-version from a Linus distribution could be the
"Column Description" is missing. Special OpenSUSE doesn't show this, but LO
directly from LibreOffice will show the content.
--
You are receiving this mail because:
You are the assignee for the bug.
