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" [30.0] (bindings: {#[29.0], #[29.1], #[29.2], #[29.3]}) #3203

Closed fuzzerofducks closed 1 month ago

fuzzerofducks commented 1 month ago

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

To Reproduce

create table all_types as select * exclude(small_enum, medium_enum, large_enum) from test_all_types();
SELECT ref_2.int_array FROM (SELECT (SELECT NULL) AS c2 WHERE ((SELECT NULL) ~~ (SELECT NULL))) INNER JOIN main.all_types AS ref_1 ON (NULL) RIGHT JOIN main.all_types AS ref_2 INNER JOIN main.all_types AS ref_3 ON (EXISTS(SELECT ref_2.fixed_int_array AS c2 WHERE (NULL AND NULL AND (ref_3."varchar" !~~ ref_2."varchar")) LIMIT 128)) ON ((ref_3."varchar" ^@ CAST(NULL AS VARCHAR))) INNER JOIN main.all_types AS ref_5 ON ((ref_2.fixed_nested_int_array IS NOT NULL)) INNER JOIN main.all_types AS ref_6 ON ((ref_1."varchar" !~~* ref_3."varchar")) LIMIT 113

Error Message

ABORT THROWN BY INTERNAL EXCEPTION: Failed to bind column reference "varchar" [30.0] (bindings: {#[29.0], #[29.1], #[29.2], #[29.3]})