1drop table if exists t1, t2, t3, t4;
2create table t1 (a int)
3partition by list (a)
4(partition p1 values in (0));
5alter table t1 truncate partition p1,p1;
6ERROR HY000: Incorrect partition name
7alter table t1 truncate partition p0;
8ERROR HY000: Unknown partition 'p0' in table 't1'
9drop table t1;
10create table t1 (a int)
11partition by list (a)
12subpartition by hash (a)
13subpartitions 1
14(partition p1 values in (1)
15(subpartition sp1));
16alter table t1 truncate partition sp1;
17ERROR HY000: Incorrect partition name
18drop table t1;
19create table t1 (a int);
20insert into t1 values (1), (3), (8);
21alter table t1 truncate partition p0;
22ERROR HY000: Partition management on a not partitioned table is not possible
23select count(*) from t1;
24count(*)
253
26drop table t1;
27