https://bugs.freedesktop.org/show_bug.cgi?id=59200
Priority: medium
Bug ID: 59200
Assignee: [email protected]
Summary: ODBC - incorrect display with NULL timestamp values
using Actual Technologies ODBC driver
Severity: normal
Classification: Unclassified
OS: Mac OS X (All)
Reporter: [email protected]
Hardware: x86-64 (AMD64)
Status: UNCONFIRMED
Version: 4.1.0.0.alpha0+ Master
Component: Database
Product: LibreOffice
Connecting to a locally hosted mysql database via the Actual Technologies ODBC
driver for Mac OSX.
The table contains NULL timestamps values, which mysql represents as :
SQL> select * from action_type;
+----------------+-----------------------------------------+---------------+--------------------+
| type | comments | action_type_id|
chg_date |
+----------------+-----------------------------------------+---------------+--------------------+
| A.94(3) EPC | Normal examiner office action | 1 |
0000-00-00 00:00:00|
| R.71(3) EPC | Intention to grant communication | 2 |
0000-00-00 00:00:00|
| R.51(6) EPC | Notice of grant communication | 3 |
0000-00-00 00:00:00|
+----------------+-----------------------------------------+---------------+--------------------+
SQLRowCount returns 3
3 rows fetched
However, the same table in LO master build :
Version 4.1.0.0.alpha0+ (Build ID: 989863d849b1e703e78afc413088c3ae5109313)
TinderBox: MacOSX-Intel@1-built_no-moz_on_10.6.8, Branch:master, Time:
2013-01-06_10:52:34
shows the following :
02/01/1 00:00
02/01/1 00:00
02/01/1 00:00
The format of the date column is supposed to be in the default locale of the
machine, i.e. French format of DDMMYYYY hh:mm, yet this this is displayed
incorrectly on screen as above.
Alex
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
