Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Not a Bug
-
10.0(EOL), 10.1(EOL), 10.2(EOL), 10.3(EOL)
-
None
Description
CONNECT engine truncates microseconds in TIMESTAMP/DATETIME values upon storing them:
MariaDB [test]> create table tc (t timestamp(6)) engine=CONNECT table_type=DOS file_name='tc.file'; |
Query OK, 0 rows affected (0.03 sec) |
|
|
MariaDB [test]> insert into tc values ('2012-12-12 12:12:12.123456'); |
Query OK, 1 row affected (0.01 sec)
|
|
|
MariaDB [test]> select * from tc; |
+----------------------------+ |
| t |
|
+----------------------------+ |
| 2012-12-12 12:12:12.000000 |
|
+----------------------------+ |
1 row in set (0.00 sec) |
$ cat data/test/tc.file
|
1355307132
|
As a side-effect, system versioning for CONNECT tables does not work at all.