Changeset: dad861dd483b for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=dad861dd483b
Modified Files:
sql/test/Tests/window_functions.sql
sql/test/Tests/window_functions.stable.out
Branch: sq2default
Log Message:
Downcast to integers so 128-bit and non 128-bit builds give the same label
output
diffs (93 lines):
diff --git a/sql/test/Tests/window_functions.sql
b/sql/test/Tests/window_functions.sql
--- a/sql/test/Tests/window_functions.sql
+++ b/sql/test/Tests/window_functions.sql
@@ -103,13 +103,13 @@ INSERT INTO tutorial.dc_bikeshare_q1_201
SELECT * FROM tutorial.dc_bikeshare_q1_2012;
SELECT duration_seconds,
- cast(SUM(duration_seconds) OVER (ORDER BY start_time) as bigint) AS
running_total
+ cast(SUM(duration_seconds) OVER (ORDER BY start_time) as int) AS
running_total
FROM tutorial.dc_bikeshare_q1_2012;
SELECT start_terminal,
duration_seconds,
cast(SUM(duration_seconds) OVER
- (PARTITION BY start_terminal ORDER BY start_time) as bigint)
+ (PARTITION BY start_terminal ORDER BY start_time) as int)
AS running_total
FROM tutorial.dc_bikeshare_q1_2012
WHERE start_time < '2012-01-08';
@@ -117,14 +117,14 @@ SELECT start_terminal,
SELECT start_terminal,
duration_seconds,
cast(SUM(duration_seconds) OVER
- (PARTITION BY start_terminal) as bigint) AS start_terminal_total
+ (PARTITION BY start_terminal) as int) AS start_terminal_total
FROM tutorial.dc_bikeshare_q1_2012
WHERE start_time < '2012-01-08';
SELECT start_terminal,
duration_seconds,
cast(SUM(duration_seconds) OVER
- (PARTITION BY start_terminal) as bigint) AS running_total,
+ (PARTITION BY start_terminal) as int) AS running_total,
COUNT(duration_seconds) OVER
(PARTITION BY start_terminal) AS running_count,
AVG(duration_seconds) OVER
@@ -135,7 +135,7 @@ SELECT start_terminal,
SELECT start_terminal,
duration_seconds,
cast(SUM(duration_seconds) OVER
- (PARTITION BY start_terminal ORDER BY start_time) as bigint)
+ (PARTITION BY start_terminal ORDER BY start_time) as int)
AS running_total,
COUNT(duration_seconds) OVER
(PARTITION BY start_terminal ORDER BY start_time)
diff --git a/sql/test/Tests/window_functions.stable.out
b/sql/test/Tests/window_functions.stable.out
--- a/sql/test/Tests/window_functions.stable.out
+++ b/sql/test/Tests/window_functions.stable.out
@@ -206,7 +206,7 @@ stdout of test 'window_functions` in dir
# FROM tutorial.dc_bikeshare_q1_2012;
% tutorial.dc_bikeshare_q1_2012, tutorial.%6 # table_name
% duration_seconds, running_total # name
-% int, bigint # type
+% int, int # type
% 3, 3 # length
[ 155, 320 ]
[ 165, 320 ]
@@ -223,7 +223,7 @@ stdout of test 'window_functions` in dir
# WHERE start_time < '2012-01-08';
% tutorial.dc_bikeshare_q1_2012, tutorial.dc_bikeshare_q1_2012,
tutorial.%7 # table_name
% start_terminal, duration_seconds, running_total # name
-% varchar, int, bigint # type
+% varchar, int, int # type
% 6, 3, 3 # length
[ "AMS", 55, 120 ]
[ "AMS", 65, 120 ]
@@ -239,7 +239,7 @@ stdout of test 'window_functions` in dir
# WHERE start_time < '2012-01-08';
% tutorial.dc_bikeshare_q1_2012, tutorial.dc_bikeshare_q1_2012,
tutorial.%7 # table_name
% start_terminal, duration_seconds, start_terminal_total # name
-% varchar, int, bigint # type
+% varchar, int, int # type
% 6, 3, 3 # length
[ "AMS", 55, 120 ]
[ "AMS", 65, 120 ]
@@ -259,7 +259,7 @@ stdout of test 'window_functions` in dir
# WHERE start_time < '2012-01-08';
% tutorial.dc_bikeshare_q1_2012, tutorial.dc_bikeshare_q1_2012,
tutorial.%13, tutorial.%14, tutorial.%15 # table_name
% start_terminal, duration_seconds, running_total, running_count,
running_avg # name
-% varchar, int, bigint, bigint, double # type
+% varchar, int, int, bigint, double # type
% 6, 3, 3, 1, 24 # length
[ "AMS", 55, 120, 2, 60 ]
[ "AMS", 65, 120, 2, 60 ]
@@ -282,7 +282,7 @@ stdout of test 'window_functions` in dir
# WHERE start_time < '2012-01-08';
% tutorial.dc_bikeshare_q1_2012, tutorial.dc_bikeshare_q1_2012,
tutorial.%13, tutorial.%14, tutorial.%15 # table_name
% start_terminal, duration_seconds, running_total, running_count,
running_avg # name
-% varchar, int, bigint, bigint, double # type
+% varchar, int, int, bigint, double # type
% 6, 3, 3, 1, 24 # length
[ "AMS", 55, 120, 2, 60 ]
[ "AMS", 65, 120, 2, 60 ]
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
