[MCOL-1659] Unable to have spaces in column names in ddl Created: 2018-08-16  Updated: 2019-03-07  Resolved: 2018-12-19

Status: Closed
Project: MariaDB ColumnStore
Component/s: None
Affects Version/s: 1.1.3-2, 1.1.5
Fix Version/s: 1.1.7

Type: Bug Priority: Critical
Reporter: Roger Eisentrager (Inactive) Assignee: Daniel Lee (Inactive)
Resolution: Fixed Votes: 0
Labels: None
Environment:

all

Attachments: Text File columnstore1.txt    
Issue Links:
Relates
relates to MCOL-2219 create table failed with space + non ... Closed
Sprint: 2018-16, 2018-17, 2018-18, 2018-19, 2018-20, 2018-21
Epic/Theme: server

 Description   

MariaDB [innotest1]> CREATE TABLE t10 (`c300_500_18 REF NOx` varchar(20)) ENGINE = innodb;
Query OK, 0 rows affected (0.01 sec)
MariaDB [innotest1]> drop table t10;
Query OK, 0 rows affected (0.00 sec)
MariaDB [innotest1]> CREATE TABLE t10 (`c300_500_18 REF NOx` varchar(20)) 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.

 Comments   
Comment by Roger Eisentrager (Inactive) [ 2018-08-16 ]

I will be testing if this is same issue for table names too.

Comment by Roman [ 2018-08-17 ]

Please review the change.

Comment by Roman [ 2018-08-18 ]

Squashed the commits in this PR.

Comment by Daniel Lee (Inactive) [ 2018-12-19 ]

Build verified: 1.1.7-1

Verified spaces in both table and column names.

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