One-Time Filter: ("*VALUES*".column1 = "*VALUES*".column1)

(8 rows)

--

-- Check we don't misoptimize a NOT IN where the subquery returns no rows.

--

create temp table notinouter (a int);

create temp table notininner (b int not null);

insert into notinouter values (null), (1);

select * from notinouter where a not in (select b from notininner);

a

---

1

(2 rows)

--

-- Check we behave sanely in corner case of empty SELECT list (bug #8648)

--

select x, xfrom

(select (select random()where y=y)as xfrom (values(1),(2)) v(y)) ss;

create temp table notinouter (aint);

create temp table notininner (bintnot null);

insert into notinoutervalues (null), (1);

select*from notinouterwhere a notin (select bfrom notininner);