title: MySQL Cannot Truncate and Delete all data in partition table
body: <p>As said, I'm doing and practicing a partition data in MySQL.
  As I want to clear all the data, the data still there and cannot delete in one time.</p>
  <p>This is the partition table that I created.</p>
  <pre><code>CREATE TABLE events
  (
      event_id INT unsigned NOT NULL AUTO_INCREMENT,
      inserted_date DATETIME DEFAULT CURRENT_TIMESTAMP,
      last_updated_date DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
      data JSON NOT NULL,
      KEY (event_id)
  )
  default charset utf8 
  PARTITION BY RANGE(to_days(inserted_date))
  (
  PARTITION p20210301 VALUES LESS THAN (to_days('2021-04-01')),
  PARTITION p20210401 VALUES LESS THAN (to_days('2021-05-01')),
  PARTITION p20210501 VALUES LESS THAN (to_days('2021-06-01')),
  PARTITION p20210601 VALUES LESS THAN (to_days('2021-07-01')),
  PARTITION p20210701 VALUES LESS THAN (to_days('2021-08-01')),
  PARTITION p20210801 VALUES LESS THAN (to_days('2021-09-01')),
  PARTITION p20210901 VALUES LESS THAN (to_days('2021-10-01')),
  PARTITION p20211001 VALUES LESS THAN (to_days('2021-11-01')),
  PARTITION p20211101 VALUES LESS THAN (to_days('2021-12-01')),
  PARTITION p20211201 VALUES LESS THAN (to_days('2022-01-01')),
  PARTITION p20220101 VALUES LESS THAN (to_days('2022-02-01')),
  PARTITION p20220201 VALUES LESS THAN (to_days('2022-03-01')),
  PARTITION p20220301 VALUES LESS THAN (to_days('2022-04-01')),
  PARTITION p20220401 VALUES LESS THAN (to_days('2022-05-01')),
  PARTITION p20220501 VALUES LESS THAN (to_days('2022-06-01')),
  PARTITION future VALUES LESS THAN (MAXVALUE) 
  );
  </code></pre>
  <p>First question is everytime I select all data, different rows of data come out.
  <a href="https://i.stack.imgur.com/lUgvh.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/lUgvh.png" alt="enter image description here" /></a></p>
  <pre><code>SELECT 
      * 
  FROM 
      plover_audit_log.events
  </code></pre>
  <p>Second I can't truncate the table. Everytime I truncate the table, the data still there.
  <a href="https://i.stack.imgur.com/TluOZ.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/TluOZ.png" alt="enter image description here" /></a></p>
  <pre><code>truncate table plover_audit_log.events;
  </code></pre>
  <p>Third even I try to delete the data, it cannot delete completely. The data still there after delete.
  <a href="https://i.stack.imgur.com/Z40mc.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Z40mc.png" alt="enter image description here" /></a></p>
  <pre><code>delete from plover_audit_log.events;
  </code></pre>
  <p>I'm curious on is my MySQL software problem? Or partition table make this happen?
  Because I have a backup table <strong>without partition</strong> is work well with Truncate, Delete and Select script.</p>