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" [6.4] (bindings: {#[4.0], #[4.1], #[4.2], #[4.3]}) #3201

Closed fuzzerofducks closed 1 month ago

fuzzerofducks commented 1 month ago

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

To Reproduce

create table all_types as select * exclude(small_enum, medium_enum, large_enum) from test_all_types() limit 0;
SELECT bit_and(NULL) OVER (PARTITION BY NULL ORDER BY ref_4.fixed_int_array) AS c4 FROM main.all_types INNER JOIN main.all_types AS ref_1 INNER JOIN main.all_types AS ref_2 INNER JOIN main.all_types AS ref_3 ON (NULL) ON (NULL) INNER JOIN main.all_types AS ref_4 ON (EXISTS(SELECT NULL, NULL, ref_4.time_tz AS c2, NULL WHERE (0 AND NULL AND ref_2."varchar"))) ON (((SELECT "varchar" FROM main.all_types) !~~* ref_4."varchar")) INNER JOIN (SELECT ref_8.uhugeint AS c2, ref_8.fixed_nested_varchar_array AS c3, ref_8.struct_of_fixed_array AS c4, ref_8."varchar" AS c5 FROM main.all_types AS ref_8 WHERE (ref_8."varchar" ^@ ref_8."varchar")) AS subq_1 ON ((ref_4.dec_9_4 IS NOT NULL)) RIGHT JOIN main.all_types AS ref_9 ON (((subq_1.c5 ~~* ref_9."varchar") AND (ref_4."varchar" ~~* ref_4."varchar"))) RIGHT JOIN main.all_types AS ref_10 ON ((0 OR (ref_9."varchar" ~~ ref_4."varchar"))) LIMIT 65

Error Message

ABORT THROWN BY INTERNAL EXCEPTION: Failed to bind column reference "varchar" [6.4] (bindings: {#[4.0], #[4.1], #[4.2], #[4.3]})