yql/essentials/tests/sql/suites/aggregate/group_by_expr_persist_resource_fail.yql


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

/* custom error: Expected hashable and equatable type for key column */
PRAGMA FailOnNonPersistableFlattenAndAggrExprs;

SELECT
    FormatType(TypeOf(Some(DISTINCT DateTime::ShiftMonths(x, 1))))
FROM (
    SELECT
        CurrentUtcDate() AS x
);

SELECT
    FormatType(TypeOf(y))
FROM (
    SELECT
        CurrentUtcDate() AS x
)
GROUP BY
    DateTime::ShiftMonths(x, 1) AS y
;