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 #1

Updated by Xavier Perseguers over 13 years ago

  • Status changed from New to Accepted

Actually this statement is wrong and your fix is correct.

Actions #2

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

Actions #3

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

Actions #4

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

Actions #5

Updated by Xavier Perseguers over 13 years ago

  • Assignee set to Xavier Perseguers
Actions #6

Updated by Xavier Perseguers over 13 years ago

  • Status changed from Accepted to Resolved
  • % Done changed from 0 to 100
Actions #7

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))
Actions #8

Updated by Michael Stucki almost 11 years ago

  • Category set to 999
Actions #9

Updated by Benni Mack about 6 years ago

  • Status changed from Resolved to Closed
Actions

Also available in: Atom PDF