Actions
Bug #85743
closed
An exception occurred if I click on List
Status:
Closed
Priority:
Must have
Assignee:
-
Category:
Database API (Doctrine DBAL)
Target version:
-
Start date:
2016-10-03
Due date:
2016-10-03
% Done:
0%
Estimated time:
TYPO3 Version:
9
PHP Version:
7.2
Tags:
postgres
Complexity:
Is Regression:
Yes
Sprint Focus:
Description
I have fresh installed TYPO3 9.3.3
If I click on List, I get an error message. See the screenshot.
I'm using PostgreSQL 9.5 as database
Files
Updated by Alexander Averbuch over 6 years ago
You should consider how to use ORDER BY and GROUP BY in PostgreSQL. There is a huge difference in comparison to MySQL
Updated by Stephan Großberndt over 6 years ago
- Tags set to postgres
- Is Regression set to Yes
Problem here is that the COUNT() statement must not use the ORDER BY and LIMIT.
Updated by Stephan Großberndt over 6 years ago
This is a regression from https://review.typo3.org/#/c/50083/10/typo3/sysext/recordlist/Classes/RecordList/DatabaseRecordList.php
Updated by Stephan Großberndt over 6 years ago
- Due date set to 2016-10-03
- Start date changed from 2018-08-03 to 2016-10-03
- Follows Bug #78129: Statement::rowCount not reliable for SELECT queries added
Updated by Alexander Averbuch over 6 years ago
yes, it makes no sense to use ORDER with COUNT. Also if using MySQL
Updated by Riccardo De Contardi about 6 years ago
- Category set to Database API (Doctrine DBAL)
Updated by Susanne Moog about 6 years ago
- Is duplicate of Bug #85359: BE-Pagebrowser broken added
Updated by Susanne Moog about 6 years ago
- Status changed from New to Resolved
This has been fixed with https://review.typo3.org/#/c/57347/ (for TYPO3 9.4.0 and later).
Updated by
Actions