TIME datatype is not supported (MCOL-392)

[MCOL-1429] DAYNAME() and MONTHNAME() on TIME data type columns caused primProc to restart Created: 2018-05-18  Updated: 2018-06-18  Resolved: 2018-06-18

Status: Closed
Project: MariaDB ColumnStore
Component/s: PrimProc
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   

The following query causes a primproc restart

select cidx, CTIME, DAYNAME(CTIME) from datatypetestm order by cidx;



 Comments   
Comment by Daniel Lee (Inactive) [ 2018-05-18 ]

MONTHNAME() also has the same issue

select cidx, CTIME, MONTHNAME(CTIME) from datatypetestm order by cidx;

Comment by Andrew Hutchings (Inactive) [ 2018-06-04 ]

Actually an old bug in those two functions triggered by TIME datatype. Array out of bounds problem.

Comment by Andrew Hutchings (Inactive) [ 2018-06-04 ]

Fix pending batched with other MCOL-392 tests

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.2.0-1 source

/root/columnstore/mariadb-columnstore-server
commit 3bfc3ad5f1e91e6f325b89fefaf62a6b38ca889a
Merge: 4334641 742af4d
Author: David.Hall <david.hall@mariadb.com>
Date: Thu May 31 09:40:12 2018 -0500

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
commit 1caa98ff46777a389cdfd4ae369865391a884c27
Merge: 60a4d14 d9e6ba9
Author: David.Hall <david.hall@mariadb.com>
Date: Mon Jun 11 10:20:49 2018 -0500

Merge pull request #494 from mariadb-corporation/MCOL-1433

MCOL-1433 Fix several functions for TIME handling

Generated at Thu Feb 08 02:28:42 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.