diff options
| author | unknown <reggie@linux.site> | 2006-01-23 09:44:13 -0600 |
|---|---|---|
| committer | unknown <reggie@linux.site> | 2006-01-23 09:44:13 -0600 |
| commit | 0e8d8eb7af6f061c2e6458a7135f14b2af5d21f6 (patch) | |
| tree | 31f96f080d0df55b5da879676cf87ba7190ab33f /mysql-test/t/partition_mgm_err.test | |
| parent | 004d728acc5ea356223323723581b02ac95972c6 (diff) | |
| download | mariadb-git-0e8d8eb7af6f061c2e6458a7135f14b2af5d21f6.tar.gz | |
BUG# 16534: just a change to the test suite showing that it's fixed.
This bug was fixed as part of the large WL 2604 push.
mysql-test/r/partition_mgm_err.result:
results block for bug #16534
mysql-test/t/partition_mgm_err.test:
test block for bug# 16534
Diffstat (limited to 'mysql-test/t/partition_mgm_err.test')
| -rw-r--r-- | mysql-test/t/partition_mgm_err.test | 17 |
1 files changed, 17 insertions, 0 deletions
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; |