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" [25.15] (bindings: {#[61.0], #[61.1], #[61.2], #[61.3], #[61.4], #[61.5], #[61.6], #[61.7], #[61.8], #[61.9], #[61.10]}) #3219

Closed fuzzerofducks closed 1 month ago

fuzzerofducks commented 1 month ago

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

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 INNER JOIN main.all_types AS ref_1 ON (NULL) , (SELECT NULL FROM (SELECT ref_2.usmallint AS c2, ref_2.bool AS c5, ref_1.double_array AS c10, ref_0."varchar" AS c12 FROM main.all_types AS ref_2 INNER JOIN main.all_types AS ref_3 ON ((ref_0.timestamp_array IS NULL)) LIMIT 70) AS subq_0 , (SELECT ref_0.bool AS c0, subq_0.c10 AS c1 FROM main.all_types AS ref_4 WHERE EXISTS(SELECT ref_1.bool AS c0, subq_1.c0 AS c1, ref_4.hugeint AS c2, subq_0.c12 AS c3, subq_1.c0 AS c4, ref_0.dec38_10 AS c5, ref_4.tinyint AS c6, ref_0.dec_4_1 AS c7, subq_0.c2 AS c8, ref_1.utinyint AS c9, subq_0.c5 AS c10 FROM main.all_types AS ref_5 , (SELECT ref_0.dec_4_1 AS c0 FROM main.all_types AS ref_6 WHERE ((ref_6."varchar" ~~* subq_0.c12) AND (ref_4."varchar" !~~ CAST(NULL AS VARCHAR))) LIMIT 102) AS subq_1 WHERE (ref_1."varchar" ^@ (SELECT "varchar" FROM main.all_types LIMIT 1 OFFSET 5)) LIMIT 86)) AS subq_2) WHERE (SELECT NULL) LIMIT 100

Error Message

ABORT THROWN BY INTERNAL EXCEPTION: Failed to bind column reference "c2" [25.15] (bindings: {#[61.0], #[61.1], #[61.2], #[61.3], #[61.4], #[61.5], #[61.6], #[61.7], #[61.8], #[61.9], #[61.10]})