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" [10.4] (bindings: {#[8.0], #[8.1], #[8.2], #[8.3], #[8.4], #[8.5], #[8.6], #[8.7]}) #3227

Closed fuzzerofducks closed 1 month ago

fuzzerofducks commented 1 month ago

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

To Reproduce

create table all_types as select * exclude(small_enum, medium_enum, large_enum) from test_all_types() limit 0;
SELECT NULL FROM main.all_types AS ref_0 WHERE EXISTS(SELECT NULL FROM (SELECT ref_2."time" AS c0, ref_2.dec_9_4 AS c1, ref_2."struct" AS c4, ref_0.hugeint AS c8, ref_2.struct_of_fixed_array AS c10, ref_2.uhugeint AS c12 FROM main.all_types AS ref_1 INNER JOIN main.all_types AS ref_2 ON (EXISTS(SELECT NULL, ref_2.uuid AS c1, NULL WHERE (ref_2."struct" AND 0 AND (NULL ~~ ref_2."varchar") AND (ref_1."varchar" ~~* (SELECT "varchar" FROM main.all_types LIMIT 1 OFFSET 5))))) LEFT JOIN main.all_types AS ref_4 ON ((1 OR (ref_2.bool IS NULL))) LIMIT 133) AS subq_0 , (SELECT subq_0.c4 AS c0 FROM main.all_types AS ref_5 INNER JOIN main.all_types AS ref_6 ON (EXISTS(SELECT subq_0.c8 AS c0, subq_0.c8 AS c1, ref_7.tinyint AS c2, ref_6.time_tz AS c3 FROM main.all_types AS ref_7 WHERE ((17 IS NOT NULL) OR (ref_6."varchar" !~~* ref_5."varchar")) LIMIT 72)) INNER JOIN main.all_types AS ref_8 ON ((ref_6."map" = ref_8."map")) WHERE (ref_6."varchar" ^@ ref_5."varchar") LIMIT 161) AS subq_1 LIMIT 12) LIMIT 65

Error Message

ABORT THROWN BY INTERNAL EXCEPTION: Failed to bind column reference "varchar" [10.4] (bindings: {#[8.0], #[8.1], #[8.2], #[8.3], #[8.4], #[8.5], #[8.6], #[8.7]})