Bug #116982 Truncate partition not permit DML

• Submitted: 16 Dec 2024 3:16
• Modified: 16 Dec 2024 8:05
• Reporter: George Ma (OCA)
• Status: Verified
• Category: MySQL Server: Partitions
• Severity: S3 (Non-critical)
• Version: 8.0.40
• OS: Any
• 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