Bug #43262: Prevent statements with count() and order by parts for PostgrSQL - TYPO3 Core - TYPO3 Forge

Custom queries

12 LTS
Accessibility
Dashboard issues
Easy tasks
Extbase Issues
FAL Issues
FAL Sprint 2023
Hierarchical Issues
Issues reported for v11
JavaScript issues
JavaScript Issues (w/o Epics/Stories)
Most wanted Bugfixes
Most wanted Features
My open issues
New & Unassigned
No feedback within 90 days
Open Bugs
Open issues of 10
Page Tree Regressions after 2020-07-28
Recently modified
Regressions
Stabilization Issues
Usability or UX

Actions

Copy link

Bug #43262

closed

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

Added by Nicole Cordes over 11 years ago. Updated over 6 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:

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.

History
Notes
Property changes
Associated revisions

Actions

Copy link

Updated by Gerrit Code Review over 11 years ago

Patch set 1 for branch master has been pushed to the review server.
It is available at http://review.typo3.org/16704

Actions

Copy link

Updated by Gerrit Code Review almost 11 years ago

Patch set 1 for branch master has been pushed to the review server.
It is available at https://review.typo3.org/21091

Actions

Copy link

Updated by Michael Stucki over 10 years ago

Category deleted (~~PostgreSQL~~)

Actions

Copy link

Updated by Michael Stucki over 10 years ago

Project changed from 329 to TYPO3 Core

Actions

Copy link

Updated by Michael Stucki over 10 years ago

Category set to 999

Actions

Copy link

Updated by Mathias Schreiber about 9 years ago

Target version changed from 6.0.0 to 8 LTS
Is Regression set to No

Actions

Copy link

Updated by Gerrit Code Review about 9 years ago

Status changed from New to Under Review

Patch set 2 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at http://review.typo3.org/21091

Actions

Copy link

Updated by Gerrit Code Review about 9 years ago

Patch set 3 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at http://review.typo3.org/21091

Actions

Copy link

Updated by Gerrit Code Review about 9 years ago

Patch set 4 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at http://review.typo3.org/21091

Actions

Copy link

#10

Updated by Gerrit Code Review about 9 years ago

Patch set 5 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at http://review.typo3.org/21091

Actions

Copy link

#11

Updated by Gerrit Code Review almost 9 years ago

Patch set 6 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at http://review.typo3.org/21091

Actions

Copy link

#12

Updated by Gerrit Code Review almost 9 years ago

Patch set 7 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at http://review.typo3.org/21091

Actions

Copy link

#13

Updated by Gerrit Code Review almost 9 years ago

Patch set 8 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at http://review.typo3.org/21091

Actions

Copy link

#14

Updated by Gerrit Code Review almost 9 years ago

Patch set 9 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at http://review.typo3.org/21091

Actions

Copy link

#15