Review main Merged

96932[TASK] Compare Extbase queries with CONTENT and the QueryBuilder

Alexander Schnitzler CR +2 V +2 Hard +630 −0 updated 10/20/26, 16:35

Commit message

Add QueryingTest with pairs that run the same question once with
the core as oracle and once with an Extbase query on the blog_example
fixture extension, and assert the same result: ordering posts by a
column of the related author, finding, counting and limiting posts
by tag names, LIKE with a percent sign inside the value, excluding a
value from a nullable column, comparing a date with a DateTime,
finding the parent of an inline child and reading the subpages of
the storage page.

The core side is ContentObjectRenderer::getRecords() with the
properties of the CONTENT property "select".

Deviations of Extbase from core:

* Finding posts by tag names and ordering them by a column of the
  author throws "SELECT DISTINCT, ORDER BY expressions must appear
  in select list" on PostgreSQL, the Extbase test is skipped there.

Review

  • Code review CR +2 Done
    • Benni Mack +2
  • Verified V +2 Done
    • Benni Mack +2
    • Oliver Klee +1
    • core-ci +1 CI

Issues 2

Files 9

Review log 67

  1. Alexander Schnitzler uploaded patch set 1 10/20/26, 15:22

  2. Alexander Schnitzler wrote 10/20/26, 15:24

    Topic set to extbase
  3. core-ci voted on patch set 1 V +1 10/20/26, 15:33 Core CI is happy: https://git.typo3.org/typo3/CI/cms/-/pipelines/111867

  4. Alexander Schnitzler marked it ready for review 10/20/26, 15:42

  5. Oliver Klee voted on patch set 1 V +1 10/20/26, 16:09

  6. Benni Mack voted on patch set 1 CR +2 V +2 10/20/26, 16:35

  7. Benni Mack merged patch set 2 10/20/26, 16:35