Issue found by SQLSmith on git commit hash dd9e6 using seed 518336014.
To Reproduce
create table all_types as select * exclude(small_enum, medium_enum, large_enum) from test_all_types();
SELECT json_contains(EXISTS(SELECT (SELECT NULL) AS c0 FROM main.all_types AS ref_3 WHERE EXISTS(SELECT subq_1.c4 AS c0, NULL, subq_2.c1 AS c2, NULL, ref_3.timestamp_tz AS c4, NULL WHERE NULL)), (SELECT "varchar" FROM main.all_types)) AS c10 FROM (SELECT subq_0.c1 AS c0, ref_0.fixed_struct_array AS c1, (SELECT "float" FROM main.all_types LIMIT 1 OFFSET 5) AS c2, subq_0.c2 AS c3, ref_0.ubigint AS c4, (SELECT "bit" FROM main.all_types LIMIT 1 OFFSET 15) AS c5, subq_0.c0 AS c6 FROM main.all_types AS ref_0 , (SELECT ref_1.uuid AS c0, (SELECT struct_of_fixed_array FROM main.all_types LIMIT 1 OFFSET 1) AS c1, (SELECT "struct" FROM main.all_types LIMIT 1 OFFSET 1) AS c2, ref_0.list_of_fixed_int_array AS c3, ref_0."time" AS c4, ref_1.hugeint AS c5, ref_1.hugeint AS c6, ref_1.blob AS c7 FROM main.all_types AS ref_1 WHERE (ref_1."varchar" ~~* ref_1."varchar") LIMIT 35) AS subq_0 WHERE 0) AS subq_1 LEFT JOIN (SELECT ref_2.varchar_array AS c0, ref_2."bit" AS c1, ref_2.list_of_fixed_int_array AS c2 FROM main.all_types AS ref_2 WHERE (ref_2."varchar" !~~* ref_2."varchar")) AS subq_2 ON ((subq_1.c5 = subq_2.c1)) LIMIT 115
Error Message
ABORT THROWN BY INTERNAL EXCEPTION: Failed to bind column reference "c4" [63.8] (bindings: {#[97.0], #[97.1], #[94.0]})
Issue found by SQLSmith on git commit hash dd9e6 using seed 518336014.
To Reproduce
Error Message