Changeset: 76b9dd3cef55 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=76b9dd3cef55
Branch: mtest
Log Message:

merged


diffs (152 lines):

diff --git a/sql/test/sample/Tests/sample.1.test 
b/sql/test/sample/Tests/sample.1.test
new file mode 100644
--- /dev/null
+++ b/sql/test/sample/Tests/sample.1.test
@@ -0,0 +1,5 @@
+query I rowsort
+select * from GENERATE_SERIES(1,41) sample 0
+----
+
+
diff --git a/sql/test/sample/Tests/sample.10.test 
b/sql/test/sample/Tests/sample.10.test
new file mode 100644
--- /dev/null
+++ b/sql/test/sample/Tests/sample.10.test
@@ -0,0 +1,6 @@
+query I rowsort
+select * from GENERATE_SERIES(1,41) sample 0.25 seed 1234
+----
+10 values hashing to e51196ceee812431de139faeb662040e
+
+
diff --git a/sql/test/sample/Tests/sample.11.test 
b/sql/test/sample/Tests/sample.11.test
new file mode 100644
--- /dev/null
+++ b/sql/test/sample/Tests/sample.11.test
@@ -0,0 +1,6 @@
+query I rowsort
+select * from GENERATE_SERIES(1,41) sample 0.5 seed 1234
+----
+20 values hashing to e8091cc14b83ad494ebc0bc4d8e7a560
+
+
diff --git a/sql/test/sample/Tests/sample.12.test 
b/sql/test/sample/Tests/sample.12.test
new file mode 100644
--- /dev/null
+++ b/sql/test/sample/Tests/sample.12.test
@@ -0,0 +1,6 @@
+query I rowsort
+select * from GENERATE_SERIES(1,41) sample 0.75 seed 1234
+----
+30 values hashing to a4621e32eaf6b1f2816649959e516543
+
+
diff --git a/sql/test/sample/Tests/sample.13.test 
b/sql/test/sample/Tests/sample.13.test
new file mode 100644
--- /dev/null
+++ b/sql/test/sample/Tests/sample.13.test
@@ -0,0 +1,6 @@
+query I rowsort
+select * from GENERATE_SERIES(1,41) sample 0.75 seed 4321
+----
+30 values hashing to c6572d30961762d9fb56a3e1824a842b
+
+
diff --git a/sql/test/sample/Tests/sample.14.test 
b/sql/test/sample/Tests/sample.14.test
new file mode 100644
--- /dev/null
+++ b/sql/test/sample/Tests/sample.14.test
@@ -0,0 +1,6 @@
+query I rowsort
+select * from GENERATE_SERIES(1,41) sample 1.0
+----
+40 values hashing to 15478724c53006b905a0c5a7a063bcdd
+
+
diff --git a/sql/test/sample/Tests/sample.2.test 
b/sql/test/sample/Tests/sample.2.test
new file mode 100644
--- /dev/null
+++ b/sql/test/sample/Tests/sample.2.test
@@ -0,0 +1,6 @@
+query I rowsort
+select * from GENERATE_SERIES(1,41) sample 1 seed 1234
+----
+20
+
+
diff --git a/sql/test/sample/Tests/sample.3.test 
b/sql/test/sample/Tests/sample.3.test
new file mode 100644
--- /dev/null
+++ b/sql/test/sample/Tests/sample.3.test
@@ -0,0 +1,6 @@
+query I rowsort
+select * from GENERATE_SERIES(1,41) sample 10 seed 1234
+----
+10 values hashing to e51196ceee812431de139faeb662040e
+
+
diff --git a/sql/test/sample/Tests/sample.4.test 
b/sql/test/sample/Tests/sample.4.test
new file mode 100644
--- /dev/null
+++ b/sql/test/sample/Tests/sample.4.test
@@ -0,0 +1,6 @@
+query I rowsort
+select * from GENERATE_SERIES(1,41) sample 20 seed 1234
+----
+20 values hashing to e8091cc14b83ad494ebc0bc4d8e7a560
+
+
diff --git a/sql/test/sample/Tests/sample.5.test 
b/sql/test/sample/Tests/sample.5.test
new file mode 100644
--- /dev/null
+++ b/sql/test/sample/Tests/sample.5.test
@@ -0,0 +1,6 @@
+query I rowsort
+select * from GENERATE_SERIES(1,41) sample 30 seed 1234
+----
+30 values hashing to a4621e32eaf6b1f2816649959e516543
+
+
diff --git a/sql/test/sample/Tests/sample.6.test 
b/sql/test/sample/Tests/sample.6.test
new file mode 100644
--- /dev/null
+++ b/sql/test/sample/Tests/sample.6.test
@@ -0,0 +1,6 @@
+query I rowsort
+select * from GENERATE_SERIES(1,41) sample 30 seed 4321
+----
+30 values hashing to c6572d30961762d9fb56a3e1824a842b
+
+
diff --git a/sql/test/sample/Tests/sample.7.test 
b/sql/test/sample/Tests/sample.7.test
new file mode 100644
--- /dev/null
+++ b/sql/test/sample/Tests/sample.7.test
@@ -0,0 +1,6 @@
+query I rowsort
+select * from GENERATE_SERIES(1,41) sample 40
+----
+40 values hashing to 15478724c53006b905a0c5a7a063bcdd
+
+
diff --git a/sql/test/sample/Tests/sample.8.test 
b/sql/test/sample/Tests/sample.8.test
new file mode 100644
--- /dev/null
+++ b/sql/test/sample/Tests/sample.8.test
@@ -0,0 +1,5 @@
+query I rowsort
+select * from GENERATE_SERIES(1,41) sample 0.0
+----
+
+
diff --git a/sql/test/sample/Tests/sample.9.test 
b/sql/test/sample/Tests/sample.9.test
new file mode 100644
--- /dev/null
+++ b/sql/test/sample/Tests/sample.9.test
@@ -0,0 +1,6 @@
+query I rowsort
+select * from GENERATE_SERIES(1,41) sample 0.025 seed 1234
+----
+20
+
+
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list

Reply via email to