Bug #116982 Truncate partition not permit DML
Submitted: 16 Dec 3:16 Modified: 16 Dec 8:05
Reporter: George Ma (OCA) Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Partitions Severity:S3 (Non-critical)
Version:8.0.40 OS:Any
Assigned to: CPU Architecture:Any

[16 Dec 3:16] George Ma
Description:
The doc in https://dev.mysql.com/doc/refman/8.0/en/innodb-online-ddl-operations.html said that TRUNCATE PARTITION Permits DML, but the test shows that this DDL will hold the EXCLUSIVE MDL of TABLE, which make it can not permit DML during DDL.

Partitioning Clause  |	Instant    |	In Place   |	Permits DML  |	Notes

TRUNCATE PARTITION   |	No	   |    Yes        |	Yes	     |  Does not copy existing data. It merely deletes rows; it does not alter the definition of the table itself, or of any of its partitions.

How to repeat:
No need.
[16 Dec 8:05] MySQL Verification Team
Hello George Ma,

Thank you for the report and feedback.

regards,
Umesh