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
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
|
# name: test/sql/window/test_negative_range.test
# description: Check that negative ranges trigger errors
# group: [window]
statement ok
PRAGMA enable_verification
statement ok
CREATE OR REPLACE TABLE issue10855(i INTEGER, v FLOAT);
statement ok
INSERT INTO issue10855 VALUES (0, 1), (1, 2), (2, 3),;
# Ascending
statement error
SELECT i, v, sum(v) OVER (ORDER BY i RANGE BETWEEN 1 PRECEDING AND -1 FOLLOWING)
FROM issue10855
----
Out of Range Error: Invalid RANGE FOLLOWING value
statement error
SELECT i, v, sum(v) OVER (ORDER BY i RANGE BETWEEN -1 FOLLOWING AND 1 FOLLOWING)
FROM issue10855
----
Out of Range Error: Invalid RANGE FOLLOWING value
statement error
SELECT i, v, sum(v) OVER (ORDER BY i RANGE BETWEEN -1 PRECEDING AND 1 FOLLOWING)
FROM issue10855
----
Out of Range Error: Invalid RANGE PRECEDING value
statement error
SELECT i, v, sum(v) OVER (ORDER BY i RANGE BETWEEN 1 PRECEDING AND -1 PRECEDING)
FROM issue10855
----
Out of Range Error: Invalid RANGE PRECEDING value
# Descending
statement error
SELECT i, v, sum(v) OVER (ORDER BY i DESC RANGE BETWEEN 1 PRECEDING AND -1 FOLLOWING)
FROM issue10855
----
Out of Range Error: Invalid RANGE FOLLOWING value
statement error
SELECT i, v, sum(v) OVER (ORDER BY i DESC RANGE BETWEEN -1 FOLLOWING AND 1 FOLLOWING)
FROM issue10855
----
Out of Range Error: Invalid RANGE FOLLOWING value
statement error
SELECT i, v, sum(v) OVER (ORDER BY i DESC RANGE BETWEEN -1 PRECEDING AND 1 FOLLOWING)
FROM issue10855
----
Out of Range Error: Invalid RANGE PRECEDING value
statement error
SELECT i, v, sum(v) OVER (ORDER BY i DESC RANGE BETWEEN 1 PRECEDING AND -1 PRECEDING)
FROM issue10855
----
Out of Range Error: Invalid RANGE PRECEDING value
|
