Bug 67445

Summary: FILEOPEN: Time not shown correct in MariaDB connected direct to Base
Product: LibreOffice Reporter: Robert Großkopf <robert>
Component: BaseAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED INVALID    
Severity: normal CC: lionel
Priority: medium    
Version: 4.1.0.0.beta1   
Hardware: x86-64 (AMD64)   
OS: Linux (All)   
See Also: https://bugs.freedesktop.org/show_bug.cgi?id=67446
Whiteboard:
Crash report or crash signature: Regression By:
Attachments: Time (and Timestamp) in connections between MariaDB and Base - bugs since LO 4.1.*

Description Robert Großkopf 2013-07-28 18:17:47 UTC 
Created attachment 83140 [details]
Time (and Timestamp) in connections between MariaDB and Base - bugs since LO 4.1.*

There seem to be some problems with date and time in the connection between MySQL/MariaDB and Base. This is the first for the time and the direct connection (connector: http://code.google.com/a/apache-extras.org/p/aoo-my-sdbc/)

When I open a MariaDB-table with a time in LO up to 4.0.4.2 the time is shown, for example, as 20:13:16. Works with the direct connector and with JDBC.

When I open the same table with LO 4.1.0.0.beta1 and all other 4.1-versions, LO shows with the direct connection 00:20:13 instead of 20:13:16. The connection with JDBC works right in this case.
Comment 1 Lionel Elie Mamane 2013-08-01 05:50:30 UTC 
Apache OpenOffice and LibreOffice have diverged as far as date&time datatypes are concerned. A connector compiled for Apache OpenOffice will not work with LibreOffice, especially in the date & time area.

Reopen if you can reproduce with LibreOffice 4.1.0.4 or later, with a connector compiled for LibreOffice 4.1.0.4 (the release version, not an alpha/beta/rc).