Issue found by SQLSmith on git commit hash 950d7 using seed 608725539.
To Reproduce
create table all_types as select * exclude(small_enum, medium_enum, large_enum) from test_all_types() limit 0;
SELECT CASE WHEN (((NULL OR EXISTS(SELECT ref_5.tinyint AS c0, subq_0.c0 AS c1, 42 AS c2, (SELECT fixed_nested_varchar_array FROM main.all_types LIMIT 1 OFFSET 2) AS c3, subq_0.c1 AS c4, subq_0.c0 AS c5, ref_5.struct_of_fixed_array AS c6, 32 AS c7, subq_0.c2 AS c8, ref_5.list_of_fixed_int_array AS c9, subq_2.c3 AS c10, (SELECT fixed_struct_array FROM main.all_types LIMIT 1 OFFSET 70) AS c11, ref_4.time_tz AS c12, ref_4.fixed_varchar_array AS c13, ref_4."interval" AS c14, ref_5.hugeint AS c15, ref_4.uint AS c16, ref_4.dec_4_1 AS c17, ref_4.dec_9_4 AS c18, subq_0.c2 AS c19, ref_4.time_tz AS c20, subq_2.c3 AS c21, subq_2.c1 AS c22, ref_5.dec_9_4 AS c23, subq_0.c0 AS c24, subq_0.c2 AS c25 FROM main.all_types AS ref_5 WHERE EXISTS(SELECT ref_5."interval" AS c0, subq_2.c1 AS c1, ref_6.tinyint AS c2, subq_0.c2 AS c3, subq_0.c1 AS c4, ref_4.dec38_10 AS c5 FROM main.all_types AS ref_6 WHERE EXISTS(SELECT subq_3.c1 AS c0, ref_6.uhugeint AS c1, subq_0.c1 AS c2, subq_3.c0 AS c3, ref_6.time_tz AS c4, (SELECT bool FROM main.all_types LIMIT 1 OFFSET 1) AS c5, subq_0.c2 AS c6 FROM main.all_types AS ref_7 , (SELECT ref_6.timestamp_ms AS c0, subq_0.c2 AS c1, ref_6.ubigint AS c2, (SELECT usmallint FROM main.all_types LIMIT 1 OFFSET 5) AS c3, ref_4."smallint" AS c4, subq_0.c1 AS c5 FROM main.all_types AS ref_8 WHERE (ref_5."varchar" !~~* ref_7."varchar")) AS subq_3 WHERE (91 IS NULL)) LIMIT 116) LIMIT 77)) AND ((SELECT "varchar" FROM main.all_types LIMIT 1 OFFSET 69) !~~* ref_4."varchar") AND (ref_4."varchar" !~~ ref_4."varchar") AND (ref_4."varchar" ~~ ref_4."varchar") AND (ref_4."varchar" !~~ (SELECT "varchar" FROM main.all_types LIMIT 1 OFFSET 6)))) THEN ((SELECT NULL)) ELSE (SELECT NULL) END AS c9, (SELECT struct_of_arrays FROM main.all_types LIMIT 1 OFFSET 3) AS c10, (SELECT struct_of_arrays FROM main.all_types LIMIT 1 OFFSET 4) AS c21 FROM (SELECT ref_1.uint AS c0, ref_1."int" AS c1, ref_0.usmallint AS c2 FROM main.all_types AS ref_0 INNER JOIN main.all_types AS ref_1 ON ((60 IS NOT NULL)) WHERE (ref_1."varchar" ^@ ref_1."varchar") LIMIT 89) AS subq_0 INNER JOIN (SELECT ref_2.nested_int_array AS c0, subq_1.c3 AS c1, ref_2.timestamptz_array AS c2, ref_2.struct_of_arrays AS c3, ref_2.ubigint AS c4 FROM main.all_types AS ref_2 , (SELECT ref_2.fixed_nested_varchar_array AS c0, ref_2.fixed_int_array AS c1, ref_2.timestamp_ns AS c2, ref_3.date AS c3 FROM main.all_types AS ref_3 WHERE (ref_3."varchar" ^@ ref_2."varchar") LIMIT 87) AS subq_1 WHERE (subq_1.c3 IS NULL)) AS subq_2 ON ((CAST(NULL AS VARCHAR) ~~~ (SELECT "varchar" FROM main.all_types LIMIT 1 OFFSET 2))) INNER JOIN main.all_types AS ref_4 ON ((subq_0.c0 = ref_4.uint)) WHERE ((((SELECT "varchar" FROM main.all_types LIMIT 1 OFFSET 2) ~~* ref_4."varchar") OR (ref_4."varchar" ~~ ref_4."varchar") OR 1) AND 1)
Error Message
ABORT THROWN BY INTERNAL EXCEPTION: Failed to bind column reference "c0" [72.8] (bindings: {#[154.0], #[154.1], #[154.2], #[154.3], #[154.4], #[154.5], #[154.6]})
Issue found by SQLSmith on git commit hash 950d7 using seed 608725539.
To Reproduce
Error Message