Index entry delete assertion Key Exists fails during REORG PARTITION for non-clustered table.

[mjonss]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

Apply this diff (reorg-part-index-assert-issue.diff.txt) and run the new test TestRemovePartitioningCovering and see that there are failed assertions.

2. What did you expect to see? (Required)

No assertions

3. What did you see instead (Required)

assertions on update and delete, where the old partition is no longer written by StatePublic, resulting in StateDeleteOnly (previous state, which should still be allowed to do DML) will try to delete index entries, that does not exist, so the Assert that they do exists fails.

4. What is your TiDB version? (Required)

tidb_version(): Release Version: v9.0.0-alpha-83-g244062f826
Edition: Community
Git Commit Hash: 244062f826f75494525e3ac319d0e8ad794b0a43
Git Branch: HEAD
UTC Build Time: 2025-01-10 14:24:14
GoVersion: go1.23.4
Race Enabled: false
Check Table Before Drop: false
Store: unistore