The following test fails with error "ERROR HY000: Tables have different definitions":
--source include/have_partition.inc
|
--source include/have_archive.inc
|
|
CREATE TABLE t1(a INT NOT NULL AUTO_INCREMENT PRIMARY KEY) ENGINE=ARCHIVE PARTITION BY HASH (a) PARTITIONS 4;
|
CREATE TABLE t2 LIKE t1;
|
ALTER TABLE t2 REMOVE PARTITIONING;
|
ALTER TABLE t1 EXCHANGE PARTITION p1 WITH TABLE t2;
|
DROP TABLE t1,t2;
|
While performing exchange partition we call mysql_compare_tables()/ha_archive::check_if_incompatible_data(). In MariaDB this function always return COMPATIBLE_DATA_NO.
Covered by the following tests: parts.partition_mgm_lc1_archive parts.partition_exchange_archive parts.partition_mgm_lc0_archive rpl.rpl_partition_archive. Enable them when this bug is fixed.