Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Cannot Reproduce
-
1.2.0
-
None
Description
DATE_FORMAT doesn't behave the same as MariaDB for converting a time to a date. We would need to refactor the code for the function to make it behave the same.
DATE_FORMAT()
|
|
|
Reference:
|
|
|
MariaDB [mytest]> select cidx, CTIME, DATE_FORMAT(CTIME,'%W %M %Y') from datatypetestm order by cidx; |
-------------------------------------------
|
|
|
cidx CTIME DATE_FORMAT(CTIME,'%W %M %Y') |
-------------------------------------------
|
|
|
1 13:00:00 NULL |
-------------------------------------------
|
1 row in set (0.000 sec) |
|
|
MariaDB [mytest]> select cidx, CTIME, DATE_FORMAT(CTIME,'%D %y %a %d %m %b %j') from datatypetestm order by cidx; |
-------------------------------------------------------
|
|
|
cidx CTIME DATE_FORMAT(CTIME,'%D %y %a %d %m %b %j') |
-------------------------------------------------------
|
|
|
1 13:00:00 NULL |
-------------------------------------------------------
|
1 row in set (0.000 sec) |
|
|
ColumnStore:
|
|
|
MariaDB [mytest]> select cidx, CTIME, DATE_FORMAT(CTIME,'%W %M %Y') from datatypetestm order by cidx; |
-------------------------------------------
|
|
|
cidx CTIME DATE_FORMAT(CTIME,'%W %M %Y') |
-------------------------------------------
|
|
|
1 13:00:00 Monday October 2018
|
-------------------------------------------
|
1 row in set (0.031 sec) |
|
|
MariaDB [mytest]> select cidx, CTIME, DATE_FORMAT(CTIME,'%D %y %a %d %m %b %j') from datatypetestm order by cidx; |
-------------------------------------------------------
|
|
|
cidx CTIME DATE_FORMAT(CTIME,'%D %y %a %d %m %b %j') |
-------------------------------------------------------
|
|
|
1 13:00:00 1st 18 Mon 01 10 Oct 274
|
-------------------------------------------------------
|
1 row in set (0.007 sec) |
Attachments
Issue Links
- relates to
-
MCOL-1433 Some functions return non-matching results after data type TIME was added to the functions test suite
-
- Closed
-