Issue found by SQLSmith on git commit hash dd9e6 using seed 344804001.
To Reproduce
call dbgen(sf=0.1);
SELECT subq_0.c5 AS c6, "map"() AS c7, pi() AS c8, ref_3.ps_supplycost AS c9, ref_3.ps_supplycost AS c10, ref_3.ps_comment AS c11 FROM (SELECT ref_2.ps_supplycost AS c0, ref_2.ps_suppkey AS c1, ref_2.ps_comment AS c2, ref_2.ps_supplycost AS c3, ref_2.ps_partkey AS c4, ref_2.ps_supplycost AS c5, ref_2.ps_supplycost AS c6, ref_2.ps_suppkey AS c7, ref_2.ps_availqty AS c8 FROM main.partsupp AS ref_2 WHERE (ref_2.ps_comment ^@ CAST(NULL AS VARCHAR)) LIMIT 157) AS subq_0 INNER JOIN main.partsupp AS ref_3 ON (((((ref_3.ps_comment ~~ ref_3.ps_comment) AND ((ref_3.ps_supplycost IS NOT NULL) OR (subq_0.c2 ~~* subq_0.c2)) AND EXISTS(SELECT ref_4.ps_availqty AS c0, subq_0.c0 AS c1 FROM main.partsupp AS ref_4 WHERE EXISTS(SELECT ref_3.ps_supplycost AS c0, subq_0.c2 AS c1, ref_4.ps_availqty AS c2, ref_5.l_shipdate AS c3, ref_3.ps_supplycost AS c4, ref_4.ps_supplycost AS c5, ref_3.ps_availqty AS c6, subq_0.c5 AS c7, ref_3.ps_partkey AS c8 FROM main.lineitem AS ref_5 WHERE 0 LIMIT 30) LIMIT 164)) OR (ref_3.ps_comment IS NULL)) AND (subq_0.c8 IS NOT NULL))) WHERE 1 LIMIT 40
Error Message
ABORT THROWN BY INTERNAL EXCEPTION: Failed to bind column reference "c2" [16.11] (bindings: {#[29.0], #[29.1], #[29.2], #[29.3], #[29.4], #[29.5]})
Issue found by SQLSmith on git commit hash dd9e6 using seed 344804001.
To Reproduce
Error Message