Bug #25833
closedLIMIT is not recognized in exec_query
100%
Description
In the function exec_query in class.ux_t3lib_db.php under case 'SELECT' there's a line to set the LIMIT for a SELECT query:
$limit = isset($queryParts['LIMIT']) ? $this->SQLparser->compileWhereClause(['LIMIT'] : '';
This line always produces an empty value for $limit because $queryParts['LIMIT'] is an integer (at least when called through an extbase query) and compileWhereClause doesn't know how to handle it.
The following line would fix this issue:
$limit = isset($queryParts['LIMIT']) ? $queryParts['LIMIT'] : '';
Updated by Xavier Perseguers over 13 years ago
- Status changed from New to Accepted
Actually this statement is wrong and your fix is correct.
Updated by Mr. Hudson over 13 years ago
Patch set 1 of change Iead41e7734238abe7abfcf74f50e4624b27cb4eb has been pushed to the review server.
It is available at http://review.typo3.org/1501
Updated by Mr. Hudson over 13 years ago
Patch set 1 of change If9966a4a59a17690c482d3d979489850dcfe1b1b has been pushed to the review server.
It is available at http://review.typo3.org/1502
Updated by Mr. Hudson over 13 years ago
Patch set 1 of change I5efb65cebb2b91c36af5b8a3e619bf1264e39bbc has been pushed to the review server.
It is available at http://review.typo3.org/1503
Updated by Xavier Perseguers over 13 years ago
- Assignee set to Xavier Perseguers
Updated by Xavier Perseguers over 13 years ago
- Status changed from Accepted to Resolved
- % Done changed from 0 to 100
Updated by Michael Stucki almost 11 years ago
- Project changed from 329 to TYPO3 Core
- Target version deleted (
1.2.3 (TYPO3 4.5.x))