Project

General

Profile

Actions

Bug #25833

closed

LIMIT is not recognized in exec_query

Added by Thomas Koetter over 13 years ago. Updated about 6 years ago.

Status:
Closed
Priority:
Must have
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

Also available in: Atom PDF