[MCOL-1454] TIME as a reserved word breaks /working_tpch1_compareLogOnly/misc/bug2990.sql Created: 2018-06-06  Updated: 2019-03-01  Resolved: 2019-03-01

Status: Closed
Project: MariaDB ColumnStore
Component/s: MDB Plugin
Affects Version/s: 1.2
Fix Version/s: 1.2.0

Type: Bug Priority: Major
Reporter: David Hall (Inactive) Assignee: Daniel Lee (Inactive)
Resolution: Fixed Votes: 0
Labels: None

Sprint: 2018-13, 2018-14, 2018-15, 2018-16, 2018-17, 2018-18, 2018-19, 2018-20, 2018-21, 2019-01, 2019-02

 Description   

TIME is now a reserved word and breaks /working_tpch1_compareLogOnly/misc/bug2990.sql. Not sure what to do about it.

 Comments   
Comment by Roman [ 2018-06-21 ]

Andrew reconfirmed the issue.

Comment by Roman [ 2018-06-23 ]

Here is the the small test made using fixed version.

MariaDB [cs]> create table cs27(TIME time) engine=columnstore;
 
Query OK, 0 rows affected (0.84 sec)
 
 
 
MariaDB [cs]> insert into cs27 (time) values (time('00:00:00'));
 
Query OK, 1 row affected (0.28 sec)
 
 
 
MariaDB [cs]> select time from cs27;
 
+----------+
 
| time     |
 
+----------+
 
| 00:00:00 |
 
+----------+
 
1 row in set (0.02 sec)

Comment by Roman [ 2018-06-23 ]

Please review the fix.

Comment by Daniel Lee (Inactive) [ 2019-03-01 ]

Build verified: 1.2.3-1 nightly

server commit:
61f32f2
engine commit:
e849af0

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