Changeset: 8dfc9cf870ca for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=8dfc9cf870ca
Modified Files:
sql/test/BugTracker-2014/Tests/aggregates-intervals.Bug-3533.stable.out
sql/test/BugTracker-2019/Tests/avg-changes-value-scale.Bug-6783.stable.out
Branch: default
Log Message:
Approved output
diffs (51 lines):
diff --git
a/sql/test/BugTracker-2014/Tests/aggregates-intervals.Bug-3533.stable.out
b/sql/test/BugTracker-2014/Tests/aggregates-intervals.Bug-3533.stable.out
--- a/sql/test/BugTracker-2014/Tests/aggregates-intervals.Bug-3533.stable.out
+++ b/sql/test/BugTracker-2014/Tests/aggregates-intervals.Bug-3533.stable.out
@@ -30,17 +30,17 @@ stdout of test 'aggregates-intervals.Bug
#SELECT count(f1), cast(sum(f1) as bigint), avg(f1), median(f1), max(f1),
min(f1) FROM INTERVAL_TBL;
% sys.%1, sys.%2, sys.%3, sys.%4, sys.%5, sys.%6 # table_name
% %1, %2, %3, %4, %5, %6 # name
-% bigint, bigint, double, sec_interval, sec_interval, sec_interval #
type
-% 1, 2, 24, 5, 5, 5 # length
-[ 4, 10, 2.5, 2.000, 4.000, 1.000 ]
+% bigint, sec_interval, sec_interval, sec_interval, sec_interval,
sec_interval # type
+% 1, 6, 5, 5, 5, 5 # length
+[ 4, 10.000, 2.500, 2.000, 4.000, 1.000 ]
#CREATE TABLE INTERVAL_TBL2 (f1 interval month);
#INSERT INTO INTERVAL_TBL2 (f1) VALUES (1), (2), (3), (4);
[ 4 ]
#SELECT count(f1), cast(sum(f1) as bigint), avg(f1), median(f1), max(f1),
min(f1) FROM INTERVAL_TBL2;
% sys.%1, sys.%2, sys.%3, sys.%4, sys.%5, sys.%6 # table_name
% %1, %2, %3, %4, %5, %6 # name
-% bigint, bigint, double, month_interval, month_interval, month_interval
# type
-% 1, 2, 24, 1, 1, 1 # length
+% bigint, month_interval, month_interval, month_interval, month_interval,
month_interval # type
+% 1, 2, 1, 1, 1, 1 # length
[ 4, 10, 2.5, 2, 4, 1 ]
#SELECT median_avg(f1) from INTERVAL_TBL;
% sys.%1 # table_name
diff --git
a/sql/test/BugTracker-2019/Tests/avg-changes-value-scale.Bug-6783.stable.out
b/sql/test/BugTracker-2019/Tests/avg-changes-value-scale.Bug-6783.stable.out
--- a/sql/test/BugTracker-2019/Tests/avg-changes-value-scale.Bug-6783.stable.out
+++ b/sql/test/BugTracker-2019/Tests/avg-changes-value-scale.Bug-6783.stable.out
@@ -59,7 +59,7 @@ stdout of test 'avg-changes-value-scale.
#INSERT INTO bug6783 values ('1970-01-01 00:02:55.000000');
[ 1 ]
#SELECT t - SYS.STR_TO_TIMESTAMP('1970-01-01 00:00:00', '%Y-%m-%d %T') FROM
bug6783;
-% sys. # table_name
+% sys.%1 # table_name
% %1 # name
% sec_interval # type
% 7 # length
@@ -67,9 +67,9 @@ stdout of test 'avg-changes-value-scale.
#SELECT AVG(t - SYS.STR_TO_TIMESTAMP('1970-01-01 00:00:00', '%Y-%m-%d %T'))
FROM bug6783;
% sys.%1 # table_name
% %1 # name
-% double # type
-% 24 # length
-[ 175 ]
+% sec_interval # type
+% 7 # length
+[ 175.000 ]
#INSERT INTO bug6783 values (SYS.STR_TO_TIMESTAMP('0', '%s'));
[ 1 ]
#ROLLBACK;
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
