Project

General

Profile

Actions
Copy link

Bug #30580

closed

Simple search (SEARCHRESULT) doesn't work with Oracle

Added by Bart Dubelaar about 13 years ago. Updated almost 10 years ago.

Status:
Closed
Priority:
Should have
Assignee:
-
Category:
Database API (Doctrine DBAL)
Target version:
-
Start date:
2011-10-05
Due date:
% Done:

0%

Estimated time:
TYPO3 Version:
4.5
PHP Version:
Tags:
Complexity:
Is Regression:
Sprint Focus:

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.

Actions
Copy link

Also available in: Atom PDF