Alter Partition Truncate and Drop with partition name twice - TiDb results not consistent with mysql

[ramanich1]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

set tidb_enable_list_partition=on;
Drop table if exists t1;
create table t1 (a int)
partition by list (a)
(partition p1 values in (0));
alter table t1 truncate partition p1,p1;
alter table t1 drop partition p1,p1;
 select partition_name, partition_description, table_rows,table_name from information_schema.partitions where table_schema ='test' and table_name= 't1';

2. What did you expect to see? (Required)

mysql> alter table t1 truncate partition p1,p1;
Query OK, 0 rows affected (0.01 sec)

mysql> alter table t1 drop partition p1,p1;
ERROR 1508 (HY000): Cannot remove all partitions, use DROP TABLE instead

3. What did you see instead (Required)

mysql> alter table t1 truncate partition p1,p1; 
ERROR 8214 (HY000): Cancelled DDL job

mysql> alter table t1 drop partition p1,p1;
Query OK, 0 rows affected (0.00 sec)

mysql>  select partition_name, partition_description, table_rows,table_name from information_schema.partitions where table_schema ='test' and table_name= 't1';
+----------------+-----------------------+------------+------------+
| partition_name | partition_description | table_rows | table_name |
+----------------+-----------------------+------------+------------+
| p1             | 0                     |          0 | t1         |
+----------------+-----------------------+------------+------------+
1 row in set (0.01 sec)

4. What is your TiDB version? (Required)

| Release Version: v5.4.0-alpha-264-g6efa36df6
Edition: Community
Git Commit Hash: 6efa36df6cff325106f67ecfe3d79816ba37ca6a
Git Branch: master
UTC Build Time: 2021-12-28 02:03:55
GoVersion: go1.17.2
Race Enabled: false
TiKV Min Version: v3.0.0-60965b006877ca7234adaced7890d7b029ed1306
Check Table Before Drop: false |

[bb7133]

I do not think this is a common case and can be easily workaround.

[CbcWestwolf]

/assign mjonss

[mjonss]

TRUNCATE PARTITION in MySQL allows duplicate partition names, so we will also do it.
DROP PARTITION in MySQL has a bit more elaborate errors :)

mysql> CREATE TABLE `t1` (
  `a` int DEFAULT NULL
)
PARTITION BY LIST (`a`)
(PARTITION p1 VALUES IN (0) ENGINE = InnoDB,
 PARTITION p2 VALUES IN (1) ENGINE = InnoDB,
 PARTITION p3 VALUES IN (3) ENGINE = InnoDB);
mysql> alter table t1 drop partition p1,p1;
ERROR 1507 (HY000): Error in list of partitions to DROP
mysql> alter table t1 drop partition p1,p1,p1;
ERROR 1508 (HY000): Cannot remove all partitions, use DROP TABLE instead
mysql> alter table t1 drop partition p1,p1,p9;
ERROR 1508 (HY000): Cannot remove all partitions, use DROP TABLE instead

[github-actions]

Please check whether the issue should be labeled with 'affects-x.y' or 'fixes-x.y.z', and then remove 'needs-more-info' label.