[Libreoffice-bugs] [Bug 122516] New: Mysql/MariaDB - native connector timestamp values displayed as floating numbers in Table data entry mode

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=122516

            Bug ID: 122516
           Summary: Mysql/MariaDB - native connector timestamp values
                    displayed as floating numbers in Table data entry mode
           Product: LibreOffice
           Version: 6.3.0.0.alpha0+ Master
          Hardware: All
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Base
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: iplaw67 at tuta.io

Description:
1) Create the following mysql/mariadb table from the mysql command line :

create table employee (ID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, fname
varchar(30), lname varchar(50), ts timestamp DEFAULT CURRENT_TIMESTAMP ON
UPDATE CURRENT_TIMESTAMP);

Add some data to the table :

INSERT into employee vALUES (NULL,'Peter','Haven',NULL);
INSERT into employee vALUES (NULL,'Anne','Jones',NULL);
INSERT into employee vALUES (NULL,'Lars','Hedegaard',NULL);


2) Create an ODB file that connects to the database containing the table.
Double-click on the table entry 'employee' in the list of tables.

3) Notice how the timestamp fields are displayed as a DECIMAL value and is
incorrect as it clearly represents a rounded value.

4) The display format can be changed for the current session to display the
timestamp values, but this is not saved on shutdown and reload of the ODB file.

5) Point (4) is at best a temporary and transitory workaround, as the grid view
should display the timestamp value rather than some converted decimal value.

Steps to Reproduce:
See above

Actual Results:
Incorrect (and inprecise) conversion of timestamp values to decimal value in
table data entry mode (grid view).

Expected Results:
The timestamp values should be displayed as they actually exist in the DB.


Reproducible: Always


User Profile Reset: Yes



Additional Info:

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190106/5218964d/attachment.html>