ABORT THROWN BY INTERNAL EXCEPTION: Failed to bind column reference "c1" [33.9] (bindings: {#[8.0], #[8.1], #[8.2], #[8.3], #[9.0], #[9.1], #[9.2], #[10.0], #[10.1], #[10.2], #[10.3], #[10.4], #[10.5], #[12.0], #[12.1], #[55.0]})

[fuzzerofducks]

Issue found by SQLSmith on git commit hash dd9e6 using seed 467990859.

To Reproduce

create table all_types as select * exclude(small_enum, medium_enum, large_enum) from test_all_types() limit 0;
SELECT ref_2.nested_int_array AS c0, (SELECT NULL) AS c1 FROM main.all_types INNER JOIN (SELECT ref_1."bigint" AS c1 FROM main.all_types AS ref_1) AS subq_0 INNER JOIN main.all_types AS ref_2 INNER JOIN main.all_types AS ref_3 ON (NULL) INNER JOIN main.all_types AS ref_4 ON (ref_4."timestamp") INNER JOIN (SELECT ref_5."timestamp" AS c0, 42 AS c1 FROM main.all_types AS ref_5 WHERE ((SELECT NULL) ^@ NULL)) AS subq_1 ON (0) ON (EXISTS(SELECT NULL, subq_1.c0 AS c1, ref_4."bigint" AS c2, ref_6.fixed_nested_varchar_array AS c3, subq_0.c1 AS c4, ref_3.tinyint AS c5, ref_4.dec_9_4 AS c6 FROM main.all_types AS ref_6 , (SELECT ref_2.struct_of_fixed_array AS c0, subq_0.c1 AS c1, ref_7.bool AS c2, ref_7."union" AS c3, ref_3.fixed_nested_varchar_array AS c4, ref_4.time_tz AS c5, ref_4.ubigint AS c6, 41 AS c7, ref_6."interval" AS c8, ref_2.fixed_int_array AS c9, ref_6."float" AS c10, ref_6.hugeint AS c11 FROM main.all_types AS ref_7 WHERE (ref_4."varchar" ~~~ ref_6."varchar")) AS subq_2 WHERE 0)) ON ((ref_3."varchar" ~~* ref_2."varchar")) LIMIT 123

Error Message

ABORT THROWN BY INTERNAL EXCEPTION: Failed to bind column reference "c1" [33.9] (bindings: {#[8.0], #[8.1], #[8.2], #[8.3], #[9.0], #[9.1], #[9.2], #[10.0], #[10.1], #[10.2], #[10.3], #[10.4], #[10.5], #[12.0], #[12.1], #[55.0]})