diff options
-rw-r--r-- | mysql-test/r/partition_mgm_err.result | 13 | ||||
-rw-r--r-- | mysql-test/t/partition_mgm_err.test | 17 |
2 files changed, 30 insertions, 0 deletions
diff --git a/mysql-test/r/partition_mgm_err.result b/mysql-test/r/partition_mgm_err.result index 3c2c50fc6f8..e9086ddcc20 100644 --- a/mysql-test/r/partition_mgm_err.result +++ b/mysql-test/r/partition_mgm_err.result @@ -112,3 +112,16 @@ ALTER TABLE t1 DROP PARTITION x1; ALTER TABLE t1 DROP PARTITION x0; ERROR HY000: Cannot remove all partitions, use DROP TABLE instead DROP TABLE t1; +CREATE TABLE t1 ( id INT NOT NULL, +fname VARCHAR(50) NOT NULL, +lname VARCHAR(50) NOT NULL, +hired DATE NOT NULL ) +PARTITION BY RANGE(YEAR(hired)) ( +PARTITION p1 VALUES LESS THAN (1991), +PARTITION p2 VALUES LESS THAN (1996), +PARTITION p3 VALUES LESS THAN (2001), +PARTITION p4 VALUES LESS THAN (2005)); +ALTER TABLE t1 ADD PARTITION ( +PARTITION p5 VALUES LESS THAN (2010), +PARTITION p6 VALUES LESS THAN MAXVALUE); +DROP TABLE t1; diff --git a/mysql-test/t/partition_mgm_err.test b/mysql-test/t/partition_mgm_err.test index c12f1c05c05..f0f29bbc2d6 100644 --- a/mysql-test/t/partition_mgm_err.test +++ b/mysql-test/t/partition_mgm_err.test @@ -167,3 +167,20 @@ ALTER TABLE t1 DROP PARTITION x1; ALTER TABLE t1 DROP PARTITION x0; DROP TABLE t1; + +# +# Bug# 16534 - Trying to add multiple partitions crashes server +# +CREATE TABLE t1 ( id INT NOT NULL, + fname VARCHAR(50) NOT NULL, + lname VARCHAR(50) NOT NULL, + hired DATE NOT NULL ) +PARTITION BY RANGE(YEAR(hired)) ( + PARTITION p1 VALUES LESS THAN (1991), + PARTITION p2 VALUES LESS THAN (1996), + PARTITION p3 VALUES LESS THAN (2001), + PARTITION p4 VALUES LESS THAN (2005)); +ALTER TABLE t1 ADD PARTITION ( + PARTITION p5 VALUES LESS THAN (2010), + PARTITION p6 VALUES LESS THAN MAXVALUE); +DROP TABLE t1; |