Changeset: 4c81f2dca357 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=4c81f2dca357
Added Files:
sql/backends/monet5/Tests/sample00.sql
sql/backends/monet5/Tests/sample01.sql
sql/backends/monet5/Tests/sample02.sql
sql/backends/monet5/Tests/sample03.sql
Branch: stratified_sampling
Log Message:
Add some testcases.
diffs (88 lines):
diff --git a/sql/backends/monet5/Tests/sample00.sql
b/sql/backends/monet5/Tests/sample00.sql
new file mode 100644
--- /dev/null
+++ b/sql/backends/monet5/Tests/sample00.sql
@@ -0,0 +1,23 @@
+
+START TRANSACTION;
+
+CREATE TABLE vals(w DOUBLE, value INTEGER);
+
+INSERT INTO vals VALUES (1, 100), (0, 50);
+
+SELECT * FROM vals SAMPLE 1 USING WEIGHTS w;
+SELECT * FROM vals SAMPLE 0.5 USING WEIGHTS w;
+SELECT * FROM vals SAMPLE 0.5 USING WEIGHTS (1 - w);
+
+ROLLBACK;
+
+# different types of weights
+START TRANSACTION;
+
+CREATE TABLE vals(w DECIMAL(10,3), value INTEGER);
+
+INSERT INTO vals VALUES (10.77, 100), (0, 50);
+
+SELECT * FROM vals SAMPLE 1 USING WEIGHTS w;
+
+ROLLBACK;
diff --git a/sql/backends/monet5/Tests/sample01.sql
b/sql/backends/monet5/Tests/sample01.sql
new file mode 100644
--- /dev/null
+++ b/sql/backends/monet5/Tests/sample01.sql
@@ -0,0 +1,11 @@
+
+START TRANSACTION;
+
+CREATE TABLE vals(id DOUBLE, type INTEGER);
+
+INSERT INTO vals VALUES (1, 100), (0, 50);
+
+SELECT type, COUNT(*) FROM vals GROUP BY type SAMPLE 1 USING WEIGHTS cast(id
AS double);
+
+ROLLBACK;
+
diff --git a/sql/backends/monet5/Tests/sample02.sql
b/sql/backends/monet5/Tests/sample02.sql
new file mode 100644
--- /dev/null
+++ b/sql/backends/monet5/Tests/sample02.sql
@@ -0,0 +1,12 @@
+
+
+START TRANSACTION;
+
+CREATE TABLE vals(id DOUBLE, type INTEGER);
+
+INSERT INTO vals VALUES (1, 100), (0, 50);
+
+SELECT SUM(id) FROM vals SAMPLE 1 USING WEIGHTS cast(type AS double);
+
+ROLLBACK;
+
diff --git a/sql/backends/monet5/Tests/sample03.sql
b/sql/backends/monet5/Tests/sample03.sql
new file mode 100644
--- /dev/null
+++ b/sql/backends/monet5/Tests/sample03.sql
@@ -0,0 +1,22 @@
+# test various error conditions
+
+# negative weights
+START TRANSACTION;
+
+CREATE TABLE vals(w DOUBLE, value INTEGER);
+INSERT INTO vals VALUES (1, 100), (-1, 50);
+
+SELECT * FROM vals SAMPLE 1 USING WEIGHTS w;
+
+
+ROLLBACK;
+
+# string weights
+START TRANSACTION;
+
+CREATE TABLE vals(w STRING, value INTEGER);
+INSERT INTO vals VALUES ('#1 sample', 100), ('#2 sample', 50);
+
+SELECT * FROM vals SAMPLE 1 USING WEIGHTS w;
+
+ROLLBACK;
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
