summaryrefslogtreecommitdiff
path: root/mysql-test/main/partition_exchange.test
diff options
context:
space:
mode:
authorMarko Mäkelä <marko.makela@mariadb.com>2022-05-23 08:28:10 +0300
committerMarko Mäkelä <marko.makela@mariadb.com>2022-05-23 08:28:10 +0300
commite86c1e671a80fd3b410f8e6ebb18cdbad4f1b999 (patch)
tree4d90ffef464bf2daa1e28478ab0083213667ddd0 /mysql-test/main/partition_exchange.test
parent20d192bcfc96b141f525d588ff80e408077ec7ab (diff)
parenta0f0687f6ce64b282d0712ca1d769fc1bc55c140 (diff)
downloadmariadb-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.test19
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