Issue found by SQLSmith on git commit hash 50bb6 using seed 859382608.
To Reproduce
create table all_types as select * exclude(small_enum, medium_enum, large_enum) from test_all_types();
SELECT NULL FROM (SELECT ref_2.blob AS c0 FROM main.all_types INNER JOIN main.all_types AS ref_1 INNER JOIN main.all_types AS ref_2 INNER JOIN main.all_types AS ref_3 ON (NULL) ON (NULL) ON (NULL) RIGHT JOIN main.all_types AS ref_4 INNER JOIN main.all_types AS ref_5 ON (EXISTS(SELECT NULL, 36 AS c1, NULL, NULL, NULL FROM main.all_types AS ref_6 WHERE (EXISTS(SELECT ref_4.ubigint AS c1, ref_5.time_tz AS c2) AND (ref_4."varchar" ~~* ref_6."varchar") AND (ref_5."varchar" ~~ ref_5."varchar") AND 0 AND 1 AND (ref_6."varchar" ~~* ref_5."varchar") AND (ref_5."varchar" ~~* ref_6."varchar")) LIMIT 67)) INNER JOIN main.all_types AS ref_8 LEFT JOIN main.all_types AS ref_9 ON ((ref_8.usmallint IS NOT NULL)) INNER JOIN main.all_types AS ref_10 ON ((1 OR (ref_8."varchar" !~~* CAST(NULL AS VARCHAR)))) ON ((ref_5.struct_of_arrays = ref_10.struct_of_arrays)) ON ((ref_3."varchar" !~~ ref_4."varchar")) LIMIT 31) AS subq_0 INNER JOIN main.all_types AS ref_12 ON ((subq_0.c0 = ref_12.blob)) LIMIT 51
Error Message
ABORT THROWN BY INTERNAL EXCEPTION: Failed to bind column reference "c1" [7.5] (bindings: {#[5.0], #[5.1], #[5.2], #[20.0], #[20.1], #[21.0]})
Issue found by SQLSmith on git commit hash 50bb6 using seed 859382608.
To Reproduce
Error Message