>From Wail Alkowaileet <[email protected]>: 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 <[email protected]> Gerrit-MessageType: newchange
