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 "bigint" [42.4] (bindings: {#[60.0], #[60.1], #[60.2]}) #3198

Closed fuzzerofducks closed 1 month ago

fuzzerofducks commented 1 month ago

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

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 (SELECT (SELECT mad("double") FROM main.all_types) AS c0, ref_0."int" AS c1, ref_0."float" AS c2, ref_0.utinyint AS c3 FROM main.all_types AS ref_0 WHERE (ref_0."varchar" !~~ ref_0."varchar") LIMIT 101) AS subq_0 WHERE COALESCE((SELECT NULL), EXISTS(SELECT NULL FROM main.all_types AS ref_1 WHERE EXISTS(SELECT NULL, subq_0.c1 AS c1, NULL, 29 AS c3 FROM main.all_types , (SELECT subq_0.c2 AS c2, subq_0.c0 AS c3 WHERE ref_1."bigint" LIMIT 171) WHERE 0) LIMIT 165)) LIMIT 28

Error Message

ABORT THROWN BY INTERNAL EXCEPTION: Failed to bind column reference "bigint" [42.4] (bindings: {#[60.0], #[60.1], #[60.2]})