Changeset: 4bcdb422d056 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=4bcdb422d056
Added Files:
sql/test/BugTracker-2015/Tests/sum_interval.Bug-3785.sql
Modified Files:
sql/common/sql_types.c
sql/test/BugTracker-2015/Tests/All
Branch: Jul2015
Log Message:
added fix and test for bug 3785
diffs (30 lines):
diff --git a/sql/common/sql_types.c b/sql/common/sql_types.c
--- a/sql/common/sql_types.c
+++ b/sql/common/sql_types.c
@@ -1390,6 +1390,8 @@ sqltypeinit( sql_allocator *sa)
sql_create_aggr(sa, "sum", "aggr", "sum", *t, *t);
sql_create_aggr(sa, "prod", "aggr", "prod", *t, *t);
}
+ sql_create_aggr(sa, "sum", "aggr", "sum", MONINT, MONINT);
+ sql_create_aggr(sa, "sum", "aggr", "sum", SECINT, SECINT);
/*
sql_create_aggr(sa, "avg", "aggr", "avg", BTE, DBL);
sql_create_aggr(sa, "avg", "aggr", "avg", SHT, DBL);
diff --git a/sql/test/BugTracker-2015/Tests/All
b/sql/test/BugTracker-2015/Tests/All
--- a/sql/test/BugTracker-2015/Tests/All
+++ b/sql/test/BugTracker-2015/Tests/All
@@ -51,3 +51,4 @@ apply_merge_distinct.Bug-3760
cardinality.Bug-3761
set_default_role.Bug-3364
useless_casts.Bug-3756
+sum_interval.Bug-3785
diff --git a/sql/test/BugTracker-2015/Tests/sum_interval.Bug-3785.sql
b/sql/test/BugTracker-2015/Tests/sum_interval.Bug-3785.sql
new file mode 100644
--- /dev/null
+++ b/sql/test/BugTracker-2015/Tests/sum_interval.Bug-3785.sql
@@ -0,0 +1,5 @@
+create table foo (a timestamp,b timestamp);
+insert into foo values ('2000-1-1','2001-1-1');
+select sum(b-a) from foo;
+drop table foo;
+select sum(i) from (select interval '1' day) x(i);
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
