https://bugs.documentfoundation.org/show_bug.cgi?id=119139
--- Comment #34 from Robert Großkopf <[email protected]> --- Tested with mysql-connector-java-8.0.29.jar and connection string mysql://localhost/test?useUnicode=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC Existing timestamp field will not be shown in the table. It won't be shown, because it is defined as NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP Other timestamp and datetime fields will be shown with this connector and MariaDB on OpenSUSE 15.3 64bit rpm Linux. Same behavior with mysql-connector-java-5.1.33.jar and connection without special connection string. Won't happen with JDBC-MariaDB-connector. Now I open the query editor for creating a query, choose the table and the timestamp-field will be shown. Executing a query SELECT * FROM `test`.`Tabelle1` and the field has gone. Executing SELECT `Tabelle1`.*, `Tabelle1`.`DirectTime` FROM `test`.`Tabelle1` `Tabelle1` and the field appears. Executing SELECT * FROM `test`.`Tabelle1` through tools → SQL and the field appears. This all seems to be a special GUI problem of LO Base. -- You are receiving this mail because: You are the assignee for the bug.
