ABORT THROWN BY INTERNAL EXCEPTION: Failed to bind column reference "c0" [60.3] (bindings: {#[73.0], #[73.1], #[73.2], #[73.3], #[73.4], #[73.5], #[73.6], #[73.7], #[73.8], #[73.9], #[73.10]})

[fuzzerofducks]

Issue found by SQLSmith on git commit hash 950d7 using seed 236898338.

To Reproduce

create table all_types as select * exclude(small_enum, medium_enum, large_enum) from test_all_types();
SELECT NULL FROM main.all_types AS ref_0 , (SELECT ref_0.fixed_nested_int_array AS c0, ref_0.int_array AS c1, ref_0."smallint" AS c2, ref_0."timestamp" AS c3, ref_0.uhugeint AS c6 FROM main.all_types AS ref_1 WHERE EXISTS(SELECT NULL, ref_0.usmallint AS c1, NULL FROM main.all_types AS ref_2 INNER JOIN main.all_types AS ref_3 INNER JOIN main.all_types AS ref_4 ON (NULL) ON (NULL) , (SELECT ref_1.fixed_varchar_array AS c0, ref_0.timestamp_s AS c1 FROM main.all_types AS ref_5 WHERE (ref_3.usmallint IS NOT NULL)) , (SELECT (SELECT date FROM main.all_types LIMIT 1 OFFSET 2) AS c0, subq_1.c0 AS c1 FROM main.all_types AS ref_6 , (SELECT ref_4.dec_9_4 AS c0 FROM main.all_types AS ref_7 WHERE ((ref_7."varchar" !~~* ref_4."varchar") AND (ref_3."varchar" ~~~ ref_7."varchar")) LIMIT 129) AS subq_1 , (SELECT ref_8."bigint" AS c0, ref_8.tinyint AS c1, subq_1.c0 AS c2, ref_4.timestamp_array AS c3, (SELECT "interval" FROM main.all_types LIMIT 1 OFFSET 48) AS c4, 16 AS c5, ref_0.fixed_array_of_int_list AS c6, ref_3.tinyint AS c7, ref_6.timestamp_ns AS c8, ref_0.hugeint AS c9 FROM main.all_types AS ref_8 WHERE ((ref_1."varchar" ~~~ ref_0."varchar") OR (ref_0."varchar" !~~* (SELECT "varchar" FROM main.all_types LIMIT 1 OFFSET 2))) LIMIT 109) AS subq_2 WHERE 0 LIMIT 91) AS subq_3 WHERE 0) LIMIT 142)

Error Message

ABORT THROWN BY INTERNAL EXCEPTION: Failed to bind column reference "c0" [60.3] (bindings: {#[73.0], #[73.1], #[73.2], #[73.3], #[73.4], #[73.5], #[73.6], #[73.7], #[73.8], #[73.9], #[73.10]})