[MCOL-1006] "Action" (and maybe other reserved words) cannot be used as column names Created: 2017-11-02  Updated: 2017-11-09  Resolved: 2017-11-09

Status: Closed
Project: MariaDB ColumnStore
Component/s: DDLProc
Affects Version/s: 1.0.11
Fix Version/s: Icebox

Type: Bug Priority: Trivial
Reporter: Joffrey MICHAIE Assignee: Andrew Hutchings (Inactive)
Resolution: Duplicate Votes: 0
Labels: None
Environment:

Debian Jessie 8.x 64bits


Issue Links:
Duplicate
duplicates MCOL-573 CS does not support reserved words as... Closed

 Description   

Hello,

I am trying to create a simple table, where one column name is "action".
Columnstore doesn't allow me to create it, with or without back quotes.

MariaDB [test]> create table t1 (`action` int) engine=innodb;
Query OK, 0 rows affected (0.02 sec)
 
MariaDB [test]> create table t2 (`action` int) engine=columnstore;
ERROR 1178 (42000): The storage engine for the table doesn't support The syntax or the data type(s) is not supported by Columnstore. Please check the Columnstore syntax guide for supported syntax or data types.
MariaDB [test]> create table t2 (`othername` int) engine=columnstore;
Query OK, 0 rows affected (0.14 sec)

Is this a known limitation ?
Thanks for checking!
Joffrey



 Comments   
Comment by David Thompson (Inactive) [ 2017-11-06 ]

Yes, this appears to be a bug / limitation in our parser extensions.

Comment by Andrew Hutchings (Inactive) [ 2017-11-09 ]

Closed as duplicate of MCOL-573

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