Merge branch 'rightlib' into mergelibs-241120-1113

1 files changed, 20 insertions, 0 deletions

diff --git a/yql/essentials/tests/sql/suites/window/distinct_over_window.sql b/yql/essentials/tests/sql/suites/window/distinct_over_window.sql
new file mode 100644
index 0000000000..536db81911
--- /dev/null
+++ b/yql/essentials/tests/sql/suites/window/distinct_over_window.sql
@@ -0,0 +1,20 @@
+/* syntax version 1 */
+/* postgres can not */
+
+USE plato;
+
+PRAGMA DistinctOverWindow;
+
+$input = (SELECT cast(key AS Int32) AS key, cast(subkey AS Int32) AS subkey, value FROM Input);
+
+SELECT
+    subkey,
+    key,
+    value,
+    -- assuming ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW
+    count(DISTINCT key) OVER (PARTITION BY subkey ORDER BY key) AS count_by_key,
+    count(DISTINCT value || "force_preagg") OVER (PARTITION BY subkey ORDER BY key) AS count_by_value,
+    sum(DISTINCT key) OVER (PARTITION BY subkey ORDER BY key) AS sum,
+    median(DISTINCT key) OVER (PARTITION BY subkey ORDER BY key) AS median,
+FROM $input
+ORDER BY subkey, key, value;