Issue Bug Closed

#30580Simple search (SEARCHRESULT) doesn't work with Oracle

Bart Dubelaar 10/05/11, 17:06 updated 12/04/14, 16:23

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.