Changeset: 807495a926b5 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=807495a926b5
Added Files:
sql/backends/monet5/Tests/sample05.sql
Branch: stratified_sampling
Log Message:
Add missing test.
diffs (21 lines):
diff --git a/sql/backends/monet5/Tests/sample05.sql
b/sql/backends/monet5/Tests/sample05.sql
new file mode 100644
--- /dev/null
+++ b/sql/backends/monet5/Tests/sample05.sql
@@ -0,0 +1,16 @@
+
+START TRANSACTION;
+
+# random stuff in weights
+
+CREATE FUNCTION complex_function(i DOUBLE) RETURNS DOUBLE LANGUAGE PYTHON {
+ return (numpy.sin(numpy.sqrt(i+1)-2)+3)-4+5;
+};
+
+CREATE TABLE vals(w DOUBLE, value INTEGER);
+INSERT INTO vals VALUES (1, 100), (0, 50);
+
+SELECT * FROM vals SAMPLE 1 USING WEIGHTS CASE WHEN value > 55 THEN
complex_function(w+3)+3 ELSE 0 END;
+SELECT * FROM vals SAMPLE 1 USING WEIGHTS cast(cast(w AS INTEGER) AS DOUBLE);
+
+ROLLBACK;
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
