search

duckdb / duckdb-fuzzer

Repository that contains automatic reports of issues found through fuzzing DuckDB
0 stars 0 forks source link

ABORT THROWN BY INTERNAL EXCEPTION: Failed to bind column reference "c1" [27.9] (bindings: {#[20.0]}) #3160

Closed fuzzerofducks closed 1 month ago

fuzzerofducks commented 1 month ago

Issue found by SQLSmith on git commit hash dd9e6 using seed 739737451.

To Reproduce

create table all_types as select * exclude(small_enum, medium_enum, large_enum) from test_all_types() limit 0;
SELECT NULL FROM main.all_types AS ref_0 INNER JOIN main.all_types AS ref_1 ON (0) INNER JOIN (SELECT ref_3."bit" AS c0 FROM main.all_types INNER JOIN main.all_types AS ref_3 ON (NULL) INNER JOIN main.all_types AS ref_4 ON (NULL) INNER JOIN main.all_types AS ref_5 ON (NULL) WHERE (SELECT NULL)) AS subq_0 ON (NULL) INNER JOIN (SELECT ref_6.struct_of_fixed_array AS c0 FROM main.all_types AS ref_6) AS subq_1 ON (EXISTS(SELECT NULL, subq_0.c0 AS c1, NULL, subq_0.c0 AS c3, ref_0."double" AS c4, ref_0.usmallint AS c5, subq_1.c0 AS c6, ref_1."varchar" AS c7, ref_7.fixed_struct_array AS c8 FROM main.all_types AS ref_7 WHERE 0 LIMIT 160))

Error Message

ABORT THROWN BY INTERNAL EXCEPTION: Failed to bind column reference "c1" [27.9] (bindings: {#[20.0]})