Project

General

Profile

Actions
Copy link

Bug #65789

closed

Extbase: Wrong SQL statement when using Offset and no Limit

Added by Eric no-lastname-given about 9 years ago. Updated over 5 years ago.

Status:
Closed
Priority:
Should have
Assignee:
Ian SEBBAGH
Category:
Extbase
Target version:
Candidate for patchlevel
Start date:
2015-03-17
Due date:
% Done:

100%

Estimated time:
TYPO3 Version:
7
PHP Version:
Tags:
Complexity:
Is Regression:
No
Sprint Focus:
On Location Sprint

Description

When building a query with OFFSET but no LIMIT, this line in

TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend

protected function createQueryCommandParametersFromStatementParts(array $statementParts):

321:  'limit' => ($statementParts['offset'] ? $statementParts['offset'] . ', ' : '')
322:     . ($statementParts['limit'] ? $statementParts['limit'] : '')

produces an SQL Error, because the SQL ends with a comma: ...DESC LIMIT 3,

It should only add a comma, when there is a OFFSET and a LIMIT

Actions
Copy link
 #1

Updated by Tommy Bley over 8 years ago

plz fix it

Actions
Copy link
 #2

Updated by B. Kausch over 8 years ago

  • Target version set to 6.2.16

Serious Bug. Already exists in 6.2 ...

Actions
Copy link
 #3

Updated by Riccardo De Contardi about 8 years ago

  • Category set to Extbase
  • Target version changed from 6.2.16 to Candidate for patchlevel
Actions
Copy link
 #4

Updated by Ian SEBBAGH almost 8 years ago

  • Assignee set to Ian SEBBAGH
  • Sprint Focus set to On Location Sprint
Actions
Copy link
 #5

Updated by Ian SEBBAGH almost 8 years ago

  • Status changed from New to In Progress
Actions
Copy link
 #6

Updated by Gerrit Code Review almost 8 years ago

  • Status changed from In Progress to Under Review

Patch set 1 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/48461

Actions
Copy link
 #7

Updated by Gerrit Code Review almost 8 years ago

Patch set 2 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/48461

Actions
Copy link
 #8

Updated by Gerrit Code Review almost 8 years ago

Patch set 3 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/48461

Actions
Copy link
 #9

Updated by Gerrit Code Review almost 8 years ago

Patch set 4 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/48461

Actions
Copy link
 #10

Updated by Gerrit Code Review almost 8 years ago

Patch set 5 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/48461

Actions
Copy link
 #11

Updated by Gerrit Code Review almost 8 years ago

Patch set 6 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/48461

Actions
Copy link
 #12

Updated by Gerrit Code Review almost 8 years ago

Patch set 1 for branch TYPO3_7-6 of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/48473

Actions
Copy link
 #13

Updated by Ian SEBBAGH almost 8 years ago

  • Status changed from Under Review to Resolved
  • % Done changed from 0 to 100
Actions
Copy link
 #14

Updated by Gerrit Code Review almost 8 years ago

  • Status changed from Resolved to Under Review

Patch set 2 for branch TYPO3_7-6 of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/48473

Actions
Copy link
 #15

Updated by Gerrit Code Review almost 8 years ago

Patch set 1 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/48475

Actions
Copy link
 #16

Updated by Gerrit Code Review almost 8 years ago

Patch set 3 for branch TYPO3_7-6 of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/48473

Actions
Copy link
 #17

Updated by Ian SEBBAGH almost 8 years ago

  • Status changed from Under Review to Resolved
Actions
Copy link
 #18

Updated by Benni Mack over 5 years ago

  • Status changed from Resolved to Closed
Actions
Copy link

Also available in: Atom PDF