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

DROP multiple columnstore tables throws error

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Cannot Reproduce
    • None
    • Icebox
    • DDLProc
    • None

    Description

      Build tested: 1.4.3-1
      OS: centos 7
      Stack: single server

      At present DROP supports only to drop a single columnstore table. When we try drop multiple tables DROP throws error.

      CREATE TABLE t1 (c int);
      CREATE TABLE t2 (c int);
      DROP TABLE t1, t2;
      CREATE TABLE t1 (c int) engine=columnstore;
      CREATE TABLE t2 (c int) engine=columnstore;
      DROP TABLE t1, t2;
      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.

      DROP should support multiple columnstore tables in a single statement.

      Attachments

        Activity

          People

            Unassigned Unassigned
            susil.behera Susil Behera
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.