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" [18.1] (bindings: {#[71.0], #[71.1], #[71.2], #[71.3], #[71.4]}) #3234

Closed fuzzerofducks closed 1 month ago

fuzzerofducks commented 1 month ago

Issue found by SQLSmith on git commit hash 950d7 using seed 807221526.

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 (SELECT NULL) ON (NULL) INNER JOIN (SELECT (SELECT NULL) AS c10, (SELECT NULL) AS c11 FROM main.all_types AS ref_2 INNER JOIN main.all_types AS ref_3 ON (NULL) , (SELECT ref_2.timestamp_ns AS c0 FROM main.all_types AS ref_4 WHERE EXISTS(SELECT ref_2.date AS c0 FROM main.all_types AS ref_5 WHERE (EXISTS(SELECT (SELECT fixed_array_of_int_list FROM main.all_types LIMIT 1 OFFSET 5) AS c0, ref_6."map" AS c1, ref_6.uhugeint AS c2, ref_3."struct" AS c3 FROM main.all_types AS ref_6 WHERE ((ref_6."varchar" !~~* ref_4."varchar") OR ((SELECT "varchar" FROM main.all_types LIMIT 1 OFFSET 4) !~~ ref_5."varchar") OR (ref_3."varchar" !~~ ref_2."varchar"))) AND 0)) LIMIT 117) LIMIT 117) ON ((ref_0."varchar" ~~~ ref_0."varchar")) LIMIT 36

Error Message

ABORT THROWN BY INTERNAL EXCEPTION: Failed to bind column reference "varchar" [18.1] (bindings: {#[71.0], #[71.1], #[71.2], #[71.3], #[71.4]})