Issue Bug Closed

#110197Feature: #32051 - Extbase query expression builder for orderings generate invalid SQL

Tee Ohh 07/15/26, 08:50 updated 08/11/26, 08:51

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

History 47

  1. Garvin Hicking commented and changed status New Accepted <span data-processor="relativetime" data-value="2026-07-16T17:51:10+00:00" > 07/16/26, 17:51 </span>

    Oh, indeed. The tests are not tight enough.

  2. Gerrit Code Review pushed patch set 1 for main to change 94801 status Accepted Under Review <span data-processor="relativetime" data-value="2026-07-16T18:23:58+00:00" > 07/16/26, 18:23 </span>

  3. Garvin Hicking commented and changed status Under Review Resolved done 0 % 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.