Project

General

Profile

Actions

Bug #65714

closed

Wrong query cache entry when using "in" constraint with null value

Added by Markus Opahle about 9 years ago. Updated over 7 years ago.

Status:
Closed
Priority:
Must have
Assignee:
-
Category:
Database API (Doctrine DBAL)
Target version:
-
Start date:
2015-03-13
Due date:
% Done:

0%

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

Description

When building a query like this:

$query->matching($query->in('mypropery', array(1,2)));

the querybuilder caches something like "... myproperty IN ..."

When building a query like this:

$query->matching($query->in('mypropery', null));

the querybuilder caches something like "... 1<>1 ..." under the same identifier as above.

This leeds to errors / empty results when the value of the constraint changes from null value to non null values or vice versa.


Related issues 1 (0 open1 closed)

Related to TYPO3 Core - Task #77460: Drop extbase query cacheClosedBenni Mack2016-08-09

Actions
Actions #1

Updated by Morton Jonuschat over 7 years ago

  • Status changed from New to Closed

Extbase QueryCache has been removed in TYPO3 8.3, implicitly fixing this bug.

Actions

Also available in: Atom PDF