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 "c0" [26.5] (bindings: {#[47.0], #[47.1], #[47.2], #[47.3], #[47.4], #[47.5]}) #3188

Closed fuzzerofducks closed 1 month ago

fuzzerofducks commented 1 month ago

Issue found by SQLSmith on git commit hash dd9e6 using seed 659130010.

To Reproduce

create table all_types as select * exclude(small_enum, medium_enum, large_enum) from test_all_types() limit 0;
UPDATE main.all_types SET timestamp_s = (SELECT NULL), timestamp_array = EXISTS(SELECT main.all_types.fixed_nested_varchar_array AS c0, main.all_types.fixed_int_array AS c1, main.all_types.dec38_10 AS c2 FROM main.all_types AS ref_0 WHERE EXISTS(SELECT NULL, 4 AS c1, (SELECT NULL LIMIT 1 OFFSET 4) AS c2, 38 AS c3, (SELECT "float" FROM main.all_types LIMIT 1 OFFSET 3) AS c4 FROM main.all_types AS ref_1 , (SELECT ref_0.fixed_varchar_array AS c0, ref_2."map" AS c1, main.all_types.date AS c2, main.all_types.fixed_varchar_array AS c3, main.all_types.fixed_struct_array AS c4, ref_0.date AS c5 FROM main.all_types AS ref_2 WHERE 0 LIMIT 124) AS subq_0 WHERE 1) LIMIT 140) RETURNING main.all_types.date_array, get_current_timestamp()

Error Message

ABORT THROWN BY INTERNAL EXCEPTION: Failed to bind column reference "c0" [26.5] (bindings: {#[47.0], #[47.1], #[47.2], #[47.3], #[47.4], #[47.5]})