[TYPO3-core] indexed_search breaks on PostgreSQL

Martin Kutschker martin.kutschker-n0spam at no5pam-blackbox.net
Thu Nov 16 21:57:53 CET 2006


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.

Comitted.

The indexed search in 4.0.3 is now at version 2.9.3, in 4.1 at 2.10.0

Masi



More information about the TYPO3-team-core mailing list