1#
2# Simple tests to verify truncate partition syntax
3#
4--source include/have_partition.inc
5--disable_warnings
6drop table if exists t1, t2, t3, t4;
7--enable_warnings
8
9create table t1 (a int)
10partition by list (a)
11(partition p1 values in (0));
12alter table t1 truncate partition p1,p1;
13--error ER_UNKNOWN_PARTITION
14alter table t1 truncate partition p0;
15drop table t1;
16
17create table t1 (a int)
18partition by list (a)
19subpartition by hash (a)
20subpartitions 1
21(partition p1 values in (1)
22 (subpartition sp1));
23alter table t1 truncate partition sp1;
24drop table t1;
25
26create table t1 (a int);
27insert into t1 values (1), (3), (8);
28--error ER_PARTITION_MGMT_ON_NONPARTITIONED
29alter table t1 truncate partition p0;
30select count(*) from t1;
31drop table t1;
32