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

RENAME TABLE makes the table unusable

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: 1.4.2
    • Fix Version/s: 5.4.1
    • Component/s: None
    • Labels:
      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

            Assignee:
            dleeyh Daniel Lee
            Reporter:
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Git Integration