PRAGMA WindowNewPipeline;

/* custom error: Range frame for non numeric expressions is only allowed to be UNBOUNDED PRECEDING AND CURRENT ROW */

$data = [
    <|a: "apple", b: 1, count: 1|>,
    <|a: "banana", b: 1, count: 2|>,
];

SELECT
    COUNT(*) OVER w1 AS actual_count,
    count,
FROM
    AS_TABLE($data)
WINDOW
    w1 AS (
        PARTITION COMPACT BY
            b
        ORDER BY
            a ASC
        RANGE BETWEEN CURRENT ROW AND CURRENT ROW
    )