Changeset: 16a3c6f572fa for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/16a3c6f572fa Removed Files: sql/test/mergetables/Tests/mergetable_rel_push_aggr_down.sql Modified Files: sql/server/rel_optimizer.c sql/test/mergetables/Tests/mergetable_rel_push_aggr_down.test Branch: Jul2021 Log Message:
Merged with Oct2020 diffs (38 lines): diff --git a/sql/test/mergetables/Tests/mergetable_rel_push_aggr_down.test b/sql/test/mergetables/Tests/mergetable_rel_push_aggr_down.test --- a/sql/test/mergetables/Tests/mergetable_rel_push_aggr_down.test +++ b/sql/test/mergetables/Tests/mergetable_rel_push_aggr_down.test @@ -69,5 +69,34 @@ select count(*) FROM ( 0 statement ok +create merge table merge_table (mcol1 int, mcol2 int, mcol3 int) + +statement ok +create table child1 (mcol1 int, mcol2 int, mcol3 int) + +statement ok rowcount 1 +insert into child1 values (1,1,1) + +statement ok +create table child2 (mcol1 int, mcol2 int, mcol3 int) + +statement ok rowcount 1 +insert into child2 values (2,2,2) + +statement ok +alter table merge_table add table child1 + +statement ok +alter table merge_table add table child2 + +query II nosort +select cast(sum(mcol1) as bigint), cast(sum(mcol2) as bigint) from merge_table group by mcol1, mcol2, mcol3 order by mcol1 limit 2 +---- +1 +1 +2 +2 + +statement ok rollback _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
