yql/essentials/tests/sql/suites/agg_apply/sum_decimal.sql


1
2
3
4
5
6
7

/* syntax version 1 */
/* postgres can not */
pragma EmitAggApply;

SELECT
    sum(key)
FROM (values (CAST("1.51" AS Decimal(10, 3))), (CAST("2.22" AS Decimal(10, 3))), (CAST("3.49" AS Decimal(10, 3)))) as a(key)