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 "c1" [1.0] (bindings: {#[18.0], #[18.1], #[18.2], #[2.0]}) #3207

Closed fuzzerofducks closed 1 month ago

fuzzerofducks commented 1 month ago

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

To Reproduce

create table all_types as select * exclude(small_enum, medium_enum, large_enum) from test_all_types();
SELECT NULL FROM main.all_types AS ref_0 RIGHT JOIN main.all_types AS ref_1 INNER JOIN main.all_types AS ref_2 ON (EXISTS(SELECT ref_1.bool AS c1, (SELECT NULL) AS c4 WHERE (0 AND ref_2."varchar"))) RIGHT JOIN (SELECT NULL, 51 AS c1, NULL) AS subq_0 ON (subq_0.c1) ON ((ref_1."varchar" !~~ ref_0."varchar")) WHERE ref_2."varchar" LIMIT 113

Error Message

ABORT THROWN BY INTERNAL EXCEPTION: Failed to bind column reference "c1" [1.0] (bindings: {#[18.0], #[18.1], #[18.2], #[2.0]})