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

Cross db table rename fails

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Fixed
    • 5.6.2
    • 23.10.1
    • DDLProc
    • None
    • Server version: 10.5.4-MariaDB MariaDB Server
      Columnstore: 1.5.2-1
    • 2023-11

    Description

      Cross database table rename fails for columnstore tables.

      CREATE TABLE db1.t1 (id INT) ENGINE=Columnstore;
      RENAME TABLE db1.t1 TO db2.t1;
      ERROR 1815 (HY000): Internal error: CAL0001: Alter table Failed: The new tablename is already in use.

      ALTER TABLE db1.t1 RENAME TO db2.t1;
      ERROR 1815 (HY000): Internal error: CAL0001: Alter table Failed: The new tablename is already in use.

      Attachments

        Activity

          People

            leonid.fedorov Leonid Fedorov
            susil.behera susil.behera
            Roman Roman
            Kirill Perov Kirill Perov
            Votes:
            1 Vote for this issue
            Watchers:
            5 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.