Changeset: fc5a97586856 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=fc5a97586856
Modified Files:
        sql/test/Tests/fsum.sql
        sql/test/Tests/fsum.stable.out
Branch: Mar2018
Log Message:

Add one more test.


diffs (36 lines):

diff --git a/sql/test/Tests/fsum.sql b/sql/test/Tests/fsum.sql
--- a/sql/test/Tests/fsum.sql
+++ b/sql/test/Tests/fsum.sql
@@ -3133,7 +3133,7 @@ 0.001004016064257028 16
 0.001002004008016032 16
 -0.001001001001001001 16
 0.001 16
-select gid, sum(val) from t where gid in (0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 
11, 12, 13, 15, 16, 17, 18, 19, 22, 23, 31, 33, 35, 37, 39, 40) group by gid 
order by gid;
+select gid, sum(val) from t where gid in (0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 
11, 12, 13, 15, 16, 17, 18, 19, 22, 23, 31, 33, 35, 37, 39, 40, 41) group by 
gid order by gid;
 -- these should all produce overflow
 select sum(val) from t where gid = 14;
 select sum(val) from t where gid = 20;
diff --git a/sql/test/Tests/fsum.stable.out b/sql/test/Tests/fsum.stable.out
--- a/sql/test/Tests/fsum.stable.out
+++ b/sql/test/Tests/fsum.stable.out
@@ -49,9 +49,9 @@ Ready.
 #1.0 15
 #8.988465674311579e+307 25
 [ 3131 ]
-#select gid, sum(val) from t where gid in (0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 
11, 12, 13, 15, 16, 17, 18, 19, 22, 31, 33, 39, 40) group by gid order by gid;
-% sys.t,       sys.L5 # table_name
-% gid, L4 # name
+#select gid, sum(val) from t where gid in (0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 
11, 12, 13, 15, 16, 17, 18, 19, 22, 23, 31, 33, 35, 37, 39, 40, 41) group by 
gid order by gid;
+% sys.t,       sys.L3 # table_name
+% gid, L3 # name
 % int, double # type
 % 2,   24 # length
 [ 1,   0       ]
@@ -80,6 +80,7 @@ Ready.
 [ 37,  -1.797693135e+308       ]
 [ 39,  1.797693135e+308        ]
 [ 40,  1.697693135e+308        ]
+[ 41,  1e+16   ]
 #drop table t;
 
 # 10:54:43 >  
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list

Reply via email to