Bug #116982 Truncate partition not permit DML
Submitted: 16 Dec 2024 3:16 Modified: 16 Dec 2024 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 2024 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 2024 8:05] MySQL Verification Team
Hello George Ma,

Thank you for the report and feedback.

regards,
Umesh