Issue found by SQLSmith on git commit hash 50bb6 using seed 312705445.
To Reproduce
create table all_types as select * exclude(small_enum, medium_enum, large_enum) from test_all_types() limit 0;
WITH jennifer_0 AS (SELECT subq_0.c6 AS c1 FROM (SELECT ref_0."int" AS c6, (SELECT NULL) AS c7 FROM main.all_types AS ref_0) AS subq_0 INNER JOIN (SELECT NULL WHERE (SELECT NULL) LIMIT 101) ON ((CAST(NULL AS VARCHAR) ~~~ (SELECT "varchar" FROM main.all_types LIMIT 1 OFFSET 4))) INNER JOIN (SELECT 66 AS c0, (SELECT date_array FROM main.all_types LIMIT 1 OFFSET 6) AS c1, ref_2."struct" AS c2, ref_2.struct_of_arrays AS c3, ref_2.timestamp_array AS c4, ref_2.uhugeint AS c5, ref_2.tinyint AS c6, ref_2."interval" AS c7, ref_2."double" AS c8, ref_2."varchar" AS c9, ref_2.ubigint AS c10, ref_2.uuid AS c11, ref_2.fixed_array_of_int_list AS c12, ref_2.fixed_varchar_array AS c13, ref_2.timestamp_ms AS c14, ref_2.nested_int_array AS c15, ref_2."bigint" AS c16, (SELECT timestamp_ns FROM main.all_types LIMIT 1 OFFSET 2) AS c17, ref_2.time_tz AS c18 FROM main.all_types AS ref_2 WHERE EXISTS(SELECT subq_3.c0 AS c0, ref_2.dec38_10 AS c1, subq_2.c7 AS c2, subq_2.c1 AS c3, subq_2.c0 AS c4, ref_2.timestamptz_array AS c5, subq_2.c1 AS c6, ref_3."timestamp" AS c7, ref_3.struct_of_fixed_array AS c8 FROM main.all_types AS ref_3 , (SELECT ref_3.ubigint AS c0, ref_2.fixed_varchar_array AS c1, ref_3.time_tz AS c2, ref_4.bool AS c3, ref_2.list_of_fixed_int_array AS c4, ref_4."union" AS c5, 81 AS c6, ref_2.timestamp_array AS c7 FROM main.all_types AS ref_4 WHERE ((((88 IS NULL) OR (ref_4."varchar" !~~ ref_2."varchar")) AND ((ref_4.date_array IS NULL) OR (ref_3."varchar" ^@ ref_3."varchar"))) OR (EXISTS(SELECT ref_5.ubigint AS c0, ref_4.fixed_int_array AS c1, ref_3.dec_18_6 AS c2, ref_4.dec_9_4 AS c3 FROM main.all_types AS ref_5 WHERE EXISTS(SELECT ref_6."int" AS c0, (SELECT uint FROM main.all_types LIMIT 1 OFFSET 62) AS c1, ref_5.fixed_varchar_array AS c2, ref_6."time" AS c3 FROM main.all_types AS ref_6 WHERE (((ref_4."varchar" ^@ CAST(NULL AS VARCHAR)) OR 0) AND (ref_6."varchar" ^@ ref_2."varchar"))) LIMIT 92) AND (1 OR 1))) LIMIT 108) AS subq_2 , (SELECT ref_2."struct" AS c0 FROM main.all_types AS ref_7 WHERE ((ref_7."varchar" ~~~ ref_3."varchar") AND 1)) AS subq_3 WHERE ((subq_3.c0 IS NULL) OR 1))) AS subq_4 ON ((to_hex(CAST((SELECT blob FROM main.all_types LIMIT 1 OFFSET 2) AS BLOB)) ~~~ subq_4.c9)) LIMIT 134)SELECT 18 AS c0, ref_10.date AS c1, current_localtimestamp() AS c2, subq_5.c0 AS c3, ref_11.time_tz AS c4 FROM (SELECT ref_9."map" AS c0, (SELECT varchar_array FROM main.all_types LIMIT 1 OFFSET 6) AS c1, ref_9.uhugeint AS c2, ref_8.c1 AS c3, ref_8.c1 AS c4, ref_9.struct_of_fixed_array AS c5 FROM jennifer_0 AS ref_8 INNER JOIN main.all_types AS ref_9 ON ((ref_8.c1 = ref_9."int")) WHERE (ref_9."varchar" !~~ ref_9."varchar")) AS subq_5 INNER JOIN main.all_types AS ref_10 ON ((subq_5.c5 = ref_10.struct_of_fixed_array)) RIGHT JOIN main.all_types AS ref_11 ON ((ref_10."bigint" = ref_11."bigint")) WHERE ((subq_5.c5 IS NULL) AND (ref_10."varchar" ~~* ref_11."varchar")) LIMIT 44
Error Message
ABORT THROWN BY INTERNAL EXCEPTION: Failed to bind column reference "c2" [58.5] (bindings: {#[145.0], #[145.1], #[145.2], #[145.3]})
Issue found by SQLSmith on git commit hash 50bb6 using seed 312705445.
To Reproduce
Error Message