Merge pull request #11788 from ydb-platform/mergelibs-241120-1113

Library import 241120-1113

1 files changed, 21 insertions, 0 deletions

diff --git a/yql/essentials/tests/sql/suites/window/win_extract_members.sql b/yql/essentials/tests/sql/suites/window/win_extract_members.sql
new file mode 100644
index 0000000000..7785cf9eb9
--- /dev/null
+++ b/yql/essentials/tests/sql/suites/window/win_extract_members.sql
@@ -0,0 +1,21 @@
+/* postgres can not */
+use plato;
+
+$foo = (
+  select key, subkey, value,
+    sum(cast(subkey as uint32)) over w as sks
+  from Input
+  window w as (partition by key order by subkey)
+);
+
+$bar = (
+  select key, subkey,
+    sum(cast(subkey as uint32)) over w as sks, 
+    avg(cast(subkey as uint32)) over w as ska
+  from Input4
+  window w as (partition by key order by subkey)
+);
+       
+select key,subkey, value from $foo order by key, subkey;
+select key,ska from $bar order by key,ska;
+