This is an automated email from the ASF dual-hosted git repository.
zstan pushed a commit to branch main
in repository https://gitbox.apache.org/repos/asf/ignite-3.git
The following commit(s) were added to refs/heads/main by this push:
new a760caf4f1 IGNITE-21967: Extend test coverage for SQL E091-06 (Set
functions. ALL quantifier) (#3876)
a760caf4f1 is described below
commit a760caf4f122b08e91b2801b383cae04f01e75cb
Author: Max Zhuravkov <[email protected]>
AuthorDate: Wed Jun 5 16:48:38 2024 +0300
IGNITE-21967: Extend test coverage for SQL E091-06 (Set functions. ALL
quantifier) (#3876)
---
.../sql/aggregate/aggregates/test_agg_all.test | 44 ++++++++++++++++++++++
1 file changed, 44 insertions(+)
diff --git
a/modules/sql-engine/src/integrationTest/sql/aggregate/aggregates/test_agg_all.test
b/modules/sql-engine/src/integrationTest/sql/aggregate/aggregates/test_agg_all.test
new file mode 100644
index 0000000000..5966a6c898
--- /dev/null
+++
b/modules/sql-engine/src/integrationTest/sql/aggregate/aggregates/test_agg_all.test
@@ -0,0 +1,44 @@
+# name: test/sql/aggregate/aggregates/test_agg_all.test
+# description: Set functions. ALL quantifier
+# feature SQL E091-06 - Set functions. ALL quantifier
+# group: [aggregates]
+
+query I
+SELECT sum(ALL s1) FROM (VALUES (1),(2),(3)) t1(s1)
+----
+6
+
+query I
+SELECT AVG(ALL s1) FROM (VALUES (1),(2),(3)) t1(s1)
+----
+2
+
+query I
+SELECT COUNT(ALL s1) FROM (VALUES (1),(2),(3)) t1(s1)
+----
+3
+
+query I
+SELECT MIN(ALL s1) FROM (VALUES (1),(2),(3)) t1(s1)
+----
+1
+
+query I
+SELECT EVERY(ALL s1) FROM (VALUES (true), (false)) t1(s1)
+----
+false
+
+query I
+SELECT MAX(ALL s1) FROM (VALUES (1),(2),(3)) t1(s1)
+----
+3
+
+query I
+SELECT SOME(ALL s1) FROM (VALUES (false),(true),(false)) t1(s1)
+----
+true
+
+query I
+SELECT ANY_VALUE(ALL s1) FROM (VALUES (2), (4), (1)) t1(s1)
+----
+2
\ No newline at end of file
