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
|
# name: test/sql/window/test_window_wide_frame.test_slow
# description: Test wide temporal range frames
# group: [window]
statement ok
PRAGMA enable_verification
set seed 0.618033
statement ok
CREATE TABLE flog AS
SELECT (random() * 100)::INTEGER AS laufzeit
, TIMESTAMP '2020-10-15 16:45:00' + INTERVAL (random() * 15 * 60) SECOND AS "timestamp"
FROM range(26000);
query III
select timestamp
, median(laufzeit) over w
, count(*) over w
from flog
window w as (order by timestamp asc range between interval 55 seconds preceding and interval 58 seconds following)
order by 3 desc, 1
limit 1;
----
2020-10-15 16:54:37.416129 49.5 3376
|
