1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
|
# name: test/issues/fuzz/encode_string_data_crash.test
# description: Issue #3350: SEGV in duckdb::EncodeStringDataPrefix
# group: [fuzz]
statement ok
PRAGMA enable_verification
statement ok
CREATE TABLE strings(b REAL, a INTEGER);
statement ok
INSERT INTO strings VALUES
(5, 10), (10, 20), (13, 26), (13, 26),
(15, 30), (20, 40), (22,80), (30, 90);
statement ok
CREATE TABLE id(c TEXT, strings_with_null INTEGER);
statement ok
INSERT INTO id VALUES('c', NULL);
query I
SELECT sum(a) OVER (
PARTITION BY (
SELECT c FROM id WHERE strings_with_null=a
) ORDER BY a
) FROM strings
ORDER BY 1
----
10
30
82
82
112
152
232
322
|
