From 7f8edcb5c2e3f5cec29b9fd00a4ff61f60f5f0f3 Mon Sep 17 00:00:00 2001 From: unknown Date: Fri, 27 Jan 2006 16:41:53 +0100 Subject: 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 --- mysql-test/t/partition_mgm_err.test | 6 ++++++ 1 file changed, 6 insertions(+) (limited to 'mysql-test/t/partition_mgm_err.test') 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; -- cgit v1.2.1