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

ColumnStore table does not exist after a rename

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Duplicate
    • 6.4.2
    • 23.10.2
    • DDLProc, MDB Plugin
    • None
    • Centos 7
      MariaDB 10.6.8
      ColumnStore 6

    Description

      I had a simple ColumnStore table like shown below with simple 2 rows.
      I ran the ALTER TABLE statement to rename the table and move the table from one database to another database. It ran successfully.
      When I run count or any query on the new db.name it return an error like below.
      I can see the .frm file has moved from dw_db to ds_db. Also, "show tables" list the table in ds_db.

      CREATE TABLE dw_db.orders_test_cs (
      orderkey INTEGER,
      customer VARCHAR(45)
      ) ENGINE=ColumnStore;
      INSERT INTO dw_db.orders_test_cs (orderkey, customer) VALUES
      (12, 'JohnSmith'),
      (13, 'John Public');

      ALTER TABLE dw_db.orders_test_cs RENAME TO ds_db.orders_test_cs2;

      select count from ds.orders_test_cs2;
      ERROR 1815 (HY000): Internal error: MCS-2006: 'ds_db.orders_test_cs2' does not exist in Columnstore.

      Attachments

        Activity

          People

            drrtuy Roman
            mbsoul Majdi Bsoul
            Votes:
            0 Vote for this issue
            Watchers:
            7 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.