Changeset: 2e1e79ae7ca4 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=2e1e79ae7ca4 Modified Files: sql/test/Tests/median_stdev.sql Branch: default Log Message:
Typo in query diffs (12 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 @@ -22,7 +22,7 @@ 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 groupID, median(numValue) FROM sampleData GROUP BY groupID; -- should return (6, 5, 34.5, 18, 0) SELECT R.groupID, AVG(1.0*R.numValue) AS medianValue _______________________________________________ Checkin-list mailing list Checkin-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/checkin-list
