Changeset: 7773cb94a10d for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/7773cb94a10d
Modified Files:
sql/test/Tests/window_functions.test
Branch: default
Log Message:
order output
diffs (58 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
@@ -552,7 +552,7 @@ SELECT start_terminal,
AS running_total
FROM tutorial.dc_bikeshare_q1_2012
WHERE start_time < '2012-01-08'
- ORDER BY start_terminal
+ ORDER BY start_terminal, duration_seconds, running_total
----
AMS
55
@@ -564,12 +564,12 @@ DIEMEN
155
320
DIEMEN
+155
+640
+DIEMEN
165
320
DIEMEN
-155
-640
-DIEMEN
165
640
@@ -657,6 +657,7 @@ SELECT start_terminal,
AS running_avg
FROM tutorial.dc_bikeshare_q1_2012
WHERE start_time < '2012-01-08'
+ORDER BY start_terminal, duration_seconds, running_total
----
AMS
55
@@ -674,16 +675,16 @@ 320
2
160.000
DIEMEN
+155
+640
+4
+160.000
+DIEMEN
165
320
2
160.000
DIEMEN
-155
-640
-4
-160.000
-DIEMEN
165
640
4
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
