diff options
author | Marko Mäkelä <marko.makela@mariadb.com> | 2022-05-23 08:28:10 +0300 |
---|---|---|
committer | Marko Mäkelä <marko.makela@mariadb.com> | 2022-05-23 08:28:10 +0300 |
commit | e86c1e671a80fd3b410f8e6ebb18cdbad4f1b999 (patch) | |
tree | 4d90ffef464bf2daa1e28478ab0083213667ddd0 /mysql-test/main/partition_exchange.test | |
parent | 20d192bcfc96b141f525d588ff80e408077ec7ab (diff) | |
parent | a0f0687f6ce64b282d0712ca1d769fc1bc55c140 (diff) | |
download | mariadb-git-e86c1e671a80fd3b410f8e6ebb18cdbad4f1b999.tar.gz |
Merge 10.5 into 10.6
Diffstat (limited to 'mysql-test/main/partition_exchange.test')
-rw-r--r-- | mysql-test/main/partition_exchange.test | 19 |
1 files changed, 19 insertions, 0 deletions
diff --git a/mysql-test/main/partition_exchange.test b/mysql-test/main/partition_exchange.test index e996866b1f9..09629a52add 100644 --- a/mysql-test/main/partition_exchange.test +++ b/mysql-test/main/partition_exchange.test @@ -537,4 +537,23 @@ ALTER TABLE t2 REMOVE PARTITIONING; ALTER TABLE t1 EXCHANGE PARTITION pm WITH TABLE t2; DROP TABLE t1, t2; +--echo # +--echo # MDEV-14642 Assertion `table->s->db_create_options == part_table->s->db_create_options' failed in compare_table_with_partition +--echo # +CREATE TABLE t1 (a INT) ROW_FORMAT=DYNAMIC PARTITION BY KEY(a) PARTITIONS 2; +CREATE TABLE t2 (a INT) ; +--error ER_TABLES_DIFFERENT_METADATA +ALTER TABLE t1 EXCHANGE PARTITION p1 WITH TABLE t2; + +# Cleanup +DROP TABLE t1, t2; + +CREATE TABLE t1 (a INT, PRIMARY KEY(a)) ENGINE=InnoDB PARTITION BY KEY(a) PARTITIONS 2; +CREATE TABLE t2 (a INT, PRIMARY KEY(a)) CHECKSUM=1, ENGINE=InnoDB; +--error ER_TABLES_DIFFERENT_METADATA +ALTER TABLE t1 EXCHANGE PARTITION p0 WITH TABLE t2; + +# Cleanup +DROP TABLE t1, t2; + --disable_prepare_warnings |