[MCOL-2219] create table failed with space + non "A-Z a-z 0-9 _" in column/table name Created: 2019-03-07  Updated: 2020-08-25  Resolved: 2019-10-18

Status: Closed
Project: MariaDB ColumnStore
Component/s: DDLProc
Affects Version/s: 1.2.3, 1.2.2
Fix Version/s: 1.2.6

Type: Bug Priority: Major
Reporter: Richard Stracke Assignee: Bharath Bokka (Inactive)
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Relates
relates to MCOL-1658 support space names in columnstore ta... Closed
relates to MCOL-1659 Unable to have spaces in column names... Closed
Sprint: 2019-06

 Description   

If paraenthesis and space are in the column name,
the table creation failed.

Error message:

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.

If work with parenthesis alone, also with space alone but not with both.

so

create table t1 ( `t)` int) engine=columnstore;

and

 create table t2 ( `t space` int) engine=columnstore;

works,

but not 

 create table t3 ( `t (space` int) engine=columnstore;



 Comments   
Comment by Richard Stracke [ 2019-03-07 ]

It seems the rule is space + a char which is not "A-Z a-z 0-9 _"

Comment by Andrew Hutchings (Inactive) [ 2019-08-01 ]

PR in engine and regression suite

Comment by Bharath Bokka (Inactive) [ 2019-10-18 ]

Verified on,
Build: 1.2.6-1

create table with space + non "A-Z a-z 0-9 _" in column/table works fine.

Ex:
MariaDB [test]> create table t5(`col $` int, `col %` varchar(10), `col ^` char(6), `col &` text(45), `col *` decimal(6,2));
Query OK, 0 rows affected (0.014 sec)

MariaDB [test]> create table t6(`col (` bigint, `col )` float(6,2), `col -` boolean, `col +` numeric(5));
Query OK, 0 rows affected (0.015 sec)

MariaDB [test]> create table t8(`col =` timestamp, `col ?` real(6,2), `col >` blob, `col <` time, `col ' " : ; ] [ }

{ \ |` longtext); Query OK, 0 rows affected (0.018 sec) MariaDB [test]> create table `t ;$pace`(`col }

` mediumint);
Query OK, 0 rows affected (0.006 sec)

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