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 "varchar" [23.3] (bindings: {#[55.0], #[55.1], #[55.2], #[55.3], #[55.4]}) #3217

Closed fuzzerofducks closed 1 month ago

fuzzerofducks commented 1 month ago

Issue found by SQLSmith on git commit hash 50bb6 using seed 574845607.

To Reproduce

create table all_types as select * exclude(small_enum, medium_enum, large_enum) from test_all_types();
SELECT NULL FROM (SELECT ref_0.dec_18_6 AS c0, ref_0.fixed_nested_int_array AS c1, ref_0."time" AS c2, ref_0.uuid AS c3, ref_0.fixed_int_array AS c4, ref_0.struct_of_arrays AS c5, ref_0."smallint" AS c6, ref_0.timestamp_ns AS c7 FROM main.all_types AS ref_0 WHERE 1) AS subq_0 WHERE EXISTS(SELECT subq_0.c4 AS c0, subq_0.c0 AS c1, (SELECT NULL) AS c10, subq_0.c1 FROM main.all_types AS ref_1 INNER JOIN main.all_types AS ref_2 ON (NULL) INNER JOIN (SELECT subq_0.c6 AS c0 FROM main.all_types AS ref_3 WHERE EXISTS(SELECT subq_0.c7 AS c0, ref_4."map" AS c1, ref_3.uuid AS c2 FROM main.all_types AS ref_4 WHERE (0 AND (ref_3."varchar" ~~~ ref_3."varchar") AND 0)) LIMIT 154) AS subq_1 ON ((ref_2."varchar" ~~* ref_2."varchar")) INNER JOIN main.all_types AS ref_5 ON (1) WHERE (SELECT NULL) LIMIT 168) LIMIT 81

Error Message

ABORT THROWN BY INTERNAL EXCEPTION: Failed to bind column reference "varchar" [23.3] (bindings: {#[55.0], #[55.1], #[55.2], #[55.3], #[55.4]})