#30580Simple search (SEARCHRESULT) doesn't work with Oracle
Description
The query constructed in tslib_search is incompatible with Oracle due to the GROUP BY. In Oracle all elements in the SELECT statement should be present in the GROUP BY statement (ORA-00979). Because aliases are used in the SELECT there is no simple solution. The query should be redesigned with the use of sub queries, or grouping should happen in postprocessing. Maybe a generic solution should be made in DBAL.
Reviews 0
No change resolves or names this issue in its commit message, and no comment links one.