TIME_FORMAT return NULL when trying to return time from a date column

Build tested: 1.1.4-1

Reference:

1 --------------
2 select cidx, CDATE, TIME_FORMAT(CDATE,'%h %i %s') from datatypetestm order by cidx
3 --------------
4
5 cidx CDATE TIME_FORMAT(CDATE,'%h %i %s')
6 1 1997-01-01 12 00 00
7 1 row in set
8
9 --------------
10 select cidx, CDATE, TIME_FORMAT(CDATE,'%H:%i:%s %f') from datatypetestm order by cidx
11 --------------
12
13 cidx CDATE TIME_FORMAT(CDATE,'%H:%i:%s %f')
14 1 1997-01-01 00:00:00 000000
15 1 row in set
16
17 --------------
18 select cidx, CDATE, TIME_FORMAT(CDATE,'%k:%i:%S') from datatypetestm order by cidx
19 --------------
20
21 cidx CDATE TIME_FORMAT(CDATE,'%k:%i:%S')
22 1 1997-01-01 0:00:00
23 1 row in set

ColumnStore:

1 --------------
2 select cidx, CDATE, TIME_FORMAT(CDATE,'%h %i %s') from datatypetestm order by cidx
3 --------------
4
5 cidx CDATE TIME_FORMAT(CDATE,'%h %i %s')
6 1 1997-01-01 NULL
7 1 row in set
8
9 --------------
10 select cidx, CDATE, TIME_FORMAT(CDATE,'%H:%i:%s %f') from datatypetestm order by cidx
11 --------------
12
13 cidx CDATE TIME_FORMAT(CDATE,'%H:%i:%s %f')
14 1 1997-01-01 NULL
15 1 row in set
16
17 --------------
18 select cidx, CDATE, TIME_FORMAT(CDATE,'%k:%i:%S') from datatypetestm order by cidx
19 --------------
20
21 cidx CDATE TIME_FORMAT(CDATE,'%k:%i:%S')
22 1 1997-01-01 NULL
23 1 row in set