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" [30.4] (bindings: {#[71.0], #[71.1], #[71.2], #[71.3], #[71.4], #[71.5], #[71.6], #[71.7]}) #3212

Closed fuzzerofducks closed 1 month ago

fuzzerofducks commented 1 month ago

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

To Reproduce

create table all_types as select * exclude(small_enum, medium_enum, large_enum) from test_all_types();
SELECT NULL FROM (SELECT (SELECT NULL) AS c1 FROM (SELECT NULL FROM main.all_types AS ref_0 , (SELECT ref_1.nested_int_array AS c3, ref_0."interval" AS c4, ref_0.fixed_struct_array AS c5 FROM main.all_types AS ref_1) AS subq_0 , (SELECT (SELECT NULL) AS c1, ref_2.array_of_structs AS c2 FROM main.all_types AS ref_2 WHERE (ref_0."varchar" ^@ ref_0."varchar") LIMIT 182) AS subq_1 , (SELECT subq_0.c3 AS c0, subq_1.c2 AS c1, subq_0.c3 AS c2, ref_3.dec_4_1 AS c3, ref_0."double" AS c4, subq_1.c2 AS c5, subq_0.c5 AS c6 FROM main.all_types AS ref_3 WHERE (EXISTS(SELECT 5 AS c0, subq_0.c4 AS c1, ref_0.usmallint AS c2 FROM main.all_types AS ref_4 WHERE ((1 OR ((ref_0."varchar" ~~* ref_3."varchar") AND (ref_0."varchar" !~~ ref_3."varchar"))) AND (ref_0."varchar" ^@ CAST(NULL AS VARCHAR)) AND (ref_4."varchar" !~~* ref_4."varchar")) LIMIT 97) OR (((SELECT "varchar" FROM main.all_types LIMIT 1 OFFSET 2) ~~* CAST(NULL AS VARCHAR)) AND 0)) LIMIT 141) AS subq_2 LIMIT 128) LIMIT 147) LIMIT 127

Error Message

ABORT THROWN BY INTERNAL EXCEPTION: Failed to bind column reference "varchar" [30.4] (bindings: {#[71.0], #[71.1], #[71.2], #[71.3], #[71.4], #[71.5], #[71.6], #[71.7]})