Details
-
Sub-Task
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
None
-
None
-
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.