You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@asterixdb.apache.org by AsterixDB Code Review <do...@asterix-gerrit.ics.uci.edu> on 2023/12/05 21:11:14 UTC
Change in asterixdb[master]: [NO ISSUE][TEST] Stabilize group-by: sugar-01-negative
From Wail Alkowaileet <wa...@gmail.com>:
Wail Alkowaileet has uploaded this change for review. ( https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/17999 )
Change subject: [NO ISSUE][TEST] Stabilize group-by: sugar-01-negative
......................................................................
[NO ISSUE][TEST] Stabilize group-by: sugar-01-negative
- user model changes: no
- storage format changes: no
- interface changes: no
Details:
Make the result of group-by: sugar-01-negative deterministic
Change-Id: Id15668aa13e401e5d59bdf5fc582374b5b245eba
---
M asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/group-by/sugar-01-negative/sugar-01-negative.3.query.sqlpp
1 file changed, 23 insertions(+), 2 deletions(-)
git pull ssh://asterix-gerrit.ics.uci.edu:29418/asterixdb refs/changes/99/17999/1
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/group-by/sugar-01-negative/sugar-01-negative.3.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/group-by/sugar-01-negative/sugar-01-negative.3.query.sqlpp
index 523e8ed..c28fbe7 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/group-by/sugar-01-negative/sugar-01-negative.3.query.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/group-by/sugar-01-negative/sugar-01-negative.3.query.sqlpp
@@ -23,5 +23,10 @@
// cannot be used like a SQL-92 sugar, e.g., AVG. Its input must be a collection.
FROM Employee e
GROUP BY e.deptno AS deptno GROUP AS g
-SELECT deptno AS deptno, STRICT_AVG(g[0].e.salary) AS avgpay,
- (SELECT i.e.name AS name, i.e.salary AS salary FROM g AS i) AS workers;
+SELECT deptno AS deptno,
+ STRICT_AVG(g[0].e.salary) AS avgpay,
+ (
+ SELECT i.e.name AS name, i.e.salary AS salary
+ FROM g AS i
+ ORDER BY i.e.salary
+ ) AS workers;
--
To view, visit https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/17999
To unsubscribe, or for help writing mail filters, visit https://asterix-gerrit.ics.uci.edu/settings
Gerrit-Project: asterixdb
Gerrit-Branch: master
Gerrit-Change-Id: Id15668aa13e401e5d59bdf5fc582374b5b245eba
Gerrit-Change-Number: 17999
Gerrit-PatchSet: 1
Gerrit-Owner: Wail Alkowaileet <wa...@gmail.com>
Gerrit-MessageType: newchange