[MCOL-1327] CS objects' identifiers doesn't support U+0000..U+007f even when quoted Created: 2018-04-05  Updated: 2018-05-30  Resolved: 2018-05-30

Status: Closed
Project: MariaDB ColumnStore
Component/s: DDLProc, DMLProc
Affects Version/s: 1.0.13, 1.1.3
Fix Version/s: 1.2.0

Type: Bug Priority: Minor
Reporter: Roman Assignee: Daniel Lee (Inactive)
Resolution: Fixed Votes: 0
Labels: None

Sprint: 2018-09, 2018-10, 2018-11

 Description   

The CS doesn't support full Unicode Basic Multilingual Plane (BMP) U+0001 .. U+007F as InnoDB does.

MariaDB [cs]> create table `bb1#` (i int)engine=columnstore ;
ERROR 1178 (42000): The storage engine for the table doesn't support IDB-1008: The syntax or the data type(s) is not supported by Columnstore. Please check the Columnstore syntax guide for supported syntax or data types.

But

MariaDB [cs]> create table `bb1#` (i int) ;
Query OK, 0 rows affected (0.06 sec)

 Comments   
Comment by Roman [ 2018-04-13 ]

Please take a look at the PRs for both cs and regression test suite fixes.

Comment by Andrew Hutchings (Inactive) [ 2018-04-14 ]

drrtuy I've merged the Engine PR, that looks good. But it appears you closed the regression suite one?

Comment by Roman [ 2018-04-14 ]

I made the PR mentioned late at night and realized there I pick 3 additional commits , so I decided to recreate PR later. Here it is.

Comment by Daniel Lee (Inactive) [ 2018-05-30 ]

Build verified: 1.2.0-1 source

reproduced issue in 1.1.3-1

MariaDB [mytest]> create table `bb1#` (i int)engine=columnstore ;
ERROR 1178 (42000): The storage engine for the table doesn't support IDB-1008: The syntax or the data type(s) is not supported by Columnstore. Please check the Columnstore syntax guide for supported syntax or data types.

Verified fix in 1.2.0-1. Also testing DDL and DML commands, as well as cpimport.

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