summaryrefslogtreecommitdiff
path: root/mysql-test/main/partition_exchange.test
diff options
context:
space:
mode:
authorAlexey Botchkov <holyfoot@askmonty.org>2018-04-17 16:10:47 +0400
committerAlexey Botchkov <holyfoot@askmonty.org>2018-04-17 16:10:47 +0400
commitbb5f4967f54d3f458bec86fb1845405a0a88bc0f (patch)
treeaba2926bc76561b0dfaa0a95da0fddea1fecf6dc /mysql-test/main/partition_exchange.test
parent02e897ca57168059c6a74d1129158afea93aa875 (diff)
downloadmariadb-git-bb5f4967f54d3f458bec86fb1845405a0a88bc0f.tar.gz
MDEV-13584 Assertion `!part_elem->tablespace_name && !table_create_info->tablespace' failed during EXCHANGE PARTITION with different TABLESPACE.
Wrong DBUG_ASSERT just removed.
Diffstat (limited to 'mysql-test/main/partition_exchange.test')
-rw-r--r--mysql-test/main/partition_exchange.test13
1 files changed, 13 insertions, 0 deletions
diff --git a/mysql-test/main/partition_exchange.test b/mysql-test/main/partition_exchange.test
index 8dc40da0caa..cb33b8dd857 100644
--- a/mysql-test/main/partition_exchange.test
+++ b/mysql-test/main/partition_exchange.test
@@ -523,3 +523,16 @@ UNLOCK TABLES;
dec $count;
}
DROP TABLE t, t2, tp;
+
+--echo #
+--echo # Assertion `!part_elem->tablespace_name && !table_create_info->tablespace'
+--echo # failed during EXCHANGE PARTITION with different TABLESPACE.
+--echo #
+CREATE TABLE t1 (a VARCHAR(200)) PARTITION BY KEY(a) partitions 10;
+ALTER TABLE t1 ADD PARTITION (PARTITION pm TABLESPACE = `innodb_file_per_table`);
+CREATE TABLE t2 like t1;
+ALTER TABLE t2 REMOVE PARTITIONING;
+--error ER_PARTITION_EXCHANGE_DIFFERENT_OPTION
+ALTER TABLE t1 EXCHANGE PARTITION pm WITH TABLE t2;
+DROP TABLE t1, t2;
+