1
2
3
4
5
6
7
8
9
10
11
12
13
|
# name: test/fuzzer/duckfuzz/window_null_range.test
# description: Negate extreme window statistics.
# group: [duckfuzz]
statement ok
create table all_types as select * exclude(small_enum, medium_enum, large_enum)
from test_all_types();
statement error
SELECT percent_rank() OVER (PARTITION BY c21 ORDER BY c37 ASC NULLS FIRST RANGE BETWEEN NULL FOLLOWING AND UNBOUNDED FOLLOWING)
FROM all_types AS t43(c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15, c16, c17, c18, c19, c20, c21, c22, c23, c24, c25, c26, c27, c28, c29, c30, c31, c32, c33, c34, c35, c36, c37, c38, c39, c40, c41, c42)
----
Window RANGE expressions cannot be NULL
|
