aboutsummaryrefslogtreecommitdiffstats
path: root/yql/essentials/tests/sql/suites/window/full/syscolumns.sql
blob: d2533c062bfbefa446496787fa2fd2452feb38e6 (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
/* syntax version 1 */
/* postgres can not */
use plato;

select
  value,
  max(value) over (partition by cast(TableName() as Utf8)),
  cast(TableName()  as Utf8),
from Input order by value;

select
  value,
  max(value) over (order by cast(TableName() as Utf8) rows between unbounded preceding and unbounded following),
  cast(TableName()  as Utf8),
from Input order by value;