Issue found by SQLSmith on git commit hash dd9e6 using seed 452003027.
To Reproduce
create table all_types as select * exclude(small_enum, medium_enum, large_enum) from test_all_types() limit 0;
SELECT ref_4.uhugeint AS c2, arg_min(NULL, NULL) OVER (PARTITION BY NULL, NULL ORDER BY ref_4.fixed_nested_varchar_array) AS c9 FROM main.all_types LEFT JOIN main.all_types AS ref_1 INNER JOIN main.all_types AS ref_2 ON (NULL) INNER JOIN main.all_types AS ref_3 ON (NULL) INNER JOIN main.all_types AS ref_4 ON (ref_4."union") ON (EXISTS(SELECT NULL, ref_3."int" AS c1, ref_4.dec_18_6 AS c2, NULL, ref_4."struct" AS c4, NULL WHERE (ref_1."varchar" ^@ CAST(NULL AS VARCHAR)))) RIGHT JOIN main.all_types AS ref_6 ON ((ref_3."varchar" ~~* ref_1."varchar")) INNER JOIN (SELECT ref_8.uuid AS c0, (SELECT "varchar" FROM main.all_types LIMIT 1 OFFSET 1) AS c1, ref_7.array_of_structs AS c2, "version"() AS c3, ref_8.timestamp_s AS c4, ref_7.list_of_fixed_int_array AS c5, ref_8."bigint" AS c6 FROM main.all_types AS ref_7 LEFT JOIN main.all_types AS ref_8 ON ((ref_8."varchar" ~~* ref_8."varchar")) WHERE (ref_7."varchar" ^@ ref_7."varchar") LIMIT 88) AS subq_0 ON (((subq_0.c4 IS NULL) AND (ref_3."varchar" ~~ subq_0.c3))) WHERE ref_4."varchar" LIMIT 133
Error Message
ABORT THROWN BY INTERNAL EXCEPTION: Failed to bind column reference "c1" [6.6] (bindings: {#[4.0], #[4.1], #[4.2], #[4.3], #[4.4], #[4.5]})
Issue found by SQLSmith on git commit hash dd9e6 using seed 452003027.
To Reproduce
Error Message