Changeset: 72499ed3d589 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/72499ed3d589
Modified Files:
sql/test/Tests/window_functions.test
Branch: default
Log Message:
Added some ORDER BY-s to make the query results deterministic
diffs (50 lines):
diff --git a/sql/test/Tests/window_functions.test
b/sql/test/Tests/window_functions.test
--- a/sql/test/Tests/window_functions.test
+++ b/sql/test/Tests/window_functions.test
@@ -529,6 +529,7 @@ query II nosort
SELECT duration_seconds,
cast(SUM(duration_seconds) OVER (ORDER BY start_time) as int) AS
running_total
FROM tutorial.dc_bikeshare_q1_2012
+ ORDER BY running_total, duration_seconds
----
155
320
@@ -551,6 +552,7 @@ SELECT start_terminal,
AS running_total
FROM tutorial.dc_bikeshare_q1_2012
WHERE start_time < '2012-01-08'
+ ORDER BY start_terminal
----
AMS
55
@@ -691,7 +693,7 @@ query TTII nosort
SELECT start_terminal,
start_time,
duration_seconds,
- ROW_NUMBER() OVER (ORDER BY start_time)
+ ROW_NUMBER() OVER (ORDER BY start_time, duration_seconds)
AS row_number
FROM tutorial.dc_bikeshare_q1_2012
WHERE start_time < '2012-01-08'
@@ -726,7 +728,7 @@ SELECT start_terminal,
start_time,
duration_seconds,
ROW_NUMBER() OVER (PARTITION BY start_terminal
- ORDER BY start_time)
+ ORDER BY start_terminal, start_time,
duration_seconds)
AS row_number
FROM tutorial.dc_bikeshare_q1_2012
WHERE start_time < '2012-01-08'
@@ -760,10 +762,11 @@ query TII nosort
SELECT start_terminal,
duration_seconds,
RANK() OVER (PARTITION BY start_terminal
- ORDER BY start_time)
+ ORDER BY start_terminal, start_time)
AS rank
FROM tutorial.dc_bikeshare_q1_2012
WHERE start_time < '2012-01-08'
+ ORDER BY start_terminal, rank, duration_seconds
----
AMS
55
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
