Changeset: 7adffed6a10e for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=7adffed6a10e Added Files: sql/test/BugTracker-2017/Tests/update_on_procedure.Bug-6479.sql Modified Files: sql/test/BugTracker-2017/Tests/All Branch: Jul2017 Log Message:
Added test for bug 6479 diffs (29 lines): diff --git a/sql/test/BugTracker-2017/Tests/All b/sql/test/BugTracker-2017/Tests/All --- a/sql/test/BugTracker-2017/Tests/All +++ b/sql/test/BugTracker-2017/Tests/All @@ -95,3 +95,4 @@ HAVE_LIBPY?python_loader_clobbers_defaul skip_problem_best_effort.Bug-6442 date_to_str.Bug-6467 cleanup_statistics.Bug-6439 +update_on_procedure.Bug-6479.sql diff --git a/sql/test/BugTracker-2017/Tests/update_on_procedure.Bug-6479.sql b/sql/test/BugTracker-2017/Tests/update_on_procedure.Bug-6479.sql new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2017/Tests/update_on_procedure.Bug-6479.sql @@ -0,0 +1,16 @@ +create table stmp10 (t timestamp, sensor integer, val decimal(8,2)); +create table tmp_aggregate(tmp_total decimal(8,2), tmp_count decimal(8,2)); +insert into tmp_aggregate values(0.0,0.0); + +create procedure cq_collector() +begin + update tmp_aggregate + set tmp_total = tmp_total + (select sum(val) from sys.stmp10), + tmp_count = tmp_count + (select count(*) from sys.stmp10); +end; + +call cq_collector(); + +drop procedure cq_collector; +drop table stmp10; +drop table tmp_aggregate; _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
