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

RENAME TABLE makes the table unusable

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Fixed
    • 1.4.2
    • 5.4.1
    • None
    • None

    Description

      According to documentation, RENAME TABLE is supposed to work for ColumnStore. It doesn't seem to be the case.

      MariaDB f93bfb9288d020b190f5c73a31223fff6439687d

      MariaDB [db]> create table t5 (a int) engine=Columnstore;
      Query OK, 0 rows affected (0.729 sec)
       
      MariaDB [db]> select * from t5;
      Empty set (0.064 sec)
       
      MariaDB [db]> rename table t5 to t5a;
      Query OK, 0 rows affected (0.003 sec)
       
      MariaDB [db]> select * from t5a;
      ERROR 1815 (HY000): Internal error: IDB-2006: 'db.t5a' does not exist in Columnstore.
       
      MariaDB [db]> drop table t5a;
      Query OK, 0 rows affected, 1 warning (0.044 sec)
       
      MariaDB [db]> show warnings;
      +---------+------+--------------------------------------------------------------------------------------------------+
      | Level   | Code | Message                                                                                          |
      +---------+------+--------------------------------------------------------------------------------------------------+
      | Warning | 9999 | Error occured during file deletion. Restart DDLProc or use command tool ddlcleanup to clean up.  |
      +---------+------+--------------------------------------------------------------------------------------------------+
      1 row in set (0.001 sec)
      

      Support report is attached.

      Attachments

        Activity

          People

            dleeyh Daniel Lee (Inactive)
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            4 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.