Issue found by SQLSmith on git commit hash dd9e6 using seed 89083167.
To Reproduce
call dbgen(sf=0.1);
SELECT (SELECT n_comment FROM main.nation LIMIT 1 OFFSET 5) AS c7, subq_0.c0 AS c8, CASE WHEN (EXISTS(SELECT subq_0.c1 AS c0, subq_1.c0 AS c1 FROM (SELECT 44 AS c0 FROM main.lineitem AS ref_3 RIGHT JOIN main.nation AS ref_4 ON (1) WHERE ((ref_4.n_comment !~~* ref_3.l_shipinstruct) AND EXISTS(SELECT subq_0.c0 AS c0, ref_4.n_comment AS c1, ref_5.ps_availqty AS c2, ref_5.ps_supplycost AS c3, subq_0.c0 AS c4 FROM main.partsupp AS ref_5 WHERE 0)) LIMIT 189) AS subq_1 WHERE (subq_1.c0 IS NULL) LIMIT 145)) THEN (subq_0.c0) ELSE subq_0.c0 END AS c9, subq_0.c0 AS c10, subq_0.c0 AS c11, (SELECT c_phone FROM main.customer LIMIT 1 OFFSET 6) AS c12 FROM (SELECT ref_0.n_nationkey AS c0, ref_1.r_name AS c1 FROM main.nation AS ref_0 RIGHT JOIN main.region AS ref_1 ON ((ref_0.n_regionkey IS NOT NULL)) RIGHT JOIN main.supplier AS ref_2 ON ((0 OR (ref_1.r_comment IS NULL))) WHERE (ref_2.s_comment ~~~ writefile())) AS subq_0 WHERE (subq_0.c1 IS NULL) LIMIT 82
Error Message
ABORT THROWN BY INTERNAL EXCEPTION: Failed to bind column reference "c1" [31.6] (bindings: {#[53.0], #[53.1]})
Issue found by SQLSmith on git commit hash dd9e6 using seed 89083167.
To Reproduce
Error Message