diff options
| author | Mikael Ronstrom <mikael@mysql.com> | 2009-09-10 11:15:39 +0200 |
|---|---|---|
| committer | Mikael Ronstrom <mikael@mysql.com> | 2009-09-10 11:15:39 +0200 |
| commit | d0d52e9f11ab7bad11d34d207139a26f26dd362c (patch) | |
| tree | e4de6989be4d51f542339759b99eec9a100c3c33 /mysql-test/t/partition_truncate.test | |
| parent | 905d715f10e711860311e0a10488c6bb5e19ee49 (diff) | |
| download | mariadb-git-d0d52e9f11ab7bad11d34d207139a26f26dd362c.tar.gz | |
WL#4444 Added TRUNCATE partition support, fixes bug#19405 and bug #35111
Diffstat (limited to 'mysql-test/t/partition_truncate.test')
| -rw-r--r-- | mysql-test/t/partition_truncate.test | 26 |
1 files changed, 26 insertions, 0 deletions
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; |