https://bugs.documentfoundation.org/show_bug.cgi?id=99978
Bug ID: 99978
Summary: MariaDB - JDBC: Field not shown in table/query, if set
ON UPDATE CURRENT_TIMESTAMP
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]
Created attachment 125208
--> https://bugs.documentfoundation.org/attachment.cgi?id=125208&action=edit
Run the SQL-code to create DB, change the user and have a look at the table
A special problem with JDBC-connection an MariaDB/MySQL-DB.
Create a table in MySQL/MariaDB.
Set one datetime-field to DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP.
This field won't be shown if opening the table with Base, if connected to the
DB with JDBC. Works right with direct connection.
This field won't be shown in a query also.
Added an example database and the SQL-code to create the database and table.
There must be changed the user to connect to the database.
This code will be executed:
CREATE TABLE IF NOT EXISTS `table` (
`ID` mediumint(7) NOT NULL,
`Name` varchar(100) DEFAULT NULL,
`DateTime_Default` datetime DEFAULT CURRENT_TIMESTAMP,
`DateTime_OnUpdateDefault` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
`Field5` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
Five fields. Four fields will be shown, when opening the table in LO-Base for
input values. Five fields will be shown, when opening the table for editing the
structure of the table.
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
