yql/essentials/tests/sql/suites/window/win_range_int_optional_fail.yql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22

PRAGMA WindowNewPipeline;

/* custom error: Error while processing RANGE bound */
/* custom error: Cannot add type Int32 and Optional<String> */
$data = [
    <|a: 1, count: 1|>,
    <|a: 2, count: 1|>,
    <|a: 3, count: 1|>,
];

SELECT
    COUNT(*) OVER w1 AS actual_count,
    count,
FROM
    AS_TABLE($data)
WINDOW
    w1 AS (
        ORDER BY
            a ASC
        RANGE BETWEEN Just('1') PRECEDING AND 1 FOLLOWING
    )
;