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

    • Bug
    • Status: Open (View Workflow)
    • Minor
    • Resolution: Unresolved
    • 5.5.1
    • Icebox
    • DDLProc
    • 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

              Unassigned Unassigned
              alexey.antipovsky Alexey Antipovsky (Inactive)
              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.