summaryrefslogtreecommitdiff
path: root/mysql-test/t/partition_mgm_err.test
diff options
context:
space:
mode:
authorunknown <rburnett@production.mysql.com>2006-01-27 16:41:53 +0100
committerunknown <rburnett@production.mysql.com>2006-01-27 16:41:53 +0100
commit7f8edcb5c2e3f5cec29b9fd00a4ff61f60f5f0f3 (patch)
tree006a773bd34893d7d6258d8b5925dbef5cfc0c26 /mysql-test/t/partition_mgm_err.test
parent5c974cf18467af6aec600c74deb7625369b1c916 (diff)
downloadmariadb-git-7f8edcb5c2e3f5cec29b9fd00a4ff61f60f5f0f3.tar.gz
BUG#15820 - Can create table with 1 partition, then doing ALTER .. ADD PARTITION crashes
It is ok for a partitioned table to have only 1 partition. This test is just to show that doing the ALTER TABLE ADD PARTITION doesn't crash the server. partition_mgm_err.result: Added result block for test of bug #15820 partition_mgm_err.test: Added test block for bug #15820 mysql-test/t/partition_mgm_err.test: Added test block for bug #15820 mysql-test/r/partition_mgm_err.result: Added result block for test of bug #15820
Diffstat (limited to 'mysql-test/t/partition_mgm_err.test')
-rw-r--r--mysql-test/t/partition_mgm_err.test6
1 files changed, 6 insertions, 0 deletions
diff --git a/mysql-test/t/partition_mgm_err.test b/mysql-test/t/partition_mgm_err.test
index 793968c87f3..1a24129bcf1 100644
--- a/mysql-test/t/partition_mgm_err.test
+++ b/mysql-test/t/partition_mgm_err.test
@@ -210,3 +210,9 @@ SHOW CREATE TABLE t1;
ALTER TABLE t1 PARTITION BY KEY(a) PARTITIONS 2;
SHOW CREATE TABLE t1;
DROP TABLE t1;
+
+#
+#BUG 15820 create table with 1 partition, doing ALTER TABLE ADD PARTITION fails
+#
+CREATE TABLE t1 (a INT) PARTITION BY HASH(a);
+ALTER TABLE t1 ADD PARTITION PARTITIONS 4;