Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-33143

EXCHANGE/CONVERT TO PARTITION on some engines fails with unexpected ER_TABLES_DIFFERENT_METADATA error

    XMLWordPrintable

Details

    Description

      --source include/have_partition.inc
       
      install soname 'ha_archive';
       
      create table t1 (a int) engine=Archive partition by list(a) (partition p0 values in (1,2));
      create table t2 (a int) engine=Archive;
      alter table t1 exchange partition p0 with table t2;
       
      # Cleanup
      drop table if exists t1, t2;
      uninstall soname 'ha_archive';
      

      10.4 87a5d16911bb94d383480fdd49e20876ed1400f2

      query 'alter table t1 exchange partition p0 with table t2' failed: ER_TABLES_DIFFERENT_METADATA (1736): Tables have different definitions
      

      Maybe there is a reason for a limitation on Archive tables, but the tables have identical definitions, so at least the produced error is wrong.

      Same happens for CONVERT TABLE .. TO PARTITION on versions where it is applicable.

      Same happens for Blackhole, RocksDB, Connect tables.

      Attachments

        Activity

          People

            holyfoot Alexey Botchkov
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.