Extbase Facts Baseline: TYPO3 14.3

Reading translations

How a translated record is read depends on the language aspect: the requested language, the overlay mode and the fallback chain. The core reads the records of a page in the default language and overlays each with PageRepository, dropping what the overlay drops. Each scenario below reads the same records once that way and once through an Extbase repository with the same language aspect, and compares the returned records, their uids and titles, the counts and limits.

Provenance

Tests ran on main (15.0-dev), which is assumed to behave as TYPO3 14.3.

Summary

11 scenarios, by Extbase status:

Comparison

ScenarioCoreExtbase
Reading all articles with overlays on Read with German and overlays on, the core returns the articles that have a German translation, with the German title: article 2 as "Erster Artikel" and article 5 as "Zweiter Artikel". The record for all languages (7) is returned unchanged. Article 1 has no translation and is dropped, article 8 has no default record and is not found, because the core overlays default records. Same as coreRead with German and overlays on, Extbase returns the same three articles as the core: article 2 as "Erster Artikel", article 5 as "Zweiter Artikel" and the record for all languages (7). Article 1 without translation is dropped, the German record without default record (8) is not returned.
Reading all articles with overlays mixed Read with German and overlays mixed, the core returns the translated articles with the German title and keeps the article that has no translation in English: article 1 as "Only in English", article 2 as "Erster Artikel", article 5 as "Zweiter Artikel", and the record for all languages (7). Article 8 has no default record and is not found. Same as coreRead with German and overlays mixed, Extbase returns the same four articles as the core: article 1 in English, articles 2 and 5 with the German title and the record for all languages (7). The German record without default record (8) is not returned.
Reading all articles in strict mode Read with German and overlays off (strict mode), the core does no overlay and returns the German rows as they are stored: the translations 3 and 6, the German record without default record (8) and the record for all languages (7), each with its own uid. DeviatesRead with German and overlays off, Extbase returns the same four rows as the core, but it identifies the translations by the uid of their default record: "Erster Artikel" is article 2 and "Zweiter Artikel" is article 5, where the core returns the rows with their own uids 3 and 6. The record for all languages keeps the uid 7 and the German record without default record keeps the uid 8.
Reading with a fallback chain French falls back to German and then to English. Read with French, this fallback chain and overlays mixed, the core returns for every article the first language of the chain that has a translation: article 2 in French ("Premier article"), article 5 in German ("Zweiter Artikel") because it has no French translation, article 1 in English ("Only in English") and the record for all languages (7). Same as coreRead with French, the fallback chain German, English and overlays mixed, Extbase returns the same four articles as the core: article 2 in French, article 5 in German through the fallback chain, article 1 in English and the record for all languages (7).
Reading with a fallback chain and overlays on French falls back to German and then to English. Read with French, this fallback chain and overlays on, the core returns the articles that have a translation in a language of the chain: article 2 in French ("Premier article"), article 5 in German ("Zweiter Artikel") and the record for all languages (7). Article 1 has no translation in the chain and is dropped. DeviatesRead with French, the fallback chain German, English and overlays on, Extbase selects only the French translation of article 2 and the record for all languages and returns just these two: article 2 as "Premier article" and article 7. Article 5 is missing, although the core finds its German translation in the fallback chain.
Counting articles with a fallback chain and overlays on With French, the fallback chain German, English and overlays on, the core has three articles to show: 2, 5 and 7. The number of articles is the size of the overlaid result, so it is 3. DeviatesWith French, the fallback chain German, English and overlays on, Extbase counts the rows it selects from the database: the French translation of article 2 and the record for all languages. The count is 2, article 5 with its German translation from the fallback chain is not counted.
Counting articles with overlays on With German and overlays on, the core has three articles to show: 2, 5 and 7. The number of articles is the size of the overlaid result, so it is 3. Same as coreWith German and overlays on, Extbase counts the three articles that it also returns when it reads them: the German translations of the articles 2 and 5 and the record for all languages. The count is 3.
Limiting articles with overlays on With German and overlays on, the core has the articles 2, 5 and 7 to show. Limited to two articles, it returns the first two of them: article 2 as "Erster Artikel" and article 5 as "Zweiter Artikel". Same as coreLimited to two articles with German and overlays on, Extbase returns the same two articles as the core: article 2 as "Erster Artikel" and article 5 as "Zweiter Artikel". The limit is applied to the German rows, so the untranslated article 1 does not use up one of the two places.
Reading without language restriction The core has no query without language restriction: it reads default rows and overlays them, so the result is the one of reading with German and overlays on. Every article is returned once: articles 2, 5 and 7. DeviatesWith the language restriction of the query off, Extbase selects every row of the storage page and overlays each row with its own language, so a record appears once per row: article 2 three times (as the default row with the German title, as the German translation and as the French translation "Premier article"), article 5 twice, plus article 7 and the German record without default record (8). The result has seven records.
Finding a translation by the uid of the default record The German translations of the articles 2 and 5 are found through the uids of the default records. The core reads the default rows with these uids and overlays them with German and overlays on: it returns "Erster Artikel" for article 2 and "Zweiter Artikel" for article 5. DeviatesRead with German and overlays on, Extbase selects the German rows, which have the uids 3 and 6, so a constraint on the uids 2 and 5 of the default records matches none of them. The result is empty.
A record for all languages is read once Article 7 is a record for all languages (language -1). The core returns it unchanged and once, with German and with French. Same as coreRead with German and with French and overlays on, Extbase returns the record for all languages (article 7) once per result and unchanged, as the core does.

Scenarios

Reading all articles with overlays on

Same as core

In 14.3

Core: Read with German and overlays on, the core returns the articles that have a German translation, with the German title: article 2 as "Erster Artikel" and article 5 as "Zweiter Artikel". The record for all languages (7) is returned unchanged. Article 1 has no translation and is dropped, article 8 has no default record and is not found, because the core overlays default records.

Extbase: Read with German and overlays on, Extbase returns the same three articles as the core: article 2 as "Erster Artikel", article 5 as "Zweiter Artikel" and the record for all languages (7). Article 1 without translation is dropped, the German record without default record (8) is not returned.

Testtypo3/sysext/extbase/Tests/Functional/Persistence/Facts/ReadingTranslationsTest.php:97 (Core) (local)
Testtypo3/sysext/extbase/Tests/Functional/Persistence/Facts/ReadingTranslationsTest.php:112 (Extbase) (local)

Reading all articles with overlays mixed

Same as core

In 14.3

Core: Read with German and overlays mixed, the core returns the translated articles with the German title and keeps the article that has no translation in English: article 1 as "Only in English", article 2 as "Erster Artikel", article 5 as "Zweiter Artikel", and the record for all languages (7). Article 8 has no default record and is not found.

Extbase: Read with German and overlays mixed, Extbase returns the same four articles as the core: article 1 in English, articles 2 and 5 with the German title and the record for all languages (7). The German record without default record (8) is not returned.

Testtypo3/sysext/extbase/Tests/Functional/Persistence/Facts/ReadingTranslationsTest.php:127 (Core) (local)
Testtypo3/sysext/extbase/Tests/Functional/Persistence/Facts/ReadingTranslationsTest.php:142 (Extbase) (local)

Reading all articles in strict mode

Deviates

In 14.3

Core: Read with German and overlays off (strict mode), the core does no overlay and returns the German rows as they are stored: the translations 3 and 6, the German record without default record (8) and the record for all languages (7), each with its own uid.

Extbase: Read with German and overlays off, Extbase returns the same four rows as the core, but it identifies the translations by the uid of their default record: "Erster Artikel" is article 2 and "Zweiter Artikel" is article 5, where the core returns the rows with their own uids 3 and 6. The record for all languages keeps the uid 7 and the German record without default record keeps the uid 8.

Target for 15.x

Extbase behaves as the core.

Testtypo3/sysext/extbase/Tests/Functional/Persistence/Facts/ReadingTranslationsTest.php:157 (Core) (local)
Testtypo3/sysext/extbase/Tests/Functional/Persistence/Facts/ReadingTranslationsTest.php:172 (Extbase) (local)
SkipExtbase differs from core: it returns the German translations under the uids of their default records (2 and 5), where the core returns the rows with their own uids (3 and 6).
TestReadingTranslationsTest::readingAllArticlesInStrictModeByExtbase (Failure without skip)
Failed asserting that two arrays are identical.
--- Expected
+++ Actual
@@ @@
 Array &0 [
     0 => Array &1 [
-        0 => 3,
+        0 => 2,
         1 => 'Erster Artikel',
     ],
     1 => Array &2 [
-        0 => 6,
+        0 => 5,
         1 => 'Zweiter Artikel',
     ],
     2 => Array &3 [

Reading with a fallback chain

Same as core

In 14.3

Core: French falls back to German and then to English. Read with French, this fallback chain and overlays mixed, the core returns for every article the first language of the chain that has a translation: article 2 in French ("Premier article"), article 5 in German ("Zweiter Artikel") because it has no French translation, article 1 in English ("Only in English") and the record for all languages (7).

Extbase: Read with French, the fallback chain German, English and overlays mixed, Extbase returns the same four articles as the core: article 2 in French, article 5 in German through the fallback chain, article 1 in English and the record for all languages (7).

Testtypo3/sysext/extbase/Tests/Functional/Persistence/Facts/ReadingTranslationsTest.php:190 (Core) (local)
Testtypo3/sysext/extbase/Tests/Functional/Persistence/Facts/ReadingTranslationsTest.php:205 (Extbase) (local)

Reading with a fallback chain and overlays on

Deviates

In 14.3

Core: French falls back to German and then to English. Read with French, this fallback chain and overlays on, the core returns the articles that have a translation in a language of the chain: article 2 in French ("Premier article"), article 5 in German ("Zweiter Artikel") and the record for all languages (7). Article 1 has no translation in the chain and is dropped.

Extbase: Read with French, the fallback chain German, English and overlays on, Extbase selects only the French translation of article 2 and the record for all languages and returns just these two: article 2 as "Premier article" and article 7. Article 5 is missing, although the core finds its German translation in the fallback chain.

Target for 15.x

Extbase behaves as the core.

Testtypo3/sysext/extbase/Tests/Functional/Persistence/Facts/ReadingTranslationsTest.php:220 (Core) (local)
Testtypo3/sysext/extbase/Tests/Functional/Persistence/Facts/ReadingTranslationsTest.php:235 (Extbase) (local)
SkipExtbase differs from core: with a fallback chain and overlays on it selects only rows in the requested language, so article 5, which has only a German translation, is missing.
TestReadingTranslationsTest::readingWithAFallbackChainAndOverlaysOnByExtbase (Failure without skip)
Failed asserting that two arrays are identical.
--- Expected
+++ Actual
@@ @@
         1 => 'Premier article',
     ],
     1 => Array &2 [
-        0 => 5,
-        1 => 'Zweiter Artikel',
-    ],
-    2 => Array &3 [
         0 => 7,
         1 => 'All languages',
     ],
 ]

Counting articles with a fallback chain and overlays on

Deviates

In 14.3

Core: With French, the fallback chain German, English and overlays on, the core has three articles to show: 2, 5 and 7. The number of articles is the size of the overlaid result, so it is 3.

Extbase: With French, the fallback chain German, English and overlays on, Extbase counts the rows it selects from the database: the French translation of article 2 and the record for all languages. The count is 2, article 5 with its German translation from the fallback chain is not counted.

Target for 15.x

Extbase behaves as the core.

Testtypo3/sysext/extbase/Tests/Functional/Persistence/Facts/ReadingTranslationsTest.php:253 (Core) (local)
Testtypo3/sysext/extbase/Tests/Functional/Persistence/Facts/ReadingTranslationsTest.php:268 (Extbase) (local)
SkipExtbase differs from core: it counts 2 where the core has 3 articles to show, because with a fallback chain and overlays on it selects only rows in the requested language.
TestReadingTranslationsTest::countingArticlesWithAFallbackChainAndOverlaysOnByExtbase (Failure without skip)
Failed asserting that 2 is identical to 3.

Counting articles with overlays on

Same as core

In 14.3

Core: With German and overlays on, the core has three articles to show: 2, 5 and 7. The number of articles is the size of the overlaid result, so it is 3.

Extbase: With German and overlays on, Extbase counts the three articles that it also returns when it reads them: the German translations of the articles 2 and 5 and the record for all languages. The count is 3.

Testtypo3/sysext/extbase/Tests/Functional/Persistence/Facts/ReadingTranslationsTest.php:286 (Core) (local)
Testtypo3/sysext/extbase/Tests/Functional/Persistence/Facts/ReadingTranslationsTest.php:301 (Extbase) (local)

Limiting articles with overlays on

Same as core

In 14.3

Core: With German and overlays on, the core has the articles 2, 5 and 7 to show. Limited to two articles, it returns the first two of them: article 2 as "Erster Artikel" and article 5 as "Zweiter Artikel".

Extbase: Limited to two articles with German and overlays on, Extbase returns the same two articles as the core: article 2 as "Erster Artikel" and article 5 as "Zweiter Artikel". The limit is applied to the German rows, so the untranslated article 1 does not use up one of the two places.

Testtypo3/sysext/extbase/Tests/Functional/Persistence/Facts/ReadingTranslationsTest.php:316 (Core) (local)
Testtypo3/sysext/extbase/Tests/Functional/Persistence/Facts/ReadingTranslationsTest.php:331 (Extbase) (local)

Reading without language restriction

Deviates

In 14.3

Core: The core has no query without language restriction: it reads default rows and overlays them, so the result is the one of reading with German and overlays on. Every article is returned once: articles 2, 5 and 7.

Extbase: With the language restriction of the query off, Extbase selects every row of the storage page and overlays each row with its own language, so a record appears once per row: article 2 three times (as the default row with the German title, as the German translation and as the French translation "Premier article"), article 5 twice, plus article 7 and the German record without default record (8). The result has seven records.

Target for 15.x

Extbase behaves as the core.

Testtypo3/sysext/extbase/Tests/Functional/Persistence/Facts/ReadingTranslationsTest.php:348 (Core) (local)
Testtypo3/sysext/extbase/Tests/Functional/Persistence/Facts/ReadingTranslationsTest.php:363 (Extbase) (local)
SkipExtbase differs from core: it returns seven records with article 2 three times and article 5 twice, and includes the German record without default record (8), where the core returns each of the three articles once.
TestReadingTranslationsTest::readingWithoutLanguageRestrictionByExtbase (Failure without skip)
Failed asserting that two arrays are identical.
--- Expected
+++ Actual
@@ @@
         1 => 'Erster Artikel',
     ],
     1 => Array &2 [
+        0 => 2,
+        1 => 'Erster Artikel',
+    ],
+    2 => Array &3 [
+        0 => 2,
+        1 => 'Premier article',
+    ],
+    3 => Array &4 [
         0 => 5,
         1 => 'Zweiter Artikel',
     ],
-    2 => Array &3 [
+    4 => Array &5 [
+        0 => 5,
+        1 => 'Zweiter Artikel',
+    ],
+    5 => Array &6 [
         0 => 7,
         1 => 'All languages',
+    ],
+    6 => Array &7 [
+        0 => 8,
+        1 => 'Freie Übersetzung',
     ],
 ]

Finding a translation by the uid of the default record

Deviates

In 14.3

Core: The German translations of the articles 2 and 5 are found through the uids of the default records. The core reads the default rows with these uids and overlays them with German and overlays on: it returns "Erster Artikel" for article 2 and "Zweiter Artikel" for article 5.

Extbase: Read with German and overlays on, Extbase selects the German rows, which have the uids 3 and 6, so a constraint on the uids 2 and 5 of the default records matches none of them. The result is empty.

Target for 15.x

Extbase behaves as the core.

Testtypo3/sysext/extbase/Tests/Functional/Persistence/Facts/ReadingTranslationsTest.php:383 (Core) (local)
Testtypo3/sysext/extbase/Tests/Functional/Persistence/Facts/ReadingTranslationsTest.php:398 (Extbase) (local)
SkipExtbase differs from core: it returns no record, because the constraint on the uids of the default records matches none of the selected German rows (3 and 6).
TestReadingTranslationsTest::findingATranslationByTheUidOfTheDefaultRecordByExtbase (Failure without skip)
Failed asserting that two arrays are identical.
--- Expected
+++ Actual
@@ @@
-Array &0 [
-    0 => Array &1 [
-        0 => 2,
-        1 => 'Erster Artikel',
-    ],
-    1 => Array &2 [
-        0 => 5,
-        1 => 'Zweiter Artikel',
-    ],
-]
+Array &0 []

A record for all languages is read once

Same as core

In 14.3

Core: Article 7 is a record for all languages (language -1). The core returns it unchanged and once, with German and with French.

Extbase: Read with German and with French and overlays on, Extbase returns the record for all languages (article 7) once per result and unchanged, as the core does.

Testtypo3/sysext/extbase/Tests/Functional/Persistence/Facts/ReadingTranslationsTest.php:418 (Core) (local)
Testtypo3/sysext/extbase/Tests/Functional/Persistence/Facts/ReadingTranslationsTest.php:435 (Extbase) (local)