Project

General

Profile

Actions

Bug #63275

closed

Typo3DbQueryParser generates broken SQL for array in CONTAINS-comparison

Added by Stefan Neufeind about 10 years ago. Updated almost 10 years ago.

Status:
Closed
Priority:
Should have
Category:
Extbase
Target version:
-
Start date:
2014-11-23
Due date:
% Done:

100%

Estimated time:
TYPO3 Version:
6.2
PHP Version:
Tags:
Complexity:
Is Regression:
No
Sprint Focus:

Description

When passing an array for a "contains"-comparison Typo3DbQueryParser generates SQL like:

[...] FROM  sys_category_record_mm WHERE uid_local='1','3' AND tablenames = [...]

which simply needs an "IN" statement for the operand2.


Related issues 2 (0 open2 closed)

Related to TYPO3 Core - Bug #64044: Revert fix for #63275 until concept is worked out and agreed uponClosed2014-12-26

Actions
Is duplicate of TYPO3 Core - Feature #7848: Support array / multiple values in $query->containsClosed2010-05-212010-06-04

Actions
Actions

Also available in: Atom PDF