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 "varchar" [40.3] (bindings: {#[2.0], #[2.1], #[2.2], #[2.3], #[3.0], #[82.0]}) #3218

Closed fuzzerofducks closed 1 month ago

fuzzerofducks commented 1 month ago

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

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 (SELECT NULL) AS c0, ref_2."time" AS c6 FROM main.all_types AS ref_0 INNER JOIN main.all_types AS ref_1 ON (NULL) INNER JOIN main.all_types AS ref_2 INNER JOIN main.all_types ON (ref_2.double_array) ON (EXISTS(SELECT NULL, (SELECT NULL) AS c1, NULL FROM main.all_types AS ref_4 , (SELECT (SELECT NULL FROM main.all_types LIMIT 1 OFFSET 5) AS c2, ref_2."bigint" AS c3 FROM main.all_types AS ref_5 , (SELECT ref_6."double" AS c0 FROM main.all_types AS ref_6 WHERE (ref_1."varchar" ~~* ref_2."varchar")) AS subq_0 WHERE (ref_4."varchar" ^@ ref_0."varchar")) AS subq_1 , (SELECT subq_1.c3 AS c0, (SELECT dec_18_6 FROM main.all_types LIMIT 1 OFFSET 5) AS c1 FROM main.all_types AS ref_7 WHERE 1) AS subq_2 WHERE 0)))

Error Message

ABORT THROWN BY INTERNAL EXCEPTION: Failed to bind column reference "varchar" [40.3] (bindings: {#[2.0], #[2.1], #[2.2], #[2.3], #[3.0], #[82.0]})