Actions
Bug #25833
closedLIMIT is not recognized in exec_query
Status:
Closed
Priority:
Must have
Assignee:
Category:
Database API (Doctrine DBAL)
Target version:
-
Start date:
2011-04-07
Due date:
% Done:
100%
Estimated time:
TYPO3 Version:
PHP Version:
Tags:
Complexity:
Is Regression:
Sprint Focus:
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'] : '';
Actions