[Sortable] Updating SortableGroup for multiple entities in one flush

[hafkenscheid]

Environment

Package

show

$ composer show --latest gedmo/doctrine-extensions
v3.11.1

PHP version

$ php -v
8.0.13

Subject

Probably related to #824

Case: If the SortableGroup of multiple items is updated at the same time, the SortablePosition of those items will be 0 for every item.

Steps to reproduce

Using the test entities Paper and Author.

Starting with data:

Author Name	Paper	Position
Author 1	Paper A	0
Author 2	Paper A	1
Author 3	Paper A	2
Author 4	Paper A	3
Author 5	Paper A	4
Author 6	Paper A	5
null	Paper B	0

Then updating the author for Paper B. (i.e. $paper->addAuthor('Author 4'), $paper->addAuthor('Author 5') and $paper->addAuthor('Author 6'), followed by a flush()).

Expected results

Author Name	Paper	Position
Author 1	Paper A	0
Author 2	Paper A	1
Author 3	Paper A	2
Author 4	Paper B	0
Author 5	Paper B	1
Author 6	Paper B	2

Actual results

Author Name	Paper	Position
Author 1	Paper A	0
Author 2	Paper A	1
Author 3	Paper A	2
Author 4	Paper B	0
Author 5	Paper B	0
Author 6	Paper B	0

So, the position for every author on paper B is now 0, so it lost its sequence.

[github-actions]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.

[hafkenscheid]

This is still an issue