#110197Feature: #32051 - Extbase query expression builder for orderings generate invalid SQL
Description
The new feature #32051 doesn’t work properly. The generated SQL failed to execute. It looks like this:
SELECT `tx_extkey_domain_model_table`.* FROM `tx_extkey_domain_model_table` WHERE ((`tx_extkey_domain_model_table`.`field` = :dcValue1) AND (`tx_extkey_domain_model_table`.`uid` > :dcValue2) AND (((`tx_extkey_domain_model_table`.`endtime` = 0) OR (`tx_extkey_domain_model_table`.`endtime` > 1784104980)))) ORDER BY ```tx_extkey_domain_model_table```.```tstamp``` DESC LIMIT 1
The order by field has 3 backticks.
Reviews 2
Related issues 1
History 47
-
Garvin Hicking commented and changed status
NewAccepted <span data-processor="relativetime" data-value="2026-07-16T17:51:10+00:00" > 07/16/26, 17:51 </span> -
Garvin Hicking changed Related to #32051 <span data-processor="relativetime" data-value="2026-07-16T17:52:59+00:00" > 07/16/26, 17:52 </span>
-
Gerrit Code Review pushed patch set 1 for main to change 94801 status
AcceptedUnder Review <span data-processor="relativetime" data-value="2026-07-16T18:23:58+00:00" > 07/16/26, 18:23 </span> -
Gerrit Code Review pushed patch set 2 for main to change 94801 <span data-processor="relativetime" data-value="2026-07-16T18:50:06+00:00" > 07/16/26, 18:50 </span>
-
Gerrit Code Review pushed patch set 1 for 14.3 to change 94828 <span data-processor="relativetime" data-value="2026-07-17T20:32:14+00:00" > 07/17/26, 20:32 </span>
-
Garvin Hicking commented and changed status
Under ReviewResolved done0 %100 % <span data-processor="relativetime" data-value="2026-07-17T20:50:09+00:00" > 07/17/26, 20:50 </span>Applied in changeset commit:95be482ab368db97b707cc5f041328d5f023f916.
-
Benni Mack changed status
ResolvedClosed <span data-processor="relativetime" data-value="2026-08-11T08:51:05+00:00" > 08/11/26, 08:51 </span>
Oh, indeed. The tests are not tight enough.