Changeset: 7c33c7643943 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=7c33c7643943 Added Files: sql/test/sample/Tests/All sql/test/sample/Tests/sample-queries.sql Branch: sample-with-seed Log Message:
Provide test queries for sample functionality. diffs (27 lines): diff --git a/sql/test/sample/Tests/All b/sql/test/sample/Tests/All new file mode 100644 --- /dev/null +++ b/sql/test/sample/Tests/All @@ -0,0 +1,1 @@ +sample-queries diff --git a/sql/test/sample/Tests/sample-queries.sql b/sql/test/sample/Tests/sample-queries.sql new file mode 100644 --- /dev/null +++ b/sql/test/sample/Tests/sample-queries.sql @@ -0,0 +1,16 @@ +select * from GENERATE_SERIES(1,41) sample 0; --empty set +select * from GENERATE_SERIES(1,41) sample 1 seed 1234; --1 sample +select * from GENERATE_SERIES(1,41) sample 10 seed 1234; --10 samples +select * from GENERATE_SERIES(1,41) sample 20 seed 1234; --20 samples +select * from GENERATE_SERIES(1,41) sample 30 seed 1234; --30 samples +select * from GENERATE_SERIES(1,41) sample 30 seed 4321; --another 30 samples +select * from GENERATE_SERIES(1,41) sample 40; --full table + +select * from GENERATE_SERIES(1,41) sample 0.0; --empty set +select * from GENERATE_SERIES(1,41) sample 0.025 seed 1234; --1 sample +select * from GENERATE_SERIES(1,41) sample 0.25 seed 1234; --10 samples +select * from GENERATE_SERIES(1,41) sample 0.5 seed 1234; --20 samples +select * from GENERATE_SERIES(1,41) sample 0.75 seed 1234; --30 samples +select * from GENERATE_SERIES(1,41) sample 0.75 seed 4321; --another 30 samples +select * from GENERATE_SERIES(1,41) sample 1.0; --full table +select * from GENERATE_SERIES(1,41) sample 1.25; --should give error _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
