[MCOL-4504] DDL parser does not allow escaped qoutes in the table/column names Created: 2021-01-18  Updated: 2021-01-20

Status: Open
Project: MariaDB ColumnStore
Component/s: DDLProc
Affects Version/s: 5.5.1
Fix Version/s: Icebox

Type: Bug Priority: Minor
Reporter: Alexey Antipovsky (Inactive) Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: None

Issue Links:
Relates
relates to MCOL-3785 CTAS (Create Table as Select) with CO... Closed

 Description   

Current DDL parser doesn't allow properly escaped quotes in the table/column names, i.e.:

CREATE TABLE `someone``s table` (`name with ``backticks``` int) engine=InnoDB;
-- Query OK, 0 rows affected (0.020 sec)
CREATE TABLE `someone``s table_cs` (`name with ``backticks``` 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.
 
SET SQL_MODE=ANSI_QUOTES;
 
CREATE TABLE "o""clock table" ("o""clock" int) engine=InnoDB;
-- Query OK, 0 rows affected (0.019 sec)
 
CREATE TABLE "o""clock table_cs" ("o""clock" 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.
 
CREATE TABLE "o`clock table" ("o`clock" int) engine=InnoDB;
-- Query OK, 0 rows affected (0.019 sec)
CREATE TABLE "o`clock table_cs" ("o`clock" 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.


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