Issue found by SQLSmith on git commit hash dd9e6 using seed 565199668.
To Reproduce
create table all_types as select * exclude(small_enum, medium_enum, large_enum) from test_all_types();
SELECT ref_0.dec_18_6 FROM main.all_types AS ref_0 INNER JOIN main.all_types AS ref_1 INNER JOIN main.all_types AS ref_2 ON (NULL) RIGHT JOIN main.all_types AS ref_3 INNER JOIN main.all_types AS ref_4 ON (ref_4."varchar") ON (((SELECT NULL) !~~ NULL)) INNER JOIN (SELECT ref_5.int_array AS c0, ref_5.dec_18_6 AS c1 FROM main.all_types AS ref_5 WHERE NULL LIMIT 154) AS subq_0 ON ((ref_3.int_array = subq_0.c0)) ON ((ref_0.blob = ref_1.blob)) INNER JOIN (SELECT NULL, ref_6.timestamp_tz AS c1 FROM main.all_types AS ref_6 WHERE (ref_6."varchar" !~~ ref_6."varchar") LIMIT 96) ON (((ref_2."varchar" !~~* ref_0."varchar") AND EXISTS(SELECT ref_2.fixed_array_of_int_list AS c0, ref_7.blob AS c1, subq_2.c1 AS c2 FROM main.all_types AS ref_7 , (SELECT ref_4."float" AS c0, subq_0.c1 AS c1 FROM main.all_types AS ref_8 WHERE (ref_4."varchar" ~~~ CAST(NULL AS VARCHAR)) LIMIT 159) AS subq_2 WHERE (ref_4."varchar" !~~ ref_3."varchar")))) LIMIT 38
Error Message
ABORT THROWN BY INTERNAL EXCEPTION: Failed to bind column reference "c0" [4.1] (bindings: {#[0.0], #[0.1], #[0.2], #[13.0], #[13.1], #[20.0], #[20.1]})
Issue found by SQLSmith on git commit hash dd9e6 using seed 565199668.
To Reproduce
Error Message