Details
-
Bug
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
5.5.1
-
None
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. |
Attachments
Issue Links
- relates to
-
MCOL-3785 CTAS (Create Table as Select) with COUNT() ... FROM ... GROUP BY ... throws syntax error
- Closed