1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
|
# name: test/fuzzer/duckfuzz/array_hash.test
# group: [duckfuzz]
statement ok
PRAGMA threads = 1
statement ok
PRAGMA enable_verification
# Duckfuzz Issue #1434
# Caused by not calculating the correct number of child elements when hashing a constant array vector.
statement ok
create table all_types as select * exclude(small_enum, medium_enum, large_enum) from test_all_types();
query I rowsort
SELECT subq_0.c2 AS c4 FROM (SELECT ref_1.fixed_nested_int_array AS c2 FROM main.all_types AS ref_0 LEFT JOIN main.all_types AS ref_1 ON ((ref_0."varchar" !~~* ref_1."varchar"))) AS subq_0 RIGHT JOIN main.all_types AS ref_2 ON ((subq_0.c2 = ref_2.fixed_nested_int_array))
----
NULL
[[4, 5, 6], [NULL, 2, 3], [4, 5, 6]]
[[4, 5, 6], [NULL, 2, 3], [4, 5, 6]]
[[NULL, 2, 3], NULL, [NULL, 2, 3]]
|
