Review main Ready for review

97633[TASK] Resolve record descendants with a recursive CTE

Benni Mack CR 0 V 0 Hard +332 −0 updated 11/15/26, 01:20

Commit message

When the parent field of a record in a tree relation to its own table
is edited, the record and all its descendants are marked unselectable.
The descendants were looked up level by level, with one query per
descendant.

The new internal RecordDescendantsRepository resolves all descendants
with one recursive query. In a workspace, the version of a record
replaces its live record, so a record moved to another parent in the
workspace is found below its new parent. Parent cycles end the
traversal.

The tree data provider uses it whenever the parent field holds the
uid of a single parent. Fields with several parents per record keep
the previous lookup.

Test this change

Run a command in your clone of the TYPO3 Core. Then try what the change does and vote on Verified in Gerrit. How to review a patch

Check out patch set 2
git fetch https://review.typo3.org/Packages/TYPO3.CMS refs/changes/33/97633/2 && git checkout FETCH_HEAD
Cherry-pick onto main
git fetch https://review.typo3.org/Packages/TYPO3.CMS refs/changes/33/97633/2 && git cherry-pick FETCH_HEAD

Review

  • Code review CR 0 Needs a vote
  • Verified V 0 Needs a vote
    • core-ci +1 CI

Merge conflicts 1

Issues 2

Files 7

Review log 23

  1. Benni Mack uploaded patch set 1 11/13/26, 20:32

  2. Simon Schaufelberger rebased onto patch set 2 11/15/26, 01:14

  3. core-ci voted on patch set 2 V +1 11/15/26, 01:20 Core CI is happy: https://git.typo3.org/typo3/CI/cms/-/pipelines/114497