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 "delim_index" [47.0] (bindings: {#[0.0], #[0.1], #[8.0], #[8.1], #[8.2], #[8.3], #[8.4], #[8.5], #[8.6], #[8.7], #[8.8], #[8.9]}) #3168

Closed fuzzerofducks closed 1 month ago

fuzzerofducks commented 1 month ago

Issue found by SQLSmith on git commit hash dd9e6 using seed 649928734.

To Reproduce

create table all_types as select * exclude(small_enum, medium_enum, large_enum) from test_all_types();
SELECT NULL FROM (SELECT ref_0."union" AS c3 FROM main.all_types AS ref_0 INNER JOIN main.all_types INNER JOIN main.all_types AS ref_2 ON (1) RIGHT JOIN main.all_types AS ref_3 ON (0) ON (1) INNER JOIN main.all_types AS ref_4 LEFT JOIN main.all_types AS ref_5 ON ((ref_5."varchar" ~~~ ref_5."varchar")) INNER JOIN main.all_types AS ref_6 ON (EXISTS(SELECT ref_4."time" AS c0, ref_6.timestamptz_array AS c1, ref_7.timestamp_s AS c2, ref_4.blob AS c3, ref_7.hugeint AS c4, 99 AS c5 FROM main.all_types AS ref_7 WHERE 0 LIMIT 124)) ON (EXISTS(SELECT ref_4.dec_4_1 AS c0, ref_4.bool AS c1, ref_6.ubigint AS c2 FROM main.all_types AS ref_8 WHERE (ref_8.fixed_nested_varchar_array IS NOT NULL) LIMIT 110)) WHERE ref_0."varchar") WHERE ((SELECT "varchar" FROM main.all_types) ~~* (SELECT "varchar" FROM main.all_types))

Error Message

ABORT THROWN BY INTERNAL EXCEPTION: Failed to bind column reference "delim_index" [47.0] (bindings: {#[0.0], #[0.1], #[8.0], #[8.1], #[8.2], #[8.3], #[8.4], #[8.5], #[8.6], #[8.7], #[8.8], #[8.9]})