Details
-
Sub-Task
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
None
-
None
-
2018-08, 2018-09, 2018-10, 2018-11, 2018-12, 2018-13, 2018-14, 2018-15, 2018-16, 2018-17, 2018-18
Description
MariaDB [mytest]> insert t2 values ('2018-05-18 08:55:12.000123', '08:55:12.000123');
Query OK, 1 row affected (0.15 sec)
MariaDB [mytest]> select * from t2;
-------------------------------------------+
| c1 | c2 |
-------------------------------------------+
| 2018-05-18 08:55:12.123000 | 08:55:12.123000 |
-------------------------------------------+
1 row in set (0.05 sec)
MariaDB [mytest]> insert t2 values ('2018-05-18 08:55:12.123000', '08:55:12.123000');
Query OK, 1 row affected (0.07 sec)
MariaDB [mytest]> select * from t2;
-------------------------------------------+
| c1 | c2 |
-------------------------------------------+
| 2018-05-18 08:55:12.123000 | 08:55:12.123000 |
| 2018-05-18 08:55:12.123000 | 08:55:12.123000 |
-------------------------------------------+
Microsecond for the first insert should be 000123. All functions with microsecond support are affected.