Merge branch 'rightlib' into mergelibs-241120-1113

1 files changed, 15 insertions, 0 deletions

diff --git a/yql/essentials/tests/sql/suites/window/win_over_few_partitions.sql b/yql/essentials/tests/sql/suites/window/win_over_few_partitions.sql
new file mode 100644
index 0000000000..20f59940d0
--- /dev/null
+++ b/yql/essentials/tests/sql/suites/window/win_over_few_partitions.sql
@@ -0,0 +1,15 @@
+/* postgres can not */
+$data = (select
+    cast(key as uint32) as age,
+    cast(key as uint32)/10 as age_decade,
+    cast(subkey as uint32) as region,
+    value as name
+from plato.Input);
+
+select
+  region, age, name, sum(age) over w1 as sum1, sum(age) over w2 as sum2
+from $data
+window
+  w1 as (partition by region order by name),
+  w2 as (partition by age_decade order by name)
+order by region, age;