Bug 67446 - FILEOPEN: Timestamp not shown correct in MariaDB connected direct to Base
Summary: FILEOPEN: Timestamp not shown correct in MariaDB connected direct to Base
Status: RESOLVED INVALID
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
4.1.0.0.beta1
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2013-07-28 18:32 UTC by Robert Großkopf
Modified: 2013-08-01 05:53 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Robert Großkopf 2013-07-28 18:32:25 UTC 
Since LO 4.1.0.0.beta1 timestamps in a MariaDB, connected with the direct connection to Base, are shown in many different wrong versions:
Start is the right timestamp, fomatted with a German date.
28.07.13 18:13

LO 4.1.0.0.beta1 shows 30.01.24 04:18
LO 4.1.0.0.beta2 shows 02.05.-23647 04:18
LO 4.1.0.1 shows 30.05.-7708 04:18
LO 4.1.0.2 shows 23.01.-28626 04:18

... and since LO 4.1.0.3 and later the table couldn't be opened. No row is shown any more. See also: https://bugs.freedesktop.org/attachment.cgi?id=83140

You could say, that's a special bug with the direct connector. Don't know, why this connector could read the right values in LO 4.0 and the wrong only in 4.1.* - must be something, that has been changed in LO. Connection with other tables without time or timestamp works right.
Comment 1 Lionel Elie Mamane 2013-08-01 05:45:15 UTC 
Do you use a MySQL connector that has been compiled for the LibreOffice version you are using? There were date&time-datatype changes in the 4.1 development cycle, up to 4.1.0.3.
Comment 2 Lionel Elie Mamane 2013-08-01 05:52:11 UTC 
As per bug 67445#c0, I assume that you use a MySQL connector compiled for Apache OpenOffice instead of one for LibreOffice 4.1.

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)