Changeset: 9a6ca0855e39 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=9a6ca0855e39 Modified Files: sql/test/Tests/median_stdev.sql Branch: default Log Message:
Extending the median tests The test set should include a proper tests for median calculations. diffs (19 lines): diff --git a/sql/test/Tests/median_stdev.sql b/sql/test/Tests/median_stdev.sql --- a/sql/test/Tests/median_stdev.sql +++ b/sql/test/Tests/median_stdev.sql @@ -15,6 +15,15 @@ INSERT INTO sampleData VALUES ( 3, 66 ) INSERT INTO sampleData VALUES ( 4, 18 ); INSERT INTO sampleData VALUES ( 5, 0 ); INSERT INTO sampleData VALUES ( 5, 0 ); +INSERT INTO sampleData VALUES ( 5, 0 ); + +SELECT count(*) from sampleData; + +-- Median tests +SELECT median(numValue) FROM sampleData; -- should return 6.5 (or 6, or 7) +SELECT median(groupID) FROM sampleData; -- should return 2 +SELECT groupID, median(numValue) FROM sampleData ORDER BY groupID; -- should return (4, 5, 34.5, 18, 0) + SELECT R.groupID, AVG(1.0*R.numValue) AS medianValue FROM _______________________________________________ Checkin-list mailing list Checkin-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/checkin-list
