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" [13.4] (bindings: {#[3.0], #[3.1], #[4.0], #[4.1], #[4.2], #[4.3], #[5.0], #[70.0]}) #3200

Closed fuzzerofducks closed 1 month ago

fuzzerofducks commented 1 month ago

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

To Reproduce

create table all_types as select * exclude(small_enum, medium_enum, large_enum) from test_all_types() limit 0;
SELECT CASE  WHEN (NULL) THEN ((SELECT NULL)) ELSE (SELECT NULL) END AS c0, (SELECT NULL) AS c1, (SELECT NULL) AS c4 FROM main.all_types AS ref_0 INNER JOIN (SELECT (SELECT NULL) AS c0, ref_4.timestamp_ns AS c1, ref_4.fixed_array_of_int_list AS c2, ref_4.fixed_int_array AS c3 FROM main.all_types AS ref_1 LEFT JOIN main.all_types AS ref_2 ON ((ref_1.timestamp_tz = ref_2.timestamp_tz)) INNER JOIN main.all_types AS ref_3 LEFT JOIN main.all_types AS ref_4 INNER JOIN main.all_types AS ref_5 ON ((ref_4."varchar" ^@ CAST(NULL AS VARCHAR))) ON ((ref_4."varchar" ~~* ref_5."varchar")) ON ((ref_2.fixed_array_of_int_list = ref_3.fixed_array_of_int_list)) WHERE EXISTS(SELECT NULL, ref_3.fixed_int_array AS c1, ref_1.uhugeint AS c2 WHERE 0 LIMIT 104) LIMIT 80) ON ((ref_0."varchar" ~~~ (SELECT "varchar" FROM main.all_types LIMIT 1 OFFSET 4))) LIMIT 126

Error Message

ABORT THROWN BY INTERNAL EXCEPTION: Failed to bind column reference "c2" [13.4] (bindings: {#[3.0], #[3.1], #[4.0], #[4.1], #[4.2], #[4.3], #[5.0], #[70.0]})