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

DROP multiple tables throws error

    XMLWordPrintable

    Details

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

            Assignee:
            Unassigned Unassigned
            Reporter:
            susil.behera susil.behera
            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.