[MDEV-33143] EXCHANGE/CONVERT TO PARTITION on some engines fails with unexpected ER_TABLES_DIFFERENT_METADATA error Created: 2023-12-30  Updated: 2023-12-31

Status: Open
Project: MariaDB Server
Component/s: Partitioning
Affects Version/s: 10.4, 10.5, 10.6, 10.11, 11.0, 11.1, 11.2, 11.3
Fix Version/s: 10.4, 10.5, 10.6, 10.11, 11.0, 11.1, 11.2, 11.3

Type: Bug Priority: Minor
Reporter: Elena Stepanova Assignee: Alexey Botchkov
Resolution: Unresolved Votes: 0
Labels: 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.
Generated at Thu Feb 08 10:36:42 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.