[TYPO3-core] indexed_search breaks on PostgreSQL

[Martin Kutschker]

Martin Kutschker schrieb:
> Hi!
> 
> The "final" query of the search "execFinalQuery()" seems to have relied 
> originally on a Mysql peculiarity. It used columns in the SELECT clause 
> that were neither part of an aggregate function nor listed in the GROUP 
> BY clause. AFAIK this is non-standard and works only on Mysql.
> 
> To resolve this someone added ALL columns of index_phash to the SELECT 
> clause. That is all but one: freeIndexSetId.
> 
> So now the statement is broken.
> 
> For 4.0 I suggest to add freeIndexSetId to GROUP BY. This works fine on 
> PostgreSQL and the indexed search works again.

Here's the diff.

Masi
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: tx_indexedsearch-DBAL.diff
Url: http://lists.netfielders.de/pipermail/typo3-team-core/attachments/20061109/0e7c5cfa/attachment.diff