Issue found by SQLSmith on git commit hash 50bb6 using seed 992922083.
To Reproduce
create table all_types as select * exclude(small_enum, medium_enum, large_enum) from test_all_types();
SELECT (SELECT NULL) AS c1, min_by(NULL, CASE WHEN (((72 IS NULL) AND ((SELECT fixed_array_of_int_list FROM main.all_types LIMIT 1 OFFSET 6) IS NULL))) THEN (CASE WHEN (EXISTS(SELECT ref_0.dec_4_1 AS c0, (SELECT "map" FROM main.all_types LIMIT 1 OFFSET 1) AS c1, (SELECT list_of_fixed_int_array FROM main.all_types LIMIT 1 OFFSET 4) AS c2 FROM main.all_types AS ref_1 WHERE EXISTS(SELECT ref_1.blob AS c0, ref_2.uint AS c1, ref_0.timestamp_ns AS c2 FROM main.all_types AS ref_2 WHERE 0 LIMIT 193) LIMIT 65)) THEN (ref_0."int") ELSE ref_0."int" END) ELSE EXISTS(SELECT (SELECT NULL) AS c1, (SELECT NULL) AS c2 WHERE EXISTS(SELECT ref_2.uint AS c1, ref_0.timestamp_ns AS c2 FROM main.all_types AS ref_2 WHERE 0 LIMIT 193) LIMIT 65) END) OVER (PARTITION BY ref_0.fixed_struct_array, ref_0.timestamp_ms, ref_0.uhugeint ORDER BY ref_0.tinyint, ref_0.hugeint) AS c6 FROM main.all_types AS ref_0 WHERE (CASE WHEN ((EXISTS(SELECT (SELECT timestamp_array FROM main.all_types LIMIT 1 OFFSET 4) AS c0, ref_0."bit" AS c1, (SELECT timestamp_array FROM main.all_types LIMIT 1 OFFSET 2) AS c2, ref_3.dec_9_4 AS c3, ref_0.dec38_10 AS c4, ref_3.double_array AS c5, ref_3.uuid AS c6 FROM main.all_types AS ref_3 WHERE (ref_3.fixed_varchar_array IS NULL) LIMIT 137) AND EXISTS(SELECT ref_0.uuid AS c0, ref_4.list_of_fixed_int_array AS c1, ref_0.fixed_varchar_array AS c2, ref_0.dec_4_1 AS c3 FROM main.all_types AS ref_4 WHERE (ref_4."varchar" ~~~ ref_4."varchar") LIMIT 95))) THEN (current_database()) ELSE current_database() END !~~* writefile()) LIMIT 89
Error Message
ABORT THROWN BY INTERNAL EXCEPTION: Failed to bind column reference "c0" [57.3] (bindings: {#[122.0], #[122.1], #[117.0], #[119.0]})
Issue found by SQLSmith on git commit hash 50bb6 using seed 992922083.
To Reproduce
Error Message