diff options
| author | mikael@c-4908e253.1238-1-64736c10.cust.bredbandsbolaget.se <> | 2006-04-11 23:35:48 -0400 |
|---|---|---|
| committer | mikael@c-4908e253.1238-1-64736c10.cust.bredbandsbolaget.se <> | 2006-04-11 23:35:48 -0400 |
| commit | fa5e50943d782f27d85ca3aad8a6c841b14e78ff (patch) | |
| tree | e2977465c20bb63fea893843ace9f465aa6aaa45 /mysql-test/t/partition_range.test | |
| parent | ba5d08f340b951001bdd4c2a92b0344bace538cb (diff) | |
| download | mariadb-git-fa5e50943d782f27d85ca3aad8a6c841b14e78ff.tar.gz | |
BUG#18962: DROP PARTITION fails when partitions dropped for subpartitions with default naming procedure
Fixed naming procedures for default partitioning and default subpartitioning
Diffstat (limited to 'mysql-test/t/partition_range.test')
| -rw-r--r-- | mysql-test/t/partition_range.test | 28 |
1 files changed, 28 insertions, 0 deletions
diff --git a/mysql-test/t/partition_range.test b/mysql-test/t/partition_range.test index a4d8c3740b7..ef539e2001f 100644 --- a/mysql-test/t/partition_range.test +++ b/mysql-test/t/partition_range.test @@ -388,3 +388,31 @@ SELECT COUNT(*) FROM t1 WHERE c3 BETWEEN '1996-12-31' AND '2000-12-31'; SELECT COUNT(*) FROM t1 WHERE c3 < '2000-12-31'; DROP TABLE t1; +# +# BUG 18962 Errors in DROP PARTITION +# +create table t1 (a int) +partition by range (MOD(a,3)) +subpartition by hash(a) +subpartitions 2 +(partition p0 values less than (1), + partition p1 values less than (2), + partition p2 values less than (3), + partition p3 values less than (4)); +ALTER TABLE t1 DROP PARTITION p3; +ALTER TABLE t1 DROP PARTITION p1; +ALTER TABLE t1 DROP PARTITION p2; +drop table t1; + +create table t1 (a int) +partition by range (MOD(a,3)) +subpartition by hash(a) +subpartitions 2 +(partition p0 values less than (1), + partition p1 values less than (2), + partition p2 values less than (3), + partition p3 values less than (4)); +ALTER TABLE t1 DROP PARTITION p0; +ALTER TABLE t1 DROP PARTITION p1; +ALTER TABLE t1 DROP PARTITION p2; +drop table t1; |