> Could one comment on this?
> My initial tests says it works, with two (one for the lookup and one for
> the IS NULL) indexed access in the inner stream. ;-)
> But I may completely missing something. :-)
Does your tests cover all possible cases ? With NULL's in both
"things" and "somethings". I.e.
a) value not in (value, value, ... , value)
b) value not in (value, null, ... , value)
c) null not in (value, value, ... , value)
d) null not in (value, null, ... , value)
In cases (a) and (c) there is no NULLs in "NOT IN" list while
in cases (b) and (d) there is NULLs in "NOT IN" list.