Merge branch 'rightlib' into mergelibs-241120-1113

1 files changed, 18 insertions, 0 deletions

diff --git a/yql/essentials/tests/sql/suites/pg/select_win_frame.sql b/yql/essentials/tests/sql/suites/pg/select_win_frame.sql
new file mode 100644
index 0000000000..beb43d6d8a
--- /dev/null
+++ b/yql/essentials/tests/sql/suites/pg/select_win_frame.sql
@@ -0,0 +1,18 @@
+--!syntax_pg
+select 
+x,
+sum(x) over (order by x rows between unbounded preceding and 1 preceding) as upp,
+sum(x) over (order by x rows between unbounded preceding and current row) as upc,
+sum(x) over (order by x rows between unbounded preceding and 1 following) as upf,
+sum(x) over (order by x rows between unbounded preceding and unbounded following) as upuf,
+sum(x) over (order by x rows between 2 preceding and 1 preceding) as pp,
+sum(x) over (order by x rows between 2 preceding and current row) as pc,
+sum(x) over (order by x rows between 2 preceding and 1 following) as pf,
+sum(x) over (order by x rows between 2 preceding and unbounded following) as puf,
+sum(x) over (order by x rows between current row and current row) as cc,
+sum(x) over (order by x rows between current row and 1 following) as cf,
+sum(x) over (order by x rows between current row and unbounded following) as cuf,
+sum(x) over (order by x rows between 1 following and 2 following) as ff,
+sum(x) over (order by x rows between 1 following and unbounded following) as fuf
+from (values (1),(2),(3),(4),(5),(6),(7)) a(x)
+