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

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.049 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.