Repository: asterixdb Updated Branches: refs/heads/master f2c18aa96 -> 82e1105f3
[NO ISSUE] Improve stability of window function tests - user model changes: no - storage format changes: no - interface changes: no Details: - Add ORDER BY to some window function tests to make their results deterministic Change-Id: Ibf0858074a75d2169c1f1974585ce1c5ddb32b50 Reviewed-on: https://asterix-gerrit.ics.uci.edu/3104 Sonar-Qube: Jenkins <[email protected]> Integration-Tests: Jenkins <[email protected]> Tested-by: Jenkins <[email protected]> Contrib: Jenkins <[email protected]> Reviewed-by: Ali Alsuliman <[email protected]> Project: http://git-wip-us.apache.org/repos/asf/asterixdb/repo Commit: http://git-wip-us.apache.org/repos/asf/asterixdb/commit/82e1105f Tree: http://git-wip-us.apache.org/repos/asf/asterixdb/tree/82e1105f Diff: http://git-wip-us.apache.org/repos/asf/asterixdb/diff/82e1105f Branch: refs/heads/master Commit: 82e1105f33713238ab913aab3e54643924c801de Parents: f2c18aa Author: Dmitry Lychagin <[email protected]> Authored: Thu Jan 3 13:59:26 2019 -0800 Committer: Dmitry Lychagin <[email protected]> Committed: Thu Jan 3 18:10:58 2019 -0800 ---------------------------------------------------------------------- .../runtimets/queries_sqlpp/window/pg_win/pg_win.82.query.sqlpp | 4 +++- .../runtimets/queries_sqlpp/window/pg_win/pg_win.83.query.sqlpp | 4 +++- 2 files changed, 6 insertions(+), 2 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/asterixdb/blob/82e1105f/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/window/pg_win/pg_win.82.query.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/window/pg_win/pg_win.82.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/window/pg_win/pg_win.82.query.sqlpp index fc86522..e3421ec 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/window/pg_win/pg_win.82.query.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/window/pg_win/pg_win.82.query.sqlpp @@ -24,5 +24,7 @@ use test; FROM (SELECT VALUE tenk1 FROM tenk1 WHERE unique2 < 10 ORDER BY four, ten LIMIT 10) s -SELECT last_value(ten) OVER (PARTITION BY four) AS `last_value`, ten, four +SELECT + last_value(ten) OVER (PARTITION BY four ORDER BY ten ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) AS `last_value`, + ten, four ORDER BY four, ten; \ No newline at end of file http://git-wip-us.apache.org/repos/asf/asterixdb/blob/82e1105f/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/window/pg_win/pg_win.83.query.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/window/pg_win/pg_win.83.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/window/pg_win/pg_win.83.query.sqlpp index ea44416..2f854ce 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/window/pg_win/pg_win.83.query.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/window/pg_win/pg_win.83.query.sqlpp @@ -24,7 +24,9 @@ use test; FROM (SELECT VALUE tenk1 FROM tenk1 WHERE unique2 < 10 ORDER BY four, ten LIMIT 10) s -SELECT nth_value(ten, four + 1) OVER (PARTITION BY four) AS `nth_value`, ten, four +SELECT + nth_value(ten, four + 1) OVER (PARTITION BY four ORDER BY ten ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) AS `nth_value`, + ten, four ORDER BY four, ten
