#110794Align Extbase persistence with the core
Description
Problem
Extbase reads and writes records differently from the core in many places, and most of these differences are known only from single bug reports:
- Deleting: removing an object loaded as its translation deletes the default record; deleting the default record leaves its translations; inline children without cascade remove stay.
- Translations: the relations of a translation are written to the rows of the default record (MM reorder/remove); a new child of a translation gets language 0; synchronised fields and
hideAtCopyare ignored. - Workspaces: an update inside a workspace writes the live row; count and LIMIT work on live rows before the overlay.
- Reading: records per overlay mode, uids with overlays off, sorting, fallback chains and floating records differ from CONTENT and the Record API.
- Field values: TCA eval, defaults, slug, uuid and native date columns are not applied the way DataHandler applies them.
The code that makes these decisions sits in three large classes (Typo3DbQueryParser, Typo3DbBackend, Backend), and the existing tests check SQL strings, not outcomes. A first approach pinned today’s Extbase behaviour in an outcome-based conformance suite (#110797, #110798). It turned out that pinning today’s behaviour also pins where Extbase is wrong, and a refactoring or a later persistence on doctrine/orm built on it would carry those errors along.
Goal
The core is the yardstick. For every topic there are pairs of functional tests on blog_example: a ByCore test does the action the way the backend or the frontend does it (DataHandler as admin, CONTENT, Record API), a ByExtbase test does the same through Extbase and expects the same result. While Extbase differs, the ByExtbase test is skipped with “Extbase differs from core: …”. The skipped tests are the work list: fixes make them pass, in a way that also works for a later persistence on doctrine/orm.
Sub-tasks
Step 1: pairs per topic (tests only)
One ticket and one patch per topic, below this epic:
- Removing records (translations, inline children with and without cascade remove, records without delete column, MM rows)
- Written field values (TCA eval, tstamp/crdate, defaults, uuid, slug, nullable and native date columns)
- Creating and changing translations
- MM relations of translations
- Inline, group and category relations
- To-one relations
- Reading relations (Record API)
- Reading translated records (CONTENT: overlay modes, uids, ordering, count, limit)
- Reading relations of translated records
- Reading and writing in workspaces
- Enable fields and visibility
- Constraints and operators
- Record types
- History, log and reference index
- Extbase-only behaviour without a core counterpart (fetch events, raw SQL statements, unsupported operators)
The tests of BehaviourConformanceTest (#110797, #110798) are replaced topic by topic by these pairs; tests that pin Extbase-only behaviour stay as plain Extbase tests.
Step 2: fixes
Each fix makes one or more skipped ByExtbase tests pass and removes their skip. Where a fix needs structure (one place for the language, workspace and visibility conditions, for the row overlay, for the write target), that structure is extracted as part of the fix.
Reference
- Facts on Extbase vs. the core, each backed by such a pair: https://extbase.alexanderschnitzler.de
- Earlier refactoring study: https://github.com/TYPO3/typo3/compare/main…alexanderschnitzler:typo3:make-extbase-persistence-behaviour-explicit-and-testable
Reviews 18
- main 96928[TASK] Compare reading translated records in Extbase with CONTENT
- main 96931[TASK] Compare Extbase visibility with CONTENT and the core
- main 96930[TASK] Compare Extbase and core when reading and writing in workspaces
- main 96939[TASK] Cover fetch events, raw statements and unsupported operators
- main 96920[TASK] Compare written field values in Extbase with DataHandler
- main 96927[TASK] Test reading relations with Record API and Extbase
- main 96921[TASK] Compare writing MM relations in Extbase with DataHandler
- main 96937[TASK] Compare history, log and reference index with DataHandler
- main 96932[TASK] Compare Extbase queries with CONTENT and the QueryBuilder
- main 96929[TASK] Compare reading relations of translations with the Record API
- main 96934[TASK] Compare Extbase record types with the core
- main 96922[TASK] Compare writing to-one relations in Extbase with DataHandler
- main 96924[TASK] Compare inline, group and category relations with DataHandler
- main 96923[TASK] Compare translating records in Extbase with DataHandler
- main 96914[TASK] Compare removing records in Extbase with DataHandler
- main 96801[TASK] Align LIMIT expectations of the conformance suite with CONTENT
- main 96798[TASK] Pin Extbase workspace reads and writes in the conformance suite
- main 96089[TASK] Add conformance suite for Extbase language overlays
Fix this issue
Start the commit message of your patch with this. Add what the patch does, and the versions it goes to in "Releases:". The changes above were merged or abandoned: read them before you start. How to create a patch
- Commit message
-
[TASK] Align Extbase persistence with the core Resolves: #110794 Releases: main
Subtasks 17
- Task #110795Pin Extbase persistence behaviour in an outcome-based conformance suite
- Task #111124Align LIMIT expectations of the Extbase conformance suite with CONTENT
- Task #111161Repository::remove(): compare removing records with DataHandler
- Task #111162Persistence: compare written field values with DataHandler
- Task #111163Persistence: compare creating and changing translations with DataHandler
- Task #111164ObjectStorage: compare MM relations of translations with DataHandler
- Task #111165ObjectStorage: compare inline, group and category relations with DataHandler
- Task #111166DataMapper: compare writing to-one relations with DataHandler
- Task #111167DataMapper: compare reading relations with the Record API
- Task #111168Repository: compare reading translated records with CONTENT
- Task #111169Repository: compare reading relations of translated records with the Record API
- Task #111170Repository: compare reading and writing in workspaces with the core
- Task #111171QuerySettings: compare enable fields and visibility with CONTENT
- Task #111172Query: compare constraints and operators with CONTENT
- Task #111173DataMapper: compare record types with the core
- Task #111174Persistence: compare history, log and reference index with DataHandler
- Task #111175Persistence: cover fetch events, raw SQL statements and unsupported operators
Related issues 4
History 26
Show 1 earlier messages
-
Alexander Schnitzler changed Related to #108335 <span data-processor="relativetime" data-value="2026-09-25T16:38:56+00:00" > 09/25/26, 16:38 </span>
-
Alexander Schnitzler changed Related to #110008 <span data-processor="relativetime" data-value="2026-09-25T16:39:18+00:00" > 09/25/26, 16:39 </span>
-
Alexander Schnitzler changed Related to #75358 <span data-processor="relativetime" data-value="2026-09-25T16:39:58+00:00" > 09/25/26, 16:39 </span>
-
Alexander Schnitzler changed subtask #110795 <span data-processor="relativetime" data-value="2026-09-25T16:42:30+00:00" > 09/25/26, 16:42 </span>
-
Alexander Schnitzler changed tracker
StoryEpic TYPO3 Version15PHP Version8.5<span data-processor="relativetime" data-value="2026-09-25T16:43:03+00:00" > 09/25/26, 16:43 </span> -
Alexander Schnitzler changed description <span data-processor="relativetime" data-value="2026-09-25T18:19:40+00:00" > 09/25/26, 18:19 </span>
-
Alexander Schnitzler changed description <span data-processor="relativetime" data-value="2026-09-25T18:23:54+00:00" > 09/25/26, 18:23 </span>
-
Alexander Schnitzler changed subtask #111124 <span data-processor="relativetime" data-value="2026-10-17T18:12:57+00:00" > 10/17/26, 18:12 </span>
-
Alexander Schnitzler changed subject
Make Extbase persistence behaviour explicit and testableAlign Extbase persistence with the core description <span data-processor="relativetime" data-value="2026-10-20T12:37:29+00:00" > 10/20/26, 12:37 </span> -
Alexander Schnitzler changed subtask #111161 <span data-processor="relativetime" data-value="2026-10-20T12:40:28+00:00" > 10/20/26, 12:40 </span>
-
Alexander Schnitzler changed subtask #111162 <span data-processor="relativetime" data-value="2026-10-20T12:40:30+00:00" > 10/20/26, 12:40 </span>
-
Alexander Schnitzler changed subtask #111163 <span data-processor="relativetime" data-value="2026-10-20T12:40:30+00:00" > 10/20/26, 12:40 </span>
-
Alexander Schnitzler changed subtask #111164 <span data-processor="relativetime" data-value="2026-10-20T12:40:32+00:00" > 10/20/26, 12:40 </span>
-
Alexander Schnitzler changed subtask #111165 <span data-processor="relativetime" data-value="2026-10-20T12:40:34+00:00" > 10/20/26, 12:40 </span>
-
Alexander Schnitzler changed subtask #111166 <span data-processor="relativetime" data-value="2026-10-20T12:40:35+00:00" > 10/20/26, 12:40 </span>
-
Alexander Schnitzler changed subtask #111167 <span data-processor="relativetime" data-value="2026-10-20T12:40:37+00:00" > 10/20/26, 12:40 </span>
-
Alexander Schnitzler changed subtask #111168 <span data-processor="relativetime" data-value="2026-10-20T12:40:39+00:00" > 10/20/26, 12:40 </span>
-
Alexander Schnitzler changed subtask #111169 <span data-processor="relativetime" data-value="2026-10-20T12:40:39+00:00" > 10/20/26, 12:40 </span>
-
Alexander Schnitzler changed subtask #111170 <span data-processor="relativetime" data-value="2026-10-20T12:40:40+00:00" > 10/20/26, 12:40 </span>
-
Alexander Schnitzler changed subtask #111171 <span data-processor="relativetime" data-value="2026-10-20T12:40:41+00:00" > 10/20/26, 12:40 </span>
-
Alexander Schnitzler changed subtask #111172 <span data-processor="relativetime" data-value="2026-10-20T12:40:43+00:00" > 10/20/26, 12:40 </span>
-
Alexander Schnitzler changed subtask #111173 <span data-processor="relativetime" data-value="2026-10-20T12:40:44+00:00" > 10/20/26, 12:40 </span>
-
Alexander Schnitzler changed subtask #111174 <span data-processor="relativetime" data-value="2026-10-20T12:40:46+00:00" > 10/20/26, 12:40 </span>
-
Alexander Schnitzler changed subtask #111175 <span data-processor="relativetime" data-value="2026-10-20T12:40:48+00:00" > 10/20/26, 12:40 </span>
-
Georg Ringer changed status
NewIn Progress <span data-processor="relativetime" data-value="2026-10-23T05:44:01+00:00" > 10/23/26, 05:44 </span> -
Benni Mack changed Related to #75404 <span data-processor="relativetime" data-value="2026-11-19T10:13:52+00:00" > 11/19/26, 10:13 </span>