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 "interval" [3.4] (bindings: {#[1.0], #[1.1], #[1.2], #[1.3], #[16.0], #[16.1]}) #3191

Closed fuzzerofducks closed 1 month ago

fuzzerofducks commented 1 month ago

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

To Reproduce

create table all_types as select * exclude(small_enum, medium_enum, large_enum) from test_all_types() limit 0;
SELECT NULL FROM (SELECT ref_1."float" AS c0, ref_3.fixed_nested_varchar_array AS c1, ref_1.fixed_array_of_int_list AS c6 FROM main.all_types AS ref_0 INNER JOIN main.all_types AS ref_1 ON (EXISTS(SELECT NULL, NULL, ref_1.utinyint AS c2 WHERE (ref_1."varchar" AND ref_0."interval" AND 0 AND (SELECT NULL)))) INNER JOIN main.all_types AS ref_3 ON ((ref_3."varchar" ~~ ref_3."varchar")) LIMIT 159) LIMIT 100

Error Message

ABORT THROWN BY INTERNAL EXCEPTION: Failed to bind column reference "interval" [3.4] (bindings: {#[1.0], #[1.1], #[1.2], #[1.3], #[16.0], #[16.1]})