1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
|
# name: test/sql/window/test_volatile_independence.test
# description: Window Sharing should distiguish identical volatile expressions
# group: [window]
# With chunk-level window parallelism, the order of evaluation changes with vector size
require vector_size 2048
set seed 0.8675309
query II
SELECT
list(random()) OVER (ORDER BY id),
max(random()) OVER (ORDER BY id)
FROM range(3) t(id);
----
[0.5232026142836782] 0.985522684201432
[0.5232026142836782, 0.47754610640283557] 0.985522684201432
[0.5232026142836782, 0.47754610640283557, 0.6947716273694302] 0.985522684201432
|
