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 "c2" [23.6] (bindings: {#[2.0], #[2.1], #[2.2], #[2.3], #[2.4], #[2.5], #[2.6], #[2.7], #[2.8], #[2.9], #[2.10], #[2.11], #[2.12], #[2.13], #[2.14], #[2.15], #[2.16], #[2.1... #3176

Closed fuzzerofducks closed 3 months ago

fuzzerofducks commented 3 months ago

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

To Reproduce

create table all_types as select * exclude(small_enum, medium_enum, large_enum) from test_all_types() limit 0;
SELECT (SELECT NULL) FROM main.all_types AS ref_0 INNER JOIN (SELECT NULL, NULL, NULL, (SELECT NULL) AS c3, NULL, NULL, NULL, (SELECT NULL) AS c7, NULL, ref_1.list_of_fixed_int_array AS c9, ref_1."time" AS c10, ref_1.struct_of_fixed_array AS c11, ref_1."float" AS c12, ref_1."varchar" AS c13, ref_1.date_array AS c14, argmax(CAST(ref_1.blob AS BLOB), CAST(ref_1.blob AS BLOB)) OVER (PARTITION BY ref_1.timestamp_array ORDER BY ref_1.timestamp_s) AS c15, ref_1."float" AS c16, ref_1.timestamp_ms AS c17 FROM main.all_types AS ref_1 WHERE 0 LIMIT 154) AS subq_0 ON (EXISTS(SELECT subq_0.c10 AS c0, subq_0.c17 AS c1, ref_0."smallint" AS c2, ref_2."smallint" AS c3 FROM main.all_types AS ref_2 WHERE 0))

Error Message

ABORT THROWN BY INTERNAL EXCEPTION: Failed to bind column reference "c2" [23.6] (bindings: {#[2.0], #[2.1], #[2.2], #[2.3], #[2.4], #[2.5], #[2.6], #[2.7], #[2.8], #[2.9], #[2.10], #[2.11], #[2.12], #[2.13], #[2.14], #[2.15], #[2.16], #[2.17], #[48.0]})