Project

General

Profile

Actions

Bug #81272

closed

Parameters in real raw extbase queries do not get replaced

Added by Daniel Goerz almost 7 years ago. Updated over 5 years ago.

Status:
Closed
Priority:
Should have
Assignee:
Category:
Extbase
Target version:
-
Start date:
2017-05-19
Due date:
% Done:

100%

Estimated time:
TYPO3 Version:
8
PHP Version:
7.0
Tags:
Complexity:
Is Regression:
Yes
Sprint Focus:

Description

Sometimes it might be necessary to use real raw queries with parameter replacement in the context of extbase. Since the rewrite of the TYPO3DbBackend to support doctrine this last ressort is not working because we forgot to pass the parameter to the query execution. This functionality should not be used anyway but in case it is needed it should at least work.

Something like this should be enough to test it.


$sqlParamList = [];
$sqlQuery = 'Select * from <table> where <propert> = ?';
$sqlParamList[] = 123;
$query = $this->createQuery();
$query->statement($sqlQuery, $sqlParamList);
return $query->execute();


Related issues 2 (0 open2 closed)

Related to TYPO3 Core - Bug #67375: Typo3DbBackend in current extbase 7.2.0 doesnt replace the placeholder "?" with boundVariables in extbase 6.2 beforeClosed2015-06-09

Actions
Related to TYPO3 Core - Task #77624: Use DBAL abstraction for Extbase raw queriesClosedBenni Mack2016-08-24

Actions
Actions #1

Updated by Daniel Goerz almost 7 years ago

  • Related to Bug #67375: Typo3DbBackend in current extbase 7.2.0 doesnt replace the placeholder "?" with boundVariables in extbase 6.2 before added
Actions #2

Updated by Gerrit Code Review almost 7 years ago

  • Status changed from New 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/52863

Actions #3

Updated by Daniel Goerz almost 7 years ago

  • Related to Task #77624: Use DBAL abstraction for Extbase raw queries added
Actions #4

Updated by Gerrit Code Review almost 7 years ago

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

Actions #5

Updated by Anonymous almost 7 years ago

  • Status changed from Under Review to Resolved
  • % Done changed from 0 to 100
Actions #6

Updated by Benni Mack over 5 years ago

  • Status changed from Resolved to Closed
Actions

Also available in: Atom PDF