ddl: Reorganize Partition failure/rollback tests and fixes

[mjonss]

What problem does this PR solve?

Issue Number: ref #45133

Problem Summary: Added tests, with failpoints for onReorganizePartition and fixes for found issues. Follow up of #53277

Will see how to backport tests and fixes

What changed and how does it work?

Check List

Tests

• [x] Unit test
• [ ] Integration test
• [ ] Manual test (add detailed scripts or steps below)
• [ ] No need to test

  • [ ] I checked and no code files have been changed.

Side effects

• [ ] Performance regression: Consumes more CPU
• [ ] Performance regression: Consumes more Memory
• [ ] Breaking backward compatibility

Documentation

• [ ] Affects user behaviors
• [ ] Contains syntax changes
• [ ] Contains variable changes
• [ ] Contains experimental features
• [ ] Changes MySQL compatibility

Release note

Please refer to Release Notes Language Style Guide to write a quality release note.

None