Issue Bug Closed

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

Markus Opahle 03/13/15, 11:33 updated 09/02/16, 17:52

Description

When building a query like this:

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

the querybuilder caches something like “… myproperty IN(:myproperty) …”

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.

Reviews 0

No change resolves or names this issue in its commit message, and no comment links one.