aboutsummaryrefslogtreecommitdiffstats
path: root/yql/essentials/tests/sql/suites/library/forward_import.sql
blob: 8e0b95d44c63d4b547c27e6e79175a6bc71b985c (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
/* postgres can not */
/* syntax version 1 */
PRAGMA Library("agg.sql");
PRAGMA Library("lib.sql");

IMPORT lib SYMBOLS $Square, $Agg_sum, $Agg_max;
SELECT $Square(2);

SELECT
  AGGREGATE_BY(x, $Agg_sum),
  AGGREGATE_BY(x, $Agg_max)
FROM (
  SELECT 2 AS x
  UNION ALL
  SELECT 3 AS x
)