#111186Skip ordering by a joined field with DISTINCT in QueryingTest on MySQL
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
Related issues 1
History 23
-
Alexander Schnitzler changed Related to #111172 <span data-processor="relativetime" data-value="2026-10-21T06:47:11+00:00" > 10/21/26, 06:47 </span>
-
Gerrit Code Review pushed patch set 1 for main to change 96960 status
NewUnder Review <span data-processor="relativetime" data-value="2026-10-21T06:49:29+00:00" > 10/21/26, 06:49 </span> -
Anonymous commented and changed status
Under ReviewResolved done0 %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.