aboutsummaryrefslogtreecommitdiffstats
path: root/yql/essentials/tests/sql/suites/hor_join/out_range.sql
blob: c734fd9441ad907452ca8d0e861c86e5a67c7bd5 (plain) (blame)
1
2
3
4
5
6
7
8
/* postgres can not */
USE plato;

SELECT key, some(value) as s FROM Input GROUP BY key ORDER BY key, s;

SELECT key, sum(cast(subkey as Int32)) as s FROM Input WHERE key > "100" GROUP BY key ORDER BY key, s;

SELECT key, some(subkey) as s FROM Input WHERE key > "100" GROUP BY key ORDER BY key, s;