Merge branch 'rightlib' into mergelibs-241120-1113

1 files changed, 11 insertions, 0 deletions

diff --git a/yql/essentials/tests/sql/suites/window/win_func_special.sql b/yql/essentials/tests/sql/suites/window/win_func_special.sql
new file mode 100644
index 0000000000..1dd68979b3
--- /dev/null
+++ b/yql/essentials/tests/sql/suites/window/win_func_special.sql
@@ -0,0 +1,11 @@
+/* postgres can not */
+$input=(select cast(key as int32) as key, cast(subkey as int32) as subkey, value from plato.Input);
+
+select
+  key,
+  (key - lag(key, 1) over w) as key_diff,
+  (subkey - lag(subkey, 1) over w) as subkey_diff,
+  row_number() over w as row,
+  value
+from $input
+window w as (order by key, subkey, value);