Project

General

Profile

Actions
Copy link

Bug #85486

closed

cObj->searchWhere is broken using more than one search field

Added by Stefan Berger almost 6 years ago. Updated about 4 years ago.

Status:
Closed
Priority:
Must have
Assignee:
-
Category:
Database API (Doctrine DBAL)
Target version:
Candidate for patchlevel
Start date:
2018-07-05
Due date:
% Done:

100%

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

Description

Hi,

the OR-parts of the searchfields in the method cObj->searchWhere has to be grouped in parentheses like in TYPO3 7. Otherwise the complete search condition using the method could be misinterpreted.

Wrong result:

AND (tt_content.header LIKE '%sdf%') 
OR  (tt_content.subheader LIKE '%sdf%')

Right result:
AND ((tt_content.header  LIKE '%sdf%') 
OR   (tt_content.subheader LIKE '%sdf%'))

Thanks for fixing.

Related issues 1 (0 open — 1 closed)

Related to TYPO3 Core - Task #77455: Doctrine: Migrate ContentObjectRendererClosedMorton Jonuschat2016-08-09

Actions
Actions
Copy link

Also available in: Atom PDF