Issue found by SQLSmith on git commit hash 50bb6 using seed 565705320.
To Reproduce
create table all_types as select * exclude(small_enum, medium_enum, large_enum) from test_all_types() limit 0;
SELECT (SELECT NULL) AS c5, EXISTS(SELECT NULL FROM main.all_types AS ref_1 WHERE EXISTS(SELECT NULL, NULL, NULL, NULL, (SELECT NULL) AS c4, NULL FROM main.all_types AS ref_2 , (SELECT subq_0.c1 AS c2, subq_2.c5 AS c3, ref_2.fixed_nested_varchar_array AS c4, ref_2.utinyint AS c5, subq_0.c2 AS c6, 76 AS c7, ref_3.timestamp_array AS c8, ref_2.date AS c9, ref_3.timestamptz_array AS c10, ref_1.fixed_varchar_array AS c11, subq_2.c4 AS c12 FROM main.all_types AS ref_3 , (SELECT ref_3.struct_of_arrays AS c0, subq_0.c2 AS c1, ref_1."float" AS c2, ref_2.timestamp_ms AS c3, subq_0.c0 AS c4, ref_2.timestamp_array AS c5, ref_3."bit" AS c6, ref_1.fixed_nested_int_array AS c7, ref_1."struct" AS c8, ref_1.fixed_array_of_int_list AS c9 FROM main.all_types AS ref_4 WHERE EXISTS(SELECT ref_2.int_array AS c0, ref_4.timestamp_ms AS c1 FROM main.all_types AS ref_5 , (SELECT ref_2.fixed_nested_int_array AS c0, ref_1.struct_of_fixed_array AS c1, (SELECT usmallint FROM main.all_types LIMIT 1 OFFSET 1) AS c2 FROM main.all_types AS ref_6 WHERE (ref_3.dec_9_4 IS NOT NULL)) AS subq_1 WHERE ((ref_2."varchar" ~~ subq_0.c1) OR EXISTS(SELECT subq_0.c0 AS c0, (SELECT "struct" FROM main.all_types LIMIT 1 OFFSET 6) AS c1, 56 AS c2, (SELECT fixed_varchar_array FROM main.all_types LIMIT 1 OFFSET 6) AS c3 FROM main.all_types AS ref_7 WHERE (ref_7."varchar" !~~ ref_4."varchar") LIMIT 146)))) AS subq_2 WHERE 1 LIMIT 105) AS subq_3 , (SELECT subq_0.c1 AS c0, ref_1.time_tz AS c1, subq_3.c4 AS c2, ref_8.tinyint AS c3, ref_8."int" AS c4, (SELECT blob FROM main.all_types LIMIT 1 OFFSET 2) AS c5, ref_2.fixed_array_of_int_list AS c6, subq_3.c5 AS c7, subq_0.c1 AS c8 FROM main.all_types AS ref_8 WHERE ((subq_3.c2 !~~ ref_1."varchar") AND (ref_2."varchar" ^@ ref_8."varchar")) LIMIT 153) AS subq_4 WHERE 0 LIMIT 78) LIMIT 25) FROM (SELECT ref_0."timestamp" AS c0, ref_0."varchar" AS c1, ref_0."struct" AS c2, ref_0.time_tz AS c3, ref_0.date AS c4 FROM main.all_types AS ref_0 WHERE (ref_0."varchar" ~~ ref_0."varchar") LIMIT 139) AS subq_0 WHERE ((subq_0.c1 IS NULL) OR (subq_0.c1 ^@ subq_0.c1) OR (subq_0.c1 ^@ CAST(NULL AS VARCHAR)))
Error Message
ABORT THROWN BY INTERNAL EXCEPTION: Failed to bind column reference "c1" [98.6] (bindings: {#[114.0], #[114.1], #[114.2]})
Issue found by SQLSmith on git commit hash 50bb6 using seed 565705320.
To Reproduce
Error Message