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