Project

General

Profile

Actions
Copy link

Bug #43262

closed

Prevent statements with count() and order by parts for PostgrSQL

Added by Nicole Cordes almost 12 years ago. Updated about 7 years ago.

Status:
Closed
Priority:
Must have
Assignee:
-
Category:
Database API (Doctrine DBAL)
Target version:
8 LTS
Start date:
2012-11-24
Due date:
% Done:

100%

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

Description

In PostgreSQL it is not allowed to use a COUNT statement with an ORDER BY statement as long as the field for sorting not available in GROUP BY clause. Therefor we have to parse the SQL and drop ORDER BY clause for selections with a count.

IMHO this is an important fix as otherwise it is not possible the use all the features from extbase. I got an error while using the Backend user extension provided by the current master.

Actions
Copy link

Also available in: Atom PDF