TIME datatype is not supported (MCOL-392)

[MCOL-1428] SUBTIME() as a WHERE condition on TIME data type caused primProc to hang Created: 2018-05-18  Updated: 2018-06-18  Resolved: 2018-06-18

Status: Closed
Project: MariaDB ColumnStore
Component/s: ExeMgr
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]> create table t1 (c1 time) engine=columnstore;
Query OK, 0 rows affected (2.52 sec)

MariaDB [mytest]> insert into t1 values ('13:00:00');
Query OK, 1 row affected (0.36 sec)

MariaDB [mytest]>
MariaDB [mytest]>
MariaDB [mytest]> insert into t1 values ('13:00:00');
Query OK, 1 row affected (0.04 sec)

MariaDB [mytest]> select * from t1;
----------

c1

----------

13:00:00
13:00:00

----------
2 rows in set (0.11 sec)

MariaDB [mytest]> drop table t1;
Query OK, 0 rows affected (0.18 sec)

MariaDB [mytest]> create table t1 (c1 time) engine=columnstore;
Query OK, 0 rows affected (0.21 sec)

MariaDB [mytest]> insert into t1 values ('13:00:00');
Query OK, 1 row affected (0.10 sec)

MariaDB [mytest]> select * from t1;
----------

c1

----------

13:00:00

----------
1 row in set (0.03 sec)

MariaDB [mytest]> select cidx, CTIME,SUBTIME(CTIME,'1 01:24:59') from datatypetestm where ADDTIME(CTIME,'1 01:24:59') =0;
Empty set (0.06 sec)

MariaDB [mytest]> select cidx, CTIME,SUBTIME(CTIME,'1 01:24:59') from datatypetestm where SUBTIME(CTIME,'1 01:24:59') =0;

It hung here

The same query with "<0" or ">0" also hung.

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

Confirmed only when SUBTIME is a WHERE condition

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

Fix pending in a bunch of fixes for MCOL-392

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:41 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.