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 "c4" [17.11] (bindings: {#[1.0], #[1.1], #[1.2], #[1.3], #[1.4], #[2.0], #[2.1], #[2.2], #[29.0]}) #3189

Closed fuzzerofducks closed 1 month ago

fuzzerofducks commented 1 month ago

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

To Reproduce

create table all_types as select * exclude(small_enum, medium_enum, large_enum) from test_all_types() limit 0;
SELECT 13 AS c1 FROM (SELECT ref_2.nested_int_array AS c0, ref_1."interval" AS c1 FROM main.all_types AS ref_0 LEFT JOIN main.all_types AS ref_1 LEFT JOIN main.all_types AS ref_2 ON ((ref_1.uhugeint = ref_2.uhugeint)) ON (((ref_1.struct_of_arrays IS NOT NULL) AND (ref_2."varchar" ^@ ref_1."varchar") AND (ref_2."varchar" !~~ (SELECT "varchar" FROM main.all_types LIMIT 1 OFFSET 7)))) WHERE (ref_2."varchar" AND EXISTS(SELECT NULL, NULL, ref_1.timestamp_ns AS c2, NULL, ref_0.utinyint AS c4, NULL, NULL, NULL, NULL WHERE (NULL AND NULL AND ref_2."varchar")) AND 1) LIMIT 100)

Error Message

ABORT THROWN BY INTERNAL EXCEPTION: Failed to bind column reference "c4" [17.11] (bindings: {#[1.0], #[1.1], #[1.2], #[1.3], #[1.4], #[2.0], #[2.1], #[2.2], #[29.0]})