Changeset: 94030f54b867 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=94030f54b867 Removed Files: sql/test/centipede/Tests/selectcount.sql Modified Files: sql/test/centipede/Tests/All sql/test/centipede/Tests/olap.sql Branch: default Log Message:
reduce superflous test diffs (68 lines): diff --git a/sql/test/centipede/Tests/All b/sql/test/centipede/Tests/All --- a/sql/test/centipede/Tests/All +++ b/sql/test/centipede/Tests/All @@ -1,2 +1,1 @@ -selectcount olap diff --git a/sql/test/centipede/Tests/olap.sql b/sql/test/centipede/Tests/olap.sql --- a/sql/test/centipede/Tests/olap.sql +++ b/sql/test/centipede/Tests/olap.sql @@ -4,32 +4,13 @@ create table Sc(a int, b int); insert into Rc values (1,1), (2,3), (2,4), (2,5), (3,3); insert into Sc values (1,1), (1,3); +select * from Rc; +select * from Sc; + set optimizer='centipede_pipe'; - -explain select count(*) from Rc group by i; -explain select count(*) from Rc group by j; -explain select count(*) from Sc group by a; -explain select count(*) from Sc group by b; - -explain select i,sum(j) from Rc group by i; -explain select j,sum(i) from Rc group by j; -explain select b,sum(b) from Sc group by a; -explain select a,sum(a) from Sc group by b; - -explain select j,avg(j) from Rc group by i; -explain select i,avg(i) from Rc group by j; -explain select b,avg(b) from Sc group by a; -explain select a,avg(a) from Sc group by b; - -explain select i,min(j) from Rc group by i; -explain select j,min(i) from Rc group by j; -explain select a,min(b) from Sc group by a; -explain select b,min(a) from Sc group by b; - -explain select i,max(j) from Rc group by i; -explain select j,max(i) from Rc group by j; -explain select a,max(b) from Sc group by a; -explain select b,max(a) from Sc group by b; +-- next needs work +--select * from Rc; +--select * from Sc; select i,count(*) from Rc group by i; select j,count(*) from Rc group by j; @@ -38,8 +19,8 @@ select b,count(*) from Sc group by b; select i,sum(j) from Rc group by i; select j,sum(i) from Rc group by j; -select b,sum(b) from Sc group by a; -select a,sum(a) from Sc group by b; +select a,sum(b) from Sc group by a; +select b,sum(a) from Sc group by b; select i,avg(j) from Rc group by i; select j,avg(i) from Rc group by j; diff --git a/sql/test/centipede/Tests/selectcount.sql b/sql/test/centipede/Tests/selectcount.sql deleted file mode 100644 --- a/sql/test/centipede/Tests/selectcount.sql +++ /dev/null @@ -1,4 +0,0 @@ -set optimizer='centipede_pipe'; - -explain select count(*) from tables; -select count(*) from tables; _______________________________________________ checkin-list mailing list checkin-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/checkin-list
