Issue found by SQLSmith on git commit hash 50bb6 using seed 827383486.
To Reproduce
create table all_types as select * exclude(small_enum, medium_enum, large_enum) from test_all_types() limit 0;
SELECT NULL FROM (SELECT (SELECT NULL) AS c0, json_object() AS c1, ref_7.uuid AS c2, ref_0.struct_of_fixed_array AS c3, (SELECT NULL) AS c4 FROM main.all_types AS ref_0 INNER JOIN main.all_types ON (NULL) INNER JOIN main.all_types AS ref_2 INNER JOIN main.all_types AS ref_3 ON (EXISTS(SELECT ref_2.dec_9_4 AS c0, ref_3."float" AS c1, (SELECT NULL FROM main.all_types LIMIT 1 OFFSET 87) AS c2, ref_2."float" AS c3 FROM main.all_types AS ref_4 WHERE (((ref_4."varchar" ~~* CAST(NULL AS VARCHAR)) OR 0) AND 1 AND (ref_4."varchar" ^@ (SELECT "varchar" FROM main.all_types LIMIT 1 OFFSET 6)) AND (ref_3."varchar" ~~ ref_4."varchar")) LIMIT 133)) INNER JOIN main.all_types AS ref_5 ON (EXISTS(SELECT ref_3."smallint" AS c0 FROM main.all_types AS ref_6 WHERE (ref_6.timestamp_ms IS NULL) LIMIT 101)) LEFT JOIN main.all_types AS ref_7 ON ((CAST(NULL AS VARCHAR) ~~~ ref_3."varchar")) ON ((ref_0.double_array = ref_5.double_array)) WHERE ref_3.timestamptz_array LIMIT 156) AS subq_0 , (SELECT subq_1.c18 AS c0 FROM (SELECT ref_8.timestamp_s AS c0, ref_9.timestamp_ms AS c1, subq_0.c3 AS c2, ref_9.int_array AS c3, ref_8."bit" AS c4, ref_9.uhugeint AS c5, ref_8.timestamptz_array AS c6, subq_0.c4 AS c7, ref_9.fixed_nested_varchar_array AS c8, ref_8."double" AS c9, ref_9.struct_of_fixed_array AS c10, ref_8.date_array AS c11, ref_8.timestamp_ms AS c12, ref_9.int_array AS c13, subq_0.c2 AS c14, ref_9.dec_9_4 AS c15, subq_0.c1 AS c16, ref_8.time_tz AS c17, subq_0.c2 AS c18, subq_0.c3 AS c19, ref_8.time_tz AS c20, ref_9.ubigint AS c21 FROM main.all_types AS ref_8 INNER JOIN main.all_types AS ref_9 ON (((ref_9."varchar" ~~~ ref_9."varchar") OR ((SELECT "varchar" FROM main.all_types LIMIT 1 OFFSET 3) ~~ ref_9."varchar"))) WHERE ((ref_9."varchar" !~~ ref_9."varchar") AND (ref_9."varchar" ~~* ref_9."varchar") AND 0) LIMIT 93) AS subq_1 WHERE (((SELECT "varchar" FROM main.all_types LIMIT 1 OFFSET 3) ~~~ (SELECT "varchar" FROM main.all_types LIMIT 1 OFFSET 5)) OR (((SELECT "varchar" FROM main.all_types LIMIT 1 OFFSET 6) ~~* CAST(NULL AS VARCHAR)) AND ((SELECT "varchar" FROM main.all_types LIMIT 1 OFFSET 5) ~~~ CAST(NULL AS VARCHAR)))) LIMIT 113) AS subq_2 , (SELECT subq_2.c0 AS c0, subq_0.c4 AS c1, subq_2.c0 AS c2, ref_10."union" AS c3, ref_10.uhugeint AS c4, subq_0.c0 AS c5, subq_0.c1 AS c6, ref_10.struct_of_fixed_array AS c7, subq_2.c0 AS c8, ref_10.timestamp_array AS c9, ref_10."double" AS c10, subq_2.c0 AS c11, ref_10.usmallint AS c12, (SELECT hugeint FROM main.all_types LIMIT 1 OFFSET 6) AS c13, subq_2.c0 AS c14, ref_10.timestamp_ns AS c15, subq_2.c0 AS c16, subq_0.c4 AS c17, subq_0.c0 AS c18, ref_10.time_tz AS c19 FROM main.all_types AS ref_10 WHERE (((ref_10."varchar" ~~ ref_10."varchar") AND ((SELECT "varchar" FROM main.all_types LIMIT 1 OFFSET 16) ~~~ ref_10."varchar")) OR ((SELECT varchar_array FROM main.all_types LIMIT 1 OFFSET 1) IS NULL)) LIMIT 67) AS subq_3 LIMIT 91
Error Message
ABORT THROWN BY INTERNAL EXCEPTION: Failed to bind column reference "c0" [5.5] (bindings: {#[3.0], #[3.1], #[3.2], #[3.3], #[25.0]})
Issue found by SQLSmith on git commit hash 50bb6 using seed 827383486.
To Reproduce
Error Message