[4.x]: Prune revisions with Matrix destroys entries

[vandres]

What happened?

Description

When having Matrix blocks, upon calling utils/prune-revisions, the Matrix blocks get destroyed

Steps to reproduce

1. Setup Craft 4
2. Create a Matrix block and assign it to a section
3. Don't know if it is relevant, but it's a multi site setup
4. Create some content in that section entry
5. Call utils/prune-revisions with 0
6. Try to save the entry again

I've setup a repo to display the issue https://github.com/vandres/craft4-prune-revisions-matrix

In the sql folder, you have a db dump before and after the prune.

Expected behavior

All but 1 revisions are gone. It should be still possible to save new revisions.

Actual behavior

Saving entries after the prune is no longer possible.

Craft CMS version

4.0.2

PHP version

8.0

Operating system and version

Debian 11

Database type and version

MariaDB 10.3

Image driver and version

No response

Installed plugins and versions

None - blank default setup

[brandonkelly]

This is the same underlying issue as #11155, which has been fixed for the next release (imminent).

[brandonkelly]

Craft 4.0.3 is out now with that fix.

[vandres]

Thank you very much!Will it fix existing records or only future ones?

[brandonkelly]

There was nothing to fix, actually. utils/prune-revisions just doesn’t completely erase the revision data (which is sortof a bug, but something that garbage collection will take care of so not a big deal), but the partial remaining revision data was confusing a part of Craft’s revision creation process into thinking a revision existed when it didn’t.