Changeset: abb8486c7db7 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=abb8486c7db7
Added Files:
sql/backends/monet5/Tests/inlineUDF.sql
sql/backends/monet5/Tests/rapi00.sql
sql/backends/monet5/Tests/rapi00.stable.err
sql/backends/monet5/Tests/rapi00.stable.out
sql/backends/monet5/Tests/rapi01.sql
sql/backends/monet5/Tests/rapi01.stable.err
sql/backends/monet5/Tests/rapi01.stable.out
sql/backends/monet5/Tests/rapi02.sql
sql/backends/monet5/Tests/rapi02.stable.err
sql/backends/monet5/Tests/rapi02.stable.out
sql/backends/monet5/Tests/rapi03.sql
sql/backends/monet5/Tests/rapi03.stable.err
sql/backends/monet5/Tests/rapi03.stable.out
sql/backends/monet5/Tests/rapi04.sql
sql/backends/monet5/Tests/rapi04.stable.err
sql/backends/monet5/Tests/rapi04.stable.out
sql/backends/monet5/Tests/rapi05.sql
sql/backends/monet5/Tests/rapi05.stable.err
sql/backends/monet5/Tests/rapi05.stable.out
sql/backends/monet5/Tests/rapi06.sql
sql/backends/monet5/Tests/rapi06.stable.err
sql/backends/monet5/Tests/rapi06.stable.out
sql/backends/monet5/Tests/rapi07.sql
sql/backends/monet5/Tests/rapi07.stable.err
sql/backends/monet5/Tests/rapi07.stable.out
sql/backends/monet5/Tests/rapi08.sql
sql/backends/monet5/Tests/rapi09.sql
sql/backends/monet5/Tests/rapi10.sql
sql/backends/monet5/Tests/rapi10.stable.err
sql/backends/monet5/Tests/rapi10.stable.out
Branch: RIntegration-default
Log Message:
Recovered test cases
diffs (truncated from 4173 to 300 lines):
diff --git a/sql/backends/monet5/Tests/inlineUDF.sql
b/sql/backends/monet5/Tests/inlineUDF.sql
new file mode 100644
--- /dev/null
+++ b/sql/backends/monet5/Tests/inlineUDF.sql
@@ -0,0 +1,12 @@
+-- Simple MonetDB C UDF interface
+
+-- The arguments are named after the signature
+-- The return variable is called 'ret'
+
+create function one() returns integer language C { *ret = 1; return NULL; }
+create function addtwo(i integer, j integer) returns integer language C { *ret
= *i + *j; return NULL;}
+create function adderror(i integer, j integer) returns integer language C { if
( *i == int_nil || *j == int_nil) throw(SQL,"udf","Nil not allowed"); *ret = *i
+ *j; return NULL;}
+
+select one();
+select addtwo(one(),one());
+select adderror(one(),null);
diff --git a/sql/backends/monet5/Tests/rapi00.sql
b/sql/backends/monet5/Tests/rapi00.sql
new file mode 100644
--- /dev/null
+++ b/sql/backends/monet5/Tests/rapi00.sql
@@ -0,0 +1,10 @@
+START TRANSACTION;
+
+CREATE FUNCTION rapi00() returns table (d integer)
+language R {
+ return(seq(1,10));
+};
+SELECT d FROM rapi00() AS R WHERE d > 5;
+DROP FUNCTION rapi00;
+
+ROLLBACK;
\ No newline at end of file
diff --git a/sql/backends/monet5/Tests/rapi00.stable.err
b/sql/backends/monet5/Tests/rapi00.stable.err
new file mode 100644
--- /dev/null
+++ b/sql/backends/monet5/Tests/rapi00.stable.err
@@ -0,0 +1,35 @@
+stderr of test 'rapi00` in directory 'sql/backends/monet5` itself:
+
+
+# 17:37:08 >
+# 17:37:08 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set"
"mapi_open=true" "--set" "mapi_port=35474" "--set"
"mapi_usock=/var/tmp/mtest-20729/.s.monetdb.35474" "--set" "monet_prompt="
"--forcemito" "--set" "mal_listing=2"
"--dbpath=/export/scratch1/hannes/fakefs/var/MonetDB/mTests_sql_backends_monet5"
"--set" "mal_listing=0"
+# 17:37:08 >
+
+# builtin opt gdk_dbpath =
/export/scratch2/hannes/monetdb-rint-install/var/monetdb5/dbfarm/demo
+# builtin opt gdk_debug = 0
+# builtin opt gdk_vmtrim = yes
+# builtin opt monet_prompt = >
+# builtin opt monet_daemon = no
+# builtin opt mapi_port = 50000
+# builtin opt mapi_open = false
+# builtin opt mapi_autosense = false
+# builtin opt sql_optimizer = default_pipe
+# builtin opt sql_debug = 0
+# cmdline opt gdk_nr_threads = 0
+# cmdline opt mapi_open = true
+# cmdline opt mapi_port = 35474
+# cmdline opt mapi_usock = /var/tmp/mtest-20729/.s.monetdb.35474
+# cmdline opt monet_prompt =
+# cmdline opt mal_listing = 2
+# cmdline opt gdk_dbpath =
/export/scratch1/hannes/fakefs/var/MonetDB/mTests_sql_backends_monet5
+# cmdline opt mal_listing = 0
+
+# 17:37:08 >
+# 17:37:08 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e"
"--host=/var/tmp/mtest-20729" "--port=35474"
+# 17:37:08 >
+
+
+# 17:37:09 >
+# 17:37:09 > "Done."
+# 17:37:09 >
+
diff --git a/sql/backends/monet5/Tests/rapi00.stable.out
b/sql/backends/monet5/Tests/rapi00.stable.out
new file mode 100644
--- /dev/null
+++ b/sql/backends/monet5/Tests/rapi00.stable.out
@@ -0,0 +1,47 @@
+stdout of test 'rapi00` in directory 'sql/backends/monet5` itself:
+
+
+# 17:37:08 >
+# 17:37:08 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set"
"mapi_open=true" "--set" "mapi_port=35474" "--set"
"mapi_usock=/var/tmp/mtest-20729/.s.monetdb.35474" "--set" "monet_prompt="
"--forcemito" "--set" "mal_listing=2"
"--dbpath=/export/scratch1/hannes/fakefs/var/MonetDB/mTests_sql_backends_monet5"
"--set" "mal_listing=0"
+# 17:37:08 >
+
+# MonetDB 5 server v11.18.0
+# This is an unreleased version
+# Serving database 'mTests_sql_backends_monet5', using 8 threads
+# Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs dynamically
linked
+# Found 15.592 GiB available main-memory.
+# Copyright (c) 1993-July 2008 CWI.
+# Copyright (c) August 2008-2014 MonetDB B.V., all rights reserved
+# Visit http://www.monetdb.org/ for further information
+# Listening for connection requests on mapi:monetdb://bristol.ins.cwi.nl:35474/
+# Listening for UNIX domain connection requests on
mapi:monetdb:///var/tmp/mtest-20729/.s.monetdb.35474
+# MonetDB/GIS module loaded
+# MonetDB/JAQL module loaded
+# MonetDB/SQL module loaded
+
+Ready.
+
+# 17:37:08 >
+# 17:37:08 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e"
"--host=/var/tmp/mtest-20729" "--port=35474"
+# 17:37:08 >
+
+#create function rapi00() returns table (d integer)
+#language R {
+# return(seq(1,10));
+#};
+#select d from rapi00() as R where d > 5;
+% .r # table_name
+% d # name
+% int # type
+% 2 # length
+[ 6 ]
+[ 7 ]
+[ 8 ]
+[ 9 ]
+[ 10 ]
+#drop function rapi00;
+
+# 17:37:09 >
+# 17:37:09 > "Done."
+# 17:37:09 >
+
diff --git a/sql/backends/monet5/Tests/rapi01.sql
b/sql/backends/monet5/Tests/rapi01.sql
new file mode 100644
--- /dev/null
+++ b/sql/backends/monet5/Tests/rapi01.sql
@@ -0,0 +1,10 @@
+START TRANSACTION;
+
+CREATE FUNCTION rapi01(i integer) returns table (i integer, d double)
+language R {
+ return(data.frame(i=seq(1,i),d=42.0));
+};
+SELECT i,d FROM rapi01(42) AS R WHERE i>40;
+DROP FUNCTION rapi01;
+
+ROLLBACK;
\ No newline at end of file
diff --git a/sql/backends/monet5/Tests/rapi01.stable.err
b/sql/backends/monet5/Tests/rapi01.stable.err
new file mode 100644
--- /dev/null
+++ b/sql/backends/monet5/Tests/rapi01.stable.err
@@ -0,0 +1,35 @@
+stderr of test 'rapi01` in directory 'sql/backends/monet5` itself:
+
+
+# 17:37:09 >
+# 17:37:09 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set"
"mapi_open=true" "--set" "mapi_port=35474" "--set"
"mapi_usock=/var/tmp/mtest-20729/.s.monetdb.35474" "--set" "monet_prompt="
"--forcemito" "--set" "mal_listing=2"
"--dbpath=/export/scratch1/hannes/fakefs/var/MonetDB/mTests_sql_backends_monet5"
"--set" "mal_listing=0"
+# 17:37:09 >
+
+# builtin opt gdk_dbpath =
/export/scratch2/hannes/monetdb-rint-install/var/monetdb5/dbfarm/demo
+# builtin opt gdk_debug = 0
+# builtin opt gdk_vmtrim = yes
+# builtin opt monet_prompt = >
+# builtin opt monet_daemon = no
+# builtin opt mapi_port = 50000
+# builtin opt mapi_open = false
+# builtin opt mapi_autosense = false
+# builtin opt sql_optimizer = default_pipe
+# builtin opt sql_debug = 0
+# cmdline opt gdk_nr_threads = 0
+# cmdline opt mapi_open = true
+# cmdline opt mapi_port = 35474
+# cmdline opt mapi_usock = /var/tmp/mtest-20729/.s.monetdb.35474
+# cmdline opt monet_prompt =
+# cmdline opt mal_listing = 2
+# cmdline opt gdk_dbpath =
/export/scratch1/hannes/fakefs/var/MonetDB/mTests_sql_backends_monet5
+# cmdline opt mal_listing = 0
+
+# 17:37:09 >
+# 17:37:09 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e"
"--host=/var/tmp/mtest-20729" "--port=35474"
+# 17:37:09 >
+
+
+# 17:37:09 >
+# 17:37:09 > "Done."
+# 17:37:09 >
+
diff --git a/sql/backends/monet5/Tests/rapi01.stable.out
b/sql/backends/monet5/Tests/rapi01.stable.out
new file mode 100644
--- /dev/null
+++ b/sql/backends/monet5/Tests/rapi01.stable.out
@@ -0,0 +1,44 @@
+stdout of test 'rapi01` in directory 'sql/backends/monet5` itself:
+
+
+# 17:37:09 >
+# 17:37:09 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set"
"mapi_open=true" "--set" "mapi_port=35474" "--set"
"mapi_usock=/var/tmp/mtest-20729/.s.monetdb.35474" "--set" "monet_prompt="
"--forcemito" "--set" "mal_listing=2"
"--dbpath=/export/scratch1/hannes/fakefs/var/MonetDB/mTests_sql_backends_monet5"
"--set" "mal_listing=0"
+# 17:37:09 >
+
+# MonetDB 5 server v11.18.0
+# This is an unreleased version
+# Serving database 'mTests_sql_backends_monet5', using 8 threads
+# Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs dynamically
linked
+# Found 15.592 GiB available main-memory.
+# Copyright (c) 1993-July 2008 CWI.
+# Copyright (c) August 2008-2014 MonetDB B.V., all rights reserved
+# Visit http://www.monetdb.org/ for further information
+# Listening for connection requests on mapi:monetdb://bristol.ins.cwi.nl:35474/
+# Listening for UNIX domain connection requests on
mapi:monetdb:///var/tmp/mtest-20729/.s.monetdb.35474
+# MonetDB/GIS module loaded
+# MonetDB/JAQL module loaded
+# MonetDB/SQL module loaded
+
+Ready.
+
+# 17:37:09 >
+# 17:37:09 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e"
"--host=/var/tmp/mtest-20729" "--port=35474"
+# 17:37:09 >
+
+#create function rapi01(i integer) returns table (i integer, d double)
+#language R {
+# return(data.frame(seq(1,arg1),42));
+#};
+#select i,d from rapi01(42) as R where i>40;
+% .r, .r # table_name
+% i, d # name
+% int, double # type
+% 2, 24 # length
+[ 41, 42 ]
+[ 42, 42 ]
+#drop function rapi01;
+
+# 17:37:09 >
+# 17:37:09 > "Done."
+# 17:37:09 >
+
diff --git a/sql/backends/monet5/Tests/rapi02.sql
b/sql/backends/monet5/Tests/rapi02.sql
new file mode 100644
--- /dev/null
+++ b/sql/backends/monet5/Tests/rapi02.sql
@@ -0,0 +1,14 @@
+START TRANSACTION;
+
+CREATE TABLE rval(i integer,j integer);
+INSERT INTO rval VALUES (1,4), (2,3), (3,2), (4,1);
+
+CREATE FUNCTION rapi02(i integer,j integer,z integer) returns integer
+language R {
+ return(i*sum(j)*z);
+};
+SELECT rapi02(i,j,2) as r02 FROM rval;
+DROP FUNCTION rapi02;
+DROP TABLE rval;
+
+ROLLBACK;
\ No newline at end of file
diff --git a/sql/backends/monet5/Tests/rapi02.stable.err
b/sql/backends/monet5/Tests/rapi02.stable.err
new file mode 100644
--- /dev/null
+++ b/sql/backends/monet5/Tests/rapi02.stable.err
@@ -0,0 +1,35 @@
+stderr of test 'rapi02` in directory 'sql/backends/monet5` itself:
+
+
+# 17:37:09 >
+# 17:37:09 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set"
"mapi_open=true" "--set" "mapi_port=35474" "--set"
"mapi_usock=/var/tmp/mtest-20729/.s.monetdb.35474" "--set" "monet_prompt="
"--forcemito" "--set" "mal_listing=2"
"--dbpath=/export/scratch1/hannes/fakefs/var/MonetDB/mTests_sql_backends_monet5"
"--set" "mal_listing=0"
+# 17:37:09 >
+
+# builtin opt gdk_dbpath =
/export/scratch2/hannes/monetdb-rint-install/var/monetdb5/dbfarm/demo
+# builtin opt gdk_debug = 0
+# builtin opt gdk_vmtrim = yes
+# builtin opt monet_prompt = >
+# builtin opt monet_daemon = no
+# builtin opt mapi_port = 50000
+# builtin opt mapi_open = false
+# builtin opt mapi_autosense = false
+# builtin opt sql_optimizer = default_pipe
+# builtin opt sql_debug = 0
+# cmdline opt gdk_nr_threads = 0
+# cmdline opt mapi_open = true
+# cmdline opt mapi_port = 35474
+# cmdline opt mapi_usock = /var/tmp/mtest-20729/.s.monetdb.35474
+# cmdline opt monet_prompt =
+# cmdline opt mal_listing = 2
+# cmdline opt gdk_dbpath =
/export/scratch1/hannes/fakefs/var/MonetDB/mTests_sql_backends_monet5
+# cmdline opt mal_listing = 0
+
+# 17:37:10 >
+# 17:37:10 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e"
"--host=/var/tmp/mtest-20729" "--port=35474"
+# 17:37:10 >
+
+
+# 17:37:10 >
+# 17:37:10 > "Done."
+# 17:37:10 >
+
diff --git a/sql/backends/monet5/Tests/rapi02.stable.out
b/sql/backends/monet5/Tests/rapi02.stable.out
new file mode 100644
--- /dev/null
+++ b/sql/backends/monet5/Tests/rapi02.stable.out
@@ -0,0 +1,50 @@
+stdout of test 'rapi02` in directory 'sql/backends/monet5` itself:
+
+
+# 17:37:09 >
+# 17:37:09 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set"
"mapi_open=true" "--set" "mapi_port=35474" "--set"
"mapi_usock=/var/tmp/mtest-20729/.s.monetdb.35474" "--set" "monet_prompt="
"--forcemito" "--set" "mal_listing=2"
"--dbpath=/export/scratch1/hannes/fakefs/var/MonetDB/mTests_sql_backends_monet5"
"--set" "mal_listing=0"
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
