Details
-
Bug
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
10.4(EOL), 10.5, 10.6, 10.11, 11.0(EOL), 11.1(EOL), 11.2(EOL), 11.3(EOL)
-
None
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.