IN
, = ANY
and = SOME
with indexed subselect
Let A
be the expression on the left-hand side and S
the result set of the subselect.In versions prior to 2.0, “IN
”, “= ANY
” and “= SOME
” return false instead of NULL
if an index is active on the subselect column and:
-
either
A
isNULL
andS
doesn’t contain anyNULL
s; -
or
A
is notNULL
,A
is not found inS
, andS
contains at least oneNULL
.