TYPO3 Core

This is somehow related to https://review.typo3.org/c/Packages/TYPO3.CMS/+/59955 and

Where you need a matchbyPageId() and need to put in the online version of the record in.

It works if i changed TYPO3\CMS\Install\Updates\PopulatePageSlugs->populateSlugs()
I add $liveRecordId;

while ($record = $statement->fetch()) {
            $recordId = (int)$record['uid'];
            $liveRecordId = $recordId;
            $pid = (int)$record['pid'];
            $languageId = (int)$record['sys_language_uid'];
            $pageIdInDefaultLanguage = $languageId > 0 ? (int)$record['l10n_parent'] : $recordId;
            $slug = $suggestedSlugs[$pageIdInDefaultLanguage][$languageId] ?? '';

            // see if an alias field was used, then let's build a slug out of that.
            if (!empty($record['alias'])) {
                $slug = $slugHelper->sanitize('/' . $record['alias']);
            }

            if (empty($slug)) {
                if ($pid === -1) {
                    $queryBuilder = $connection->createQueryBuilder();
                    $queryBuilder->getRestrictions()->removeAll()->add(GeneralUtility::makeInstance(DeletedRestriction::class));
                    $liveVersion = $queryBuilder
                        ->select('pid')
                        ->from('pages')
                        ->where(
                            $queryBuilder->expr()->eq('uid', $queryBuilder->createNamedParameter($record['t3ver_oid'], \PDO::PARAM_INT))
                        )->execute()->fetch();
                    $pid = (int)$liveVersion['pid'];
                    $liveRecordId = (int)$liveVersion['uid'];
                }
                $slug = $slugHelper->generate($record, $pid);
            }

            $state = RecordStateFactory::forName($this->table)
                ->fromArray($record, $pid, $liveRecordId);
            if ($hasToBeUniqueInSite && !$slugHelper->isUniqueInSite($slug, $state)) {
                $slug = $slugHelper->buildSlugForUniqueInSite($slug, $state);
            }
            if ($hasToBeUniqueInPid && !$slugHelper->isUniqueInPid($slug, $state)) {
                $slug = $slugHelper->buildSlugForUniqueInPid($slug, $state);
            }

            $connection->update(
                $this->table,
                [$this->fieldName => $slug],
                ['uid' => $recordId]
            );
        }

That's (from my POV) how it should behave - according changes and tests still missing.

--- a/typo3/sysext/core/Classes/DataHandling/Model/RecordState.php
+++ b/typo3/sysext/core/Classes/DataHandling/Model/RecordState.php
@@ -174,23 +174,27 @@ class RecordState
      * the `pid` of the current subject.
      *
      * Example:
-     * + pages: uid: 10, pid: 5, sys_language_uid: 0, l10n_parent: 0  -> returns 10
-     * + pages: uid: 11, pid: 5, sys_language_uid: 1, l10n_parent: 10 -> returns 10
-     * + other: uid: 12, pid: 10 -> returns 10
+     * + pages: uid: 10, pid:  5, sys_language_uid: 0, l10n_parent:  0, t3ver_oid:  0 -> returns 10
+     * + pages: uid: 11, pid:  5, sys_language_uid: 1, l10n_parent: 10, t3ver_oid:  0 -> returns 10
+     * + pages: uid: 12, pid: -1, sys_language_uid: 0, l10n_parent:  0, t3ver_oid: 10 -> returns 10
+     * + pages: uid: 13, pid: -1, sys_language_uid: 1, l10n_parent: 12, t3ver_oid: 11 -> returns 10
+     * + other: uid: 21, pid: 10, t3ver_oid: 0  -> returns 10
+     * + other: uid: 22, pid: -1, t3ver_oid: 21 -> returns 10
      *
      * @return string
      */
     public function resolveNodeAggregateIdentifier(): string
     {

Patch set 3 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/60500

Patch set 1 for branch 9.5 of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/60626