588
-- test incorrect handling of placeholders that only appear in targetlists,
592
( SELECT 1 as key1 ) sub1
594
( SELECT sub3.key3, sub4.value2, COALESCE(sub4.value2, 66) as value3 FROM
595
( SELECT 1 as key3 ) sub3
597
( SELECT sub5.key5, COALESCE(sub6.value1, 1) as value2 FROM
598
( SELECT 1 as key5 ) sub5
600
( SELECT 2 as key6, 42 as value1 ) sub6
601
ON sub5.key5 = sub6.key6
603
ON sub4.key5 = sub3.key3
605
ON sub1.key1 = sub2.key3;
607
-- test the path using join aliases, too
609
( SELECT 1 as key1 ) sub1
611
( SELECT sub3.key3, value2, COALESCE(value2, 66) as value3 FROM
612
( SELECT 1 as key3 ) sub3
614
( SELECT sub5.key5, COALESCE(sub6.value1, 1) as value2 FROM
615
( SELECT 1 as key5 ) sub5
617
( SELECT 2 as key6, 42 as value1 ) sub6
618
ON sub5.key5 = sub6.key6
620
ON sub4.key5 = sub3.key3
622
ON sub1.key1 = sub2.key3;
588
625
-- test the corner cases FULL JOIN ON TRUE and FULL JOIN ON FALSE
590
627
select * from int4_tbl a full join int4_tbl b on true;