PRAGMA WindowNewPipeline;

/* custom error: Error while processing RANGE bound */
/* custom error: Cannot add type Optional<Int32> and String */

$data = [
    <|a: null, count: 1|>,
    <|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 "1" PRECEDING AND "1" FOLLOWING
    )