<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Mysql/MariaDB - native connector timestamp values displayed as floating numbers in Table data entry mode"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=122516">122516</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Mysql/MariaDB - native connector timestamp values displayed as floating numbers in Table data entry mode
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.3.0.0.alpha0+ Master
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>Linux (All)
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Base
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>iplaw67@tuta.io
</td>
</tr></table>
<p>
<div>
<pre>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:</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>