Issue found by SQLSmith on git commit hash 50bb6 using seed 374003709.
To Reproduce
call dbgen(sf=0.1);
SELECT NULL FROM (SELECT ref_1.o_totalprice AS c0, ref_1.o_totalprice AS c1, 11 AS c2, ref_0.n_regionkey AS c3, ref_0.n_name AS c4, ref_1.o_shippriority AS c5, ref_1.o_orderpriority AS c6 FROM main.nation AS ref_0 INNER JOIN main.orders AS ref_1 ON ((ref_1.o_orderpriority ^@ ref_1.o_comment)) WHERE ((ref_1.o_orderstatus ^@ ref_0.n_name) AND (ref_1.o_comment !~~ (SELECT ps_comment FROM main.partsupp LIMIT 1 OFFSET 68)) AND 1) LIMIT 148) AS subq_0 INNER JOIN main.nation AS ref_2 INNER JOIN main.partsupp AS ref_3 RIGHT JOIN main.customer AS ref_4 ON ((ref_3.ps_comment IS NOT NULL)) LEFT JOIN main.orders AS ref_5 LEFT JOIN main.lineitem AS ref_6 ON ((1 OR (ref_6.l_partkey IS NOT NULL) OR 1)) ON ((ref_3.ps_supplycost = ref_5.o_totalprice)) ON (EXISTS(SELECT ref_4.c_name AS c0, ref_5.o_orderpriority AS c1, ref_5.o_orderpriority AS c2, ref_5.o_orderdate AS c3, subq_1.c0 AS c4, ref_3.ps_suppkey AS c5, 36 AS c6, ref_7.l_commitdate AS c7, ref_3.ps_comment AS c8, subq_1.c2 AS c9 FROM main.lineitem AS ref_7 , (SELECT ref_4.c_phone AS c0, ref_4.c_custkey AS c1, ref_2.n_nationkey AS c2 FROM main.customer AS ref_8 WHERE 0 LIMIT 111) AS subq_1 WHERE (ref_2.n_comment !~~ subq_1.c0) LIMIT 91)) ON ((subq_0.c1 = ref_4.c_acctbal)) RIGHT JOIN main.partsupp AS ref_9 ON ((ref_4.c_mktsegment = ref_9.ps_comment))
Error Message
ABORT THROWN BY INTERNAL EXCEPTION: Failed to bind column reference "c0" [17.0] (bindings: {#[15.0], #[15.1]})
Issue found by SQLSmith on git commit hash 50bb6 using seed 374003709.
To Reproduce
Error Message