MonetDB: Nov2019 - Approved output and make test produce same ou...

[Pedro Ferreira]

Changeset: c5f28d8b77d9 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=c5f28d8b77d9
Modified Files:
        sql/test/BugTracker-2019/Tests/avg-changes-value-scale.Bug-6783.sql
        
sql/test/BugTracker-2019/Tests/avg-changes-value-scale.Bug-6783.stable.out
Branch: Nov2019
Log Message:

Approved output and make test produce same output independently of the current 
timezone


diffs (26 lines):

diff --git 
a/sql/test/BugTracker-2019/Tests/avg-changes-value-scale.Bug-6783.sql 
b/sql/test/BugTracker-2019/Tests/avg-changes-value-scale.Bug-6783.sql
--- a/sql/test/BugTracker-2019/Tests/avg-changes-value-scale.Bug-6783.sql
+++ b/sql/test/BugTracker-2019/Tests/avg-changes-value-scale.Bug-6783.sql
@@ -1,4 +1,6 @@
+START TRANSACTION;
 CREATE TABLE bug6783 (t TIMESTAMP);
-INSERT INTO bug6783 values ('1970-01-01 00:02:55.000000');
-SELECT t - SYS.STR_TO_TIMESTAMP('0', '%s') FROM bug6783;
-SELECT AVG(t - SYS.STR_TO_TIMESTAMP('0', '%s')) FROM bug6783;
+INSERT INTO bug6783 values (SYS.STR_TO_TIMESTAMP('1970-01-01 00:02:55', 
'%Y-%m-%d %T'));
+SELECT t - SYS.STR_TO_TIMESTAMP('1970-01-01 00:00:00', '%Y-%m-%d %T') FROM 
bug6783;
+SELECT AVG(t - SYS.STR_TO_TIMESTAMP('1970-01-01 00:00:00', '%Y-%m-%d %T')) 
FROM bug6783;
+ROLLBACK;
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
@@ -69,7 +69,8 @@ stdout of test 'avg-changes-value-scale.
 % L2 # name
 % double # type
 % 24 # length
-[ 1.75e+02     ]
+[ 175  ]
+#ROLLBACK;
 
 # 16:29:22 >  
 # 16:29:22 >  "Done."
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list