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" [11.2] (bindings: {#[30.0], #[30.1], #[30.2], #[30.3], #[30.4], #[30.5], #[30.6], #[30.7], #[30.8]}) #3231

Closed fuzzerofducks closed 1 month ago

fuzzerofducks commented 1 month ago

Issue found by SQLSmith on git commit hash 950d7 using seed 920928965.

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 (SELECT NULL FROM main.all_types AS ref_1 INNER JOIN main.all_types AS ref_2 ON (NULL) , (SELECT ref_2."double" AS c1, ref_1."interval" AS c2, ref_2.date_array AS c6, ref_2.ubigint AS c7, ref_2.time_tz AS c8, ref_1.struct_of_arrays AS c11, ref_2.nested_int_array AS c12 FROM main.all_types AS ref_3 WHERE EXISTS(SELECT NULL WHERE ((ref_1."varchar" ~~ ref_3."varchar") AND NULL)))) ON ((ref_0."varchar" ^@ ref_0."varchar")) LIMIT 103

Error Message

ABORT THROWN BY INTERNAL EXCEPTION: Failed to bind column reference "varchar" [11.2] (bindings: {#[30.0], #[30.1], #[30.2], #[30.3], #[30.4], #[30.5], #[30.6], #[30.7], #[30.8]})