661
661
INNER JOIN tenk1 c ON qq = unique2;
664
-- nested nestloops can require nested PlaceHolderVars
667
create temp table nt1 (
672
create temp table nt2 (
677
foreign key (nt1_id) references nt1(id)
679
create temp table nt3 (
683
foreign key (nt2_id) references nt2(id)
686
insert into nt1 values (1,true,true);
687
insert into nt1 values (2,true,false);
688
insert into nt1 values (3,false,false);
689
insert into nt2 values (1,1,true,true);
690
insert into nt2 values (2,2,true,false);
691
insert into nt2 values (3,3,false,false);
692
insert into nt3 values (1,1,true);
693
insert into nt3 values (2,2,false);
694
insert into nt3 values (3,3,true);
700
(select nt2.*, (nt2.b1 and ss1.a3) AS b3
703
(select nt1.*, (nt1.id is not null) as a3 from nt1) as ss1
704
on ss1.id = nt2.nt1_id
706
on ss2.id = nt3.nt2_id
707
where nt3.id = 1 and ss2.b3;
712
(select nt2.*, (nt2.b1 and ss1.a3) AS b3
715
(select nt1.*, (nt1.id is not null) as a3 from nt1) as ss1
716
on ss1.id = nt2.nt1_id
718
on ss2.id = nt3.nt2_id
719
where nt3.id = 1 and ss2.b3;
664
722
-- test case where a PlaceHolderVar is propagated into a subquery