Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-4504

DDL parser does not allow escaped qoutes in the table/column names

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open (View Workflow)
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: 5.5.1
    • Fix Version/s: Icebox
    • Component/s: DDLProc
    • Labels:
      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

            Activity

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              alexey.antipovsky Alexey Antipovsky
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:

                  Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.