Changeset: ff099344f643 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=ff099344f643
Added Files:
        sql/backends/monet5/UDF/pyapi3/Tests/All
        sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_00.SQL.sh
        sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_00.stable.err
        sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_00.stable.out
        sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_01.SQL.sh
        sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_01.stable.err
        sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_01.stable.out
        sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_02.SQL.sh
        sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_02.stable.err
        sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_02.stable.out
        sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_03.SQL.sh
        sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_03.stable.err
        sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_03.stable.out
        sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_04.SQL.sh
        sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_04.stable.err
        sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_04.stable.out
        sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_05.SQL.sh
        sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_05.stable.err
        sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_05.stable.out
        sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_06.SQL.sh
        sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_06.stable.err
        sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_06.stable.out
        sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_07.SQL.sh
        sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_07.stable.err
        sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_07.stable.out
        sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_09.SQL.sh
        sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_09.stable.err
        sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_09.stable.out
        sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_10.SQL.sh
        sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_10.stable.err
        sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_10.stable.out
        sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_11.SQL.sh
        sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_11.stable.err
        sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_11.stable.out
        sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_12.SQL.sh
        sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_12.stable.err
        sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_12.stable.out
        sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_13.SQL.sh
        sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_13.stable.err
        sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_13.stable.out
        sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_15.SQL.sh
        sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_16.SQL.sh
        sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_16.stable.err
        sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_16.stable.out
        sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_17.SQL.sh
        sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_17.stable.err
        sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_17.stable.out
        sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_18.SQL.sh
        sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_18.stable.err
        sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_18.stable.out
        sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_19.SQL.sh
        sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_19.stable.err
        sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_19.stable.out
        sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_20.SQL.sh
        sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_20.stable.err
        sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_20.stable.out
        sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_21.SQL.sh
        sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_21.stable.err
        sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_21.stable.out
        sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_23.SQL.sh
        sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_23.stable.err
        sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_23.stable.out
        sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_24.SQL.sh
        sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_24.stable.err
        sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_24.stable.out
        sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_25.SQL.sh
        sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_25.stable.err
        sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_25.stable.out
        sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_26.SQL.sh
        sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_26.stable.err
        sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_26.stable.out
        sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_27.SQL.sh
        sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_27.stable.err
        sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_27.stable.out
        sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_28.SQL.sh
        sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_28.stable.err
        sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_28.stable.out
        sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_29.SQL.sh
        sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_29.stable.err
        sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_29.stable.out
        sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_30.SQL.sh
        sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_30.stable.err
        sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_30.stable.out
        sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_31.SQL.sh
        sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_31.stable.err
        sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_31.stable.out
        sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_32.SQL.sh
        sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_32.stable.err
        sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_32.stable.out
        sql/backends/monet5/UDF/pyapi3/Tests/pyloader3_01.SQL.sh
        sql/backends/monet5/UDF/pyapi3/Tests/pyloader3_01.stable.err
        sql/backends/monet5/UDF/pyapi3/Tests/pyloader3_01.stable.out
        sql/backends/monet5/UDF/pyapi3/Tests/pyloader3_02.SQL.sh
        sql/backends/monet5/UDF/pyapi3/Tests/pyloader3_02.stable.err
        sql/backends/monet5/UDF/pyapi3/Tests/pyloader3_02.stable.out
        sql/backends/monet5/UDF/pyapi3/Tests/pyloader3_03.SQL.sh
        sql/backends/monet5/UDF/pyapi3/Tests/pyloader3_03.stable.err
        sql/backends/monet5/UDF/pyapi3/Tests/pyloader3_03.stable.out
        sql/backends/monet5/UDF/pyapi3/Tests/pyloader3_04.SQL.sh
        sql/backends/monet5/UDF/pyapi3/Tests/pyloader3_04.stable.err
        sql/backends/monet5/UDF/pyapi3/Tests/pyloader3_04.stable.out
        sql/backends/monet5/UDF/pyapi3/Tests/pyloader3_05.SQL.sh
        sql/backends/monet5/UDF/pyapi3/Tests/pyloader3_05.stable.err
        sql/backends/monet5/UDF/pyapi3/Tests/pyloader3_05.stable.out
        sql/backends/monet5/UDF/pyapi3/Tests/pyloader3_06.SQL.sh
        sql/backends/monet5/UDF/pyapi3/Tests/pyloader3_06.stable.err
        sql/backends/monet5/UDF/pyapi3/Tests/pyloader3_06.stable.out
        sql/backends/monet5/UDF/pyapi3/Tests/pyloader3_07.SQL.sh
        sql/backends/monet5/UDF/pyapi3/Tests/pyloader3_07.stable.err
        sql/backends/monet5/UDF/pyapi3/Tests/pyloader3_07.stable.out
Modified Files:
        sql/backends/monet5/sql_gencode.c
Branch: python3udf
Log Message:

Add tests.


diffs (truncated from 6309 to 300 lines):

diff --git a/sql/backends/monet5/UDF/pyapi3/Tests/All 
b/sql/backends/monet5/UDF/pyapi3/Tests/All
new file mode 100644
--- /dev/null
+++ b/sql/backends/monet5/UDF/pyapi3/Tests/All
@@ -0,0 +1,36 @@
+
+HAVE_LIBPY3?pyapi3_00
+HAVE_LIBPY3?pyapi3_01
+HAVE_LIBPY3?pyapi3_02
+HAVE_LIBPY3?pyapi3_03
+HAVE_LIBPY3?pyapi3_04
+HAVE_LIBPY3?pyapi3_06
+HAVE_LIBPY3?pyapi3_07
+HAVE_LIBPY3?pyapi3_09
+HAVE_LIBPY3?pyapi3_10
+HAVE_LIBPY3?pyapi3_11
+HAVE_LIBPY3?pyapi3_12
+HAVE_LIBPY3?pyapi3_13
+HAVE_LIBPY3?pyapi3_16
+HAVE_LIBPY3?pyapi3_17
+HAVE_LIBPY3?pyapi3_18
+HAVE_LIBPY3?pyapi3_19
+HAVE_LIBPY3?pyapi3_20
+HAVE_LIBPY3?pyapi3_21
+HAVE_LIBPY3?pyapi3_23
+HAVE_LIBPY3?pyapi3_24
+HAVE_LIBPY3&THREADS=8?pyapi3_25
+HAVE_LIBPY3?pyapi3_26
+HAVE_LIBPY3?pyapi3_27
+HAVE_LIBPY3?pyapi3_28
+HAVE_LIBPY3?pyapi3_29
+HAVE_LIBPY3?pyapi3_30
+HAVE_LIBPY3?pyapi3_32
+
+HAVE_LIBPY3?pyloader3_01
+HAVE_LIBPY3?pyloader3_02
+HAVE_LIBPY3?pyloader3_03
+HAVE_LIBPY3?pyloader3_04
+HAVE_LIBPY3?pyloader3_05
+HAVE_LIBPY3?pyloader3_06
+HAVE_LIBPY3?pyloader3_07
diff --git a/sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_00.SQL.sh 
b/sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_00.SQL.sh
new file mode 100755
--- /dev/null
+++ b/sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_00.SQL.sh
@@ -0,0 +1,2 @@
+#!/bin/sh
+Mlog -x "$SQL_CLIENT < $TSTSRCBASE/$TSTDIR/../../Tests/pyapi00.sql"
diff --git a/sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_00.stable.err 
b/sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_00.stable.err
new file mode 100644
--- /dev/null
+++ b/sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_00.stable.err
@@ -0,0 +1,41 @@
+stderr of test 'pyapi3_00` in directory 'sql/backends/monet5/UDF/pyapi3` 
itself:
+
+
+# 18:14:00 >  
+# 18:14:00 >  "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" 
"mapi_open=true" "--set" "mapi_port=39898" "--set" 
"mapi_usock=/var/tmp/mtest-42996/.s.monetdb.39898" "--set" "monet_prompt=" 
"--forcemito" 
"--dbpath=/Users/myth/opt/var/MonetDB/mTests_sql_backends_monet5_UDF_pyapi3" 
"--set" "embedded_py=true" "--set" "embedded_py=3"
+# 18:14:00 >  
+
+# builtin opt  gdk_dbpath = /Users/myth/opt/var/monetdb5/dbfarm/demo
+# builtin opt  gdk_debug = 0
+# builtin opt  gdk_vmtrim = no
+# 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 = 39898
+# cmdline opt  mapi_usock = /var/tmp/mtest-42996/.s.monetdb.39898
+# cmdline opt  monet_prompt = 
+# cmdline opt  gdk_dbpath = 
/Users/myth/opt/var/MonetDB/mTests_sql_backends_monet5_UDF_pyapi3
+# cmdline opt  embedded_py = true
+# cmdline opt  embedded_py = 3
+# cmdline opt  gdk_debug = 536870922
+
+# 18:14:00 >  
+# 18:14:00 >  "./pyapi3_00.SQL.sh" "pyapi3_00"
+# 18:14:00 >  
+
+
+# 18:14:00 >  
+# 18:14:00 >  Mtimeout -timeout 60 mclient -lsql -ftest -Eutf-8 -i -e 
--host=/var/tmp/mtest-42996 --port=39898 < 
/Users/myth/Programs/MonetDB/sql/backends/monet5/UDF/pyapi3/../../Tests/pyapi00.sql
+# 18:14:00 >  
+
+
+# 18:14:01 >  
+# 18:14:01 >  "Done."
+# 18:14:01 >  
+
diff --git a/sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_00.stable.out 
b/sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_00.stable.out
new file mode 100644
--- /dev/null
+++ b/sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_00.stable.out
@@ -0,0 +1,89 @@
+stdout of test 'pyapi3_00` in directory 'sql/backends/monet5/UDF/pyapi3` 
itself:
+
+
+# 18:14:00 >  
+# 18:14:00 >  "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" 
"mapi_open=true" "--set" "mapi_port=39898" "--set" 
"mapi_usock=/var/tmp/mtest-42996/.s.monetdb.39898" "--set" "monet_prompt=" 
"--forcemito" 
"--dbpath=/Users/myth/opt/var/MonetDB/mTests_sql_backends_monet5_UDF_pyapi3" 
"--set" "embedded_py=true" "--set" "embedded_py=3"
+# 18:14:00 >  
+
+# MonetDB 5 server v11.26.0
+# This is an unreleased version
+# Serving database 'mTests_sql_backends_monet5_UDF_pyapi3', using 4 threads
+# Compiled for x86_64-apple-darwin15.6.0/64bit with 128bit integers
+# Found 8.000 GiB available main-memory.
+# Copyright (c) 1993-July 2008 CWI.
+# Copyright (c) August 2008-2016 MonetDB B.V., all rights reserved
+# Visit http://www.monetdb.org/ for further information
+# Listening for connection requests on 
mapi:monetdb://dhcp-158.eduroam.cwi.nl:39898/
+# Listening for UNIX domain connection requests on 
mapi:monetdb:///var/tmp/mtest-42996/.s.monetdb.39898
+# MonetDB/SQL module loaded
+# MonetDB/Python2 module loaded
+
+Ready.
+# SQL catalog created, loading sql scripts once
+# loading sql script: 09_like.sql
+# loading sql script: 10_math.sql
+# loading sql script: 11_times.sql
+# loading sql script: 12_url.sql
+# loading sql script: 13_date.sql
+# loading sql script: 14_inet.sql
+# loading sql script: 15_querylog.sql
+# loading sql script: 16_tracelog.sql
+# loading sql script: 17_temporal.sql
+# loading sql script: 18_index.sql
+# loading sql script: 20_vacuum.sql
+# loading sql script: 21_dependency_functions.sql
+# loading sql script: 22_clients.sql
+# loading sql script: 23_skyserver.sql
+# loading sql script: 25_debug.sql
+# loading sql script: 26_sysmon.sql
+# loading sql script: 27_rejects.sql
+# loading sql script: 39_analytics.sql
+# loading sql script: 39_analytics_hge.sql
+# loading sql script: 40_json.sql
+# loading sql script: 40_json_hge.sql
+# loading sql script: 41_md5sum.sql
+# loading sql script: 45_uuid.sql
+# loading sql script: 46_profiler.sql
+# loading sql script: 51_sys_schema_extension.sql
+# loading sql script: 72_fits.sql
+# loading sql script: 74_netcdf.sql
+# loading sql script: 75_storagemodel.sql
+# loading sql script: 80_statistics.sql
+# loading sql script: 80_udf.sql
+# loading sql script: 80_udf_hge.sql
+# loading sql script: 90_generator.sql
+# loading sql script: 90_generator_hge.sql
+# loading sql script: 99_system.sql
+
+# 18:14:00 >  
+# 18:14:00 >  "./pyapi3_00.SQL.sh" "pyapi3_00"
+# 18:14:00 >  
+
+
+# 18:14:00 >  
+# 18:14:00 >  Mtimeout -timeout 60 mclient -lsql -ftest -Eutf-8 -i -e 
--host=/var/tmp/mtest-42996 --port=39898 < 
/Users/myth/Programs/MonetDB/sql/backends/monet5/UDF/pyapi3/../../Tests/pyapi00.sql
+# 18:14:00 >  
+
+#START TRANSACTION;
+#CREATE FUNCTION pyapi00() returns table (d integer)
+#language P
+#{
+#      return(list(range(1,11)))
+#};
+#SELECT * FROM pyapi00() AS R WHERE d > 5;
+% .r # table_name
+% d # name
+% int # type
+% 2 # length
+[ 6    ]
+[ 7    ]
+[ 8    ]
+[ 9    ]
+[ 10   ]
+#DROP FUNCTION pyapi00;
+#ROLLBACK;
+
+# 18:14:01 >  
+# 18:14:01 >  "Done."
+# 18:14:01 >  
+
diff --git a/sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_01.SQL.sh 
b/sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_01.SQL.sh
new file mode 100755
--- /dev/null
+++ b/sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_01.SQL.sh
@@ -0,0 +1,2 @@
+#!/bin/sh
+Mlog -x "$SQL_CLIENT < $TSTSRCBASE/$TSTDIR/../../Tests/pyapi01.sql"
diff --git a/sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_01.stable.err 
b/sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_01.stable.err
new file mode 100644
--- /dev/null
+++ b/sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_01.stable.err
@@ -0,0 +1,38 @@
+stderr of test 'pyapi3_01` in directory 'sql/backends/monet5/UDF/pyapi3` 
itself:
+
+
+# 22:40:25 >  
+# 22:40:25 >  "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" 
"mapi_open=true" "--set" "mapi_port=32251" "--set" 
"mapi_usock=/var/tmp/mtest-8581/.s.monetdb.32251" "--set" "monet_prompt=" 
"--forcemito" "--set" "mal_listing=2" 
"--dbpath=/home/mytherin/opt/var/mTests_sql_backends_monet5" "--set" 
"mal_listing=0" "--set" "embedded_r=true" "--set" "embedded_py=true"
+# 22:40:25 >  
+
+# builtin opt  gdk_dbpath = /home/mytherin/opt/var/monetdb5/dbfarm/demo
+# builtin opt  gdk_debug = 0
+# builtin opt  gdk_vmtrim = no
+# 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 = 32251
+# cmdline opt  mapi_usock = /var/tmp/mtest-8581/.s.monetdb.32251
+# cmdline opt  monet_prompt = 
+# cmdline opt  mal_listing = 2
+# cmdline opt  gdk_dbpath = /home/mytherin/opt/var/mTests_sql_backends_monet5
+# cmdline opt  mal_listing = 0
+# cmdline opt  embedded_r = true
+# cmdline opt  embedded_py = true
+# cmdline opt  gdk_debug = 536870922
+
+# 22:40:26 >  
+# 22:40:26 >  "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e" 
"--host=/var/tmp/mtest-8581" "--port=32251"
+# 22:40:26 >  
+
+
+# 22:40:26 >  
+# 22:40:26 >  "Done."
+# 22:40:26 >  
+
diff --git a/sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_01.stable.out 
b/sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_01.stable.out
new file mode 100644
--- /dev/null
+++ b/sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_01.stable.out
@@ -0,0 +1,59 @@
+stdout of test 'pyapi3_01` in directory 'sql/backends/monet5/UDF/pyapi3` 
itself:
+
+
+# 22:40:25 >  
+# 22:40:25 >  "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" 
"mapi_open=true" "--set" "mapi_port=32251" "--set" 
"mapi_usock=/var/tmp/mtest-8581/.s.monetdb.32251" "--set" "monet_prompt=" 
"--forcemito" "--set" "mal_listing=2" 
"--dbpath=/home/mytherin/opt/var/mTests_sql_backends_monet5" "--set" 
"mal_listing=0" "--set" "embedded_r=true" "--set" "embedded_py=true"
+# 22:40:25 >  
+
+# MonetDB 5 server v11.20.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 and 128bit 
integers dynamically linked
+# Found 7.684 GiB available main-memory.
+# Copyright (c) 1993-July 2008 CWI.
+# Copyright (c) August 2008-2015 MonetDB B.V., all rights reserved
+# Visit http://www.monetdb.org/ for further information
+# Listening for connection requests on mapi:monetdb://mytherin-N750JV:32251/
+# Listening for UNIX domain connection requests on 
mapi:monetdb:///var/tmp/mtest-8581/.s.monetdb.32251
+# MonetDB/SQL module loaded
+# MonetDB/Python module loaded
+# MonetDB/R   module loaded
+
+Ready.
+
+# 22:40:26 >  
+# 22:40:26 >  "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e" 
"--host=/var/tmp/mtest-8581" "--port=32251"
+# 22:40:26 >  
+
+#START TRANSACTION;
+#CREATE FUNCTION pyapi01(i integer) returns table (i integer, d double)
+#language P
+#{
+#      x = range(1, i + 1)
+#      y = [42.0] * i
+#      return([x,y])
+#};
+#SELECT i,d FROM pyapi01(42) AS R WHERE i>30;
+% .r,  .r # table_name
+% i,   d # name
+% int, double # type
+% 2,   24 # length
+[ 31,  42      ]
+[ 32,  42      ]
+[ 33,  42      ]
+[ 34,  42      ]
+[ 35,  42      ]
+[ 36,  42      ]
+[ 37,  42      ]
+[ 38,  42      ]
+[ 39,  42      ]
+[ 40,  42      ]
+[ 41,  42      ]
+[ 42,  42      ]
+#DROP FUNCTION pyapi01;
+#ROLLBACK;
+
+# 22:40:26 >  
+# 22:40:26 >  "Done."
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list

Reply via email to