Changeset: d6a360de69f3 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=d6a360de69f3 Added Files: sql/test/BugTracker-2016/Tests/consolidated_table.Bug-3954.sql Branch: default Log Message:
Add new test for bug 3954 diffs (25 lines): diff --git a/sql/test/BugTracker-2016/Tests/consolidated_table.Bug-3954.sql b/sql/test/BugTracker-2016/Tests/consolidated_table.Bug-3954.sql new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2016/Tests/consolidated_table.Bug-3954.sql @@ -0,0 +1,20 @@ +create table temp (t timestamp, sensor integer, val decimal(8,2)) ; + +insert into temp values(timestamp '2016-03-13 08:58:14', 1, 23.4); + +select * from temp; + +create table temp_aggregate(temp_total decimal(8,2), temp_count decimal(8,2)); +insert into temp_aggregate values(0.0,0.0); + +create procedure collect() +begin + update temp_aggregate + set temp_total = temp_total + (select sum(val) from temp), + temp_count = temp_count + (select count(*) from temp); +end; + +drop procedure collect; + +drop table temp; +drop table temp_aggregate; _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
