Issue Task Resolved

#111186Skip ordering by a joined field with DISTINCT in QueryingTest on MySQL

Alexander Schnitzler 10/21/26, 06:47 updated 10/21/26, 07:40

Description

The nightly build of main fails on MySQL 8.0 and 8.4 (pipeline 111952, jobs “functional mysql 8.0 php 8.5 min 5/6” and “functional mysql 8.4 php 8.5 max 5/6”):

QueryingTest::findingPostsByTagNamesAndOrderingThemByTheirAuthorByExtbase throws “Expression #1 of ORDER BY clause is not in SELECT list, references column ‘…tx_blogexample_domain_model_person.lastname’ which is not in SELECT list; this is incompatible with DISTINCT”.

Extbase selects the posts with SELECT DISTINCT because of the MM join on the tags and orders by author.lastname, a column of a joined table that is not part of the select list. PostgreSQL rejects this for the same reason and the test already skips there (#92514). MySQL rejects it as well; MariaDB and SQLite accept it.

The ByExtbase test of this pair is skipped on MySQL as well.

Reviews 1

History 23

  1. Anonymous commented and changed status Under Review Resolved done 0 % 100 % <span data-processor="relativetime" data-value="2026-10-21T07:40:15+00:00" > 10/21/26, 07:40 </span>

    Applied in changeset commit:088ba436594f5ffed98d78a0e381043052e4b23a.