Changeset: 54c54e40204e for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/54c54e40204e
Added Files:
sql/test/2023/Tests/any_value.test
Modified Files:
sql/test/2023/Tests/All
Branch: literal_features
Log Message:
add any_value test
diffs (41 lines):
diff --git a/sql/test/2023/Tests/All b/sql/test/2023/Tests/All
--- a/sql/test/2023/Tests/All
+++ b/sql/test/2023/Tests/All
@@ -1,2 +1,3 @@
literals
btrim
+any_value
diff --git a/sql/test/2023/Tests/any_value.test
b/sql/test/2023/Tests/any_value.test
new file mode 100644
--- /dev/null
+++ b/sql/test/2023/Tests/any_value.test
@@ -0,0 +1,29 @@
+statement ok
+CREATE TABLE foo(i, j) AS VALUES (10, 1), (20, 2), (30, 1), (20, 2), (40, 1);
+
+query I rowsort
+SELECT any_value(i) FROM foo;
+----
+10
+
+query II rowsort
+SELECT any_value(i), j FROM foo GROUP BY j;
+----
+10
+1
+20
+2
+
+query II rowsort
+SELECT i, any_value(i) OVER (ORDER BY i) FROM foo;
+----
+10
+10
+20
+10
+20
+10
+30
+10
+40
+10
_______________________________________________
checkin-list mailing list -- checkin-list@monetdb.org
To unsubscribe send an email to checkin-list-le...@monetdb.org
