Issue Bug Rejected

#96065selectTree with ORDER BY using DBAL compatible quoting produces SQL errors

S P 11/24/21, 07:39 updated 11/24/21, 12:00

Description

Steps to reproduce:
  1. have a selectTree TCA field ( sys_category for example, but it happens with other tables as well)
  2. have a foreign_table_where condition containing for example ORDER BY {#sys_category}.{#title} ASC (or whetever your foreign table/field is), it does not matter if the foreign_table_where contains any more conditions or just the order statement alone
  3. open this record in the backend -> tree view is empty, saving or closing the edit panel shows red SQL error bar

Discovered on v10, probably valid on others as well.

Reviews 0

No change resolves or names this issue in its commit message, and no comment links one.