Issue Bug Closed

#25833LIMIT is not recognized in exec_query

Thomas Koetter 04/07/11, 19:02 updated 10/02/18, 12:20

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’] : ‘’;

Reviews 0

No change resolves or names this issue in its commit message, and no comment links one.