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