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" [37.2] (bindings: {#[81.0], #[81.1], #[81.2], #[81.3], #[81.4], #[81.5], #[81.6], #[78.0]}) #3166

Closed fuzzerofducks closed 1 month ago

fuzzerofducks commented 1 month ago

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

To Reproduce

create table all_types as select * exclude(small_enum, medium_enum, large_enum) from test_all_types();
SELECT (SELECT NULL) AS c1 FROM (SELECT NULL FROM main.all_types AS ref_0 , (SELECT ref_0.utinyint AS c1, ref_0.array_of_structs AS c2, ref_1.fixed_int_array AS c3 FROM main.all_types AS ref_1 WHERE (SELECT NULL)) AS subq_0 , (SELECT ref_0."float" AS c1, subq_0.c2 AS c4, ref_0."varchar" AS c5, subq_0.c1 AS c6, (SELECT fixed_nested_varchar_array FROM main.all_types LIMIT 1 OFFSET 4) AS c7, ref_2.dec_4_1 AS c8, ref_2."map" AS c9, subq_0.c3 AS c10, ref_0.fixed_nested_int_array AS c11, subq_0.c3 AS c12, subq_0.c2 AS c13 FROM main.all_types AS ref_2 WHERE EXISTS(SELECT ref_3.dec_9_4 AS c0, ref_2.dec_18_6 AS c1 FROM main.all_types AS ref_3 , (SELECT ref_2."varchar" AS c0, subq_0.c1 AS c1 FROM main.all_types AS ref_4 WHERE ((SELECT utinyint FROM main.all_types LIMIT 1 OFFSET 4) IS NOT NULL) LIMIT 98) AS subq_1 WHERE (CAST(NULL AS VARCHAR) ~~ ref_3."varchar") LIMIT 87))) WHERE (SELECT NULL) LIMIT 29

Error Message

ABORT THROWN BY INTERNAL EXCEPTION: Failed to bind column reference "c0" [37.2] (bindings: {#[81.0], #[81.1], #[81.2], #[81.3], #[81.4], #[81.5], #[81.6], #[78.0]})