Merge branch 'rightlib' into mergelibs-241120-1113

1 files changed, 18 insertions, 0 deletions

diff --git a/yql/essentials/tests/sql/suites/window/row_number_to_map.sql b/yql/essentials/tests/sql/suites/window/row_number_to_map.sql
new file mode 100644
index 0000000000..914b36e574
--- /dev/null
+++ b/yql/essentials/tests/sql/suites/window/row_number_to_map.sql
@@ -0,0 +1,18 @@
+/* postgres can not */
+/* syntax version 1 */
+
+USE plato;
+
+SELECT key, subkey,
+       ROW_NUMBER() OVER w1 AS rn1,
+       ROW_NUMBER() OVER w2 AS rn2,
+       COUNT(*)     OVER w2 AS w2_cnt,
+       ROW_NUMBER() OVER w3 AS rn3,
+       ROW_NUMBER() OVER w4 AS rn4,
+FROM Input
+WINDOW
+       w1 AS (),
+       w2 AS (ORDER BY subkey      ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING),
+       w3 AS (ORDER BY subkey DESC ROWS BETWEEN 1 PRECEDING AND CURRENT ROW),
+       w4 AS (ROWS BETWEEN 1 PRECEDING AND CURRENT ROW)
+ORDER BY subkey;