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

DROP multiple tables throws error

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Won't Fix
    • None
    • Icebox
    • DDLProc
    • None
    • Server version: 10.5.4-MariaDB MariaDB Server
      Columnstore: 1.5.2-1

    Description

      Drop multiple tables fails when one of the tables is a columnstore table.

      MariaDB [test]> CREATE TABLE t_innodb (id INT) ENGINE=Innodb;
      Query OK, 0 rows affected (0.013 sec)

      MariaDB [test]> CREATE TABLE t_mcs1 (id INT) ENGINE=Columnstore;
      Query OK, 0 rows affected (0.226 sec)

      MariaDB [test]> CREATE TABLE t_mcs2 (id INT) ENGINE=Columnstore;
      Query OK, 0 rows affected (0.229 sec)

      MariaDB [test]> DROP TABLE t_mcs1, t_mcs2;
      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.

      MariaDB [test]> DROP TABLE t_mcs1, t_innodb;
      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

        Activity

          People

            Unassigned Unassigned
            susil.behera susil.behera
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

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