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

Missing backticks for reserved table name during DROP DATABASE

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Confirmed (View Workflow)
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: 1.2.5
    • Fix Version/s: Icebox
    • Component/s: DDLProc
    • Labels:
      None
    • Environment:
      mariadb-community-columnstore-docker
      Server version: 10.3.16-MariaDB-log Columnstore 1.2.5-1
    • Sprint:
      2020-4, 2020-5, 2020-6, 2020-7

      Description

      ColumnStore has additional reserved words that cannot be used as table names without backticks, like USER. For example:

      CREATE DATABASE test;
      USE test;
      CREATE TABLE user ( id 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.
      

      Most of those reserved keywords can be used as table names when wrapped in the backticks:

      MariaDB [test]> CREATE TABLE `user` ( id int ) ENGINE=ColumnStore;
      Query OK, 0 rows affected (0.209 sec)
      

      However, such tables are not dropped during DROP DATABASE:

      MariaDB [test]> DROP DATABASE test;
      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.
      

      To circumvent this issue, one could drop such tables one by one wrapped in the backticks like:

      MariaDB [test]> drop table `user`;
      Query OK, 0 rows affected (0.199 sec)
      MariaDB [test]> drop database test;
      Query OK, 0 rows affected (0.002 sec)
      

        Attachments

          Activity

            People

            Assignee:
            drrtuy Roman
            Reporter:
            sasha Sasha V
            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.