TIME datatype is not supported
(MCOL-392)
|
|
| Status: | Closed |
| Project: | MariaDB ColumnStore |
| Component/s: | DMLProc |
| Affects Version/s: | None |
| Fix Version/s: | 1.2.0 |
| Type: | Sub-Task | Priority: | Critical |
| Reporter: | Daniel Lee (Inactive) | Assignee: | Daniel Lee (Inactive) |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Sprint: | 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'); MariaDB [mytest]> select * from t2;
---------------------------
--------------------------- MariaDB [mytest]> insert t2 values ('2018-05-18 08:55:12.123000', '08:55:12.123000'); MariaDB [mytest]> select * from t2;
---------------------------
--------------------------- Microsecond for the first insert should be 000123. All functions with microsecond support are affected. |
| Comments |
| Comment by Andrew Hutchings (Inactive) [ 2018-06-04 ] |
|
Microseconds are being stored correctly, but when being converted back for retrieval we are padding right instead of left. |
| Comment by Andrew Hutchings (Inactive) [ 2018-06-04 ] |
|
Fix pending, batching with other |
| Comment by Andrew Hutchings (Inactive) [ 2018-06-07 ] |
|
Pull request in engine and regression suite to cover this. |
| Comment by Daniel Lee (Inactive) [ 2018-06-18 ] |
|
Build verified: 1.1.2-1 source /root/columnstore/mariadb-columnstore-server Merge pull request #119 from mariadb-corporation/1.1-merge-up-20180531 Merge develop-1.1 into develop /root/columnstore/mariadb-columnstore-server/mariadb-columnstore-engine Merge pull request #494 from mariadb-corporation/ |
[MCOL-1427]