From d0d52e9f11ab7bad11d34d207139a26f26dd362c Mon Sep 17 00:00:00 2001 From: Mikael Ronstrom Date: Thu, 10 Sep 2009 11:15:39 +0200 Subject: WL#4444 Added TRUNCATE partition support, fixes bug#19405 and bug #35111 --- mysql-test/t/partition_truncate.test | 26 ++++++++++++++++++++++++++ 1 file changed, 26 insertions(+) create mode 100644 mysql-test/t/partition_truncate.test (limited to 'mysql-test/t/partition_truncate.test') diff --git a/mysql-test/t/partition_truncate.test b/mysql-test/t/partition_truncate.test new file mode 100644 index 00000000000..93b9cf62d14 --- /dev/null +++ b/mysql-test/t/partition_truncate.test @@ -0,0 +1,26 @@ +# +# Simple tests to verify truncate partition syntax +# +--source include/have_partition.inc +--disable_warnings +drop table if exists t1, t2, t3, t4; +--enable_warnings + +create table t1 (a int) +partition by list (a) +(partition p1 values in (0)); +--error ER_WRONG_PARTITION_NAME +alter table t1 truncate partition p1,p1; +--error ER_WRONG_PARTITION_NAME +alter table t1 truncate partition p0; +drop table t1; + +create table t1 (a int) +partition by list (a) +subpartition by hash (a) +subpartitions 1 +(partition p1 values in (1) + (subpartition sp1)); +--error ER_WRONG_PARTITION_NAME +alter table t1 truncate partition sp1; +drop table t1; -- cgit v1.2.1