Update of /cvsroot/monetdb/geom/src/sql/Tests
In directory
sfp-cvsdas-1.v30.ch3.sourceforge.com:/tmp/cvs-serv19155/src/sql/Tests
Added Files:
Tag: Feb2010
basic.stable.err geom_curve.stable.err
geom_geometry.stable.err geom_linestring.stable.err
geom_mbr.stable.err geom_point.stable.err
geom_polygon.stable.err geom_surface.stable.err
relation.stable.err spatial.stable.err
Removed Files:
Tag: Feb2010
basic.stable.err.Five geom_curve.stable.err.Five
geom_geometry.stable.err.Five geom_linestring.stable.err.Five
geom_mbr.stable.err.Five geom_point.stable.err.Five
geom_polygon.stable.err.Five geom_surface.stable.err.Five
relation.stable.err.Five spatial.stable.err.Five
Log Message:
"Five" (MonetDB/5) has become the only server for MonetDB/SQL
and thus MonetDB/GIS (geom) SQL tests;
hence, we rename the specific "*.stable.err.Five"
to become the standard "*.stable.err"
--- NEW FILE: geom_linestring.stable.err ---
stderr of test 'geom_linestring` in directory 'src/sql` itself:
# 21:15:14 >
# 21:15:14 > Mtimeout -timeout 180 Mserver
"--config=/ufs/niels/scratch/monetdb/Linux-x86_64/etc/MonetDB.conf" --debug=10
--set
"monet_mod_path=/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB4:/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB4/lib:/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB4/bin"
--set "gdk_dbfarm=/ufs/niels/scratch/monetdb/Linux-x86_64/var/MonetDB4/dbfarm"
--set
"sql_logdir=/ufs/niels/scratch/monetdb/Linux-x86_64/var/MonetDB4/sql_logs"
--set
"xquery_logdir=/ufs/niels/scratch/monetdb/Linux-x86_64/var/MonetDB4/xquery_logs"
--set mapi_port=36438 --set xrpc_port=48112 --set monet_prompt= --trace
"--dbname=mTests_src_sql" --dbinit="module(geom);module(sql_server);
module(sql_server);" ; echo ; echo Over..
# 21:15:14 >
# builtin opt gdk_arch = 64bitx86_64-unknown-linux-gnu
# builtin opt gdk_version = 1.25.0
# builtin opt monet_pid = 4424
# builtin opt prefix = /home/sjoerd/Monet
# builtin opt exec_prefix = ${prefix}
# builtin opt gdk_dbname = tst
# builtin opt gdk_dbfarm = ${prefix}/var/MonetDB
# builtin opt gdk_debug = 8
# builtin opt gdk_mem_bigsize = 262144
# builtin opt gdk_alloc_map = yes
# builtin opt gdk_mem_pagebits = 14
# builtin opt gdk_vmtrim = yes
# builtin opt monet_admin = adm
# builtin opt monet_prompt = >
# builtin opt monet_welcome = yes
# builtin opt monet_mod_path = ${prefix}/lib64/MonetDB:${prefix}/lib64/bin
# builtin opt monet_daemon = yes
# builtin opt host = localhost
# builtin opt mapi_port = 50000
# builtin opt mapi_noheaders = no
# builtin opt mapi_debug = 0
# builtin opt mapi_clients = 2
# builtin opt sql_debug = 0
# builtin opt sql_logdir = ${prefix}/var/MonetDB
# builtin opt xquery_logdir = ${prefix}/var/MonetDB
# builtin opt standoff_ns = http://monetdb.cwi.nl/standoff
# builtin opt standoff_start = start
# builtin opt standoff_end = end
# config opt prefix = /home/sjoerd/Monet
# config opt config = ${prefix}/etc/monetdb5.conf
# config opt prefix = /home/sjoerd/Monet
# config opt exec_prefix = ${prefix}
# config opt gdk_dbfarm = ${prefix}/var/MonetDB5/dbfarm
# config opt gdk_dbname = demo
# config opt gdk_alloc_map = no
# config opt gdk_embedded = no
# config opt gdk_debug = 0
# config opt monet_mod_path =
${prefix}/lib64/MonetDB5:${prefix}/lib64/MonetDB5/lib:${prefix}/lib64/MonetDB5/bin
# config opt monet_daemon = no
# config opt monet_welcome = yes
# config opt mero_msglog = ${prefix}/var/log/merovingian.log
# config opt mero_errlog = ${prefix}/var/log/merovingian.log
# config opt mero_timeinterval = 600
# config opt mero_pidfile = ${prefix}/var/run/merovingian.pid
# config opt mero_exittimeout = 7
# config opt mero_doproxy = yes
# config opt mero_discoveryttl = 600
# config opt mal_init = ${prefix}/lib64/MonetDB5/mal_init.mal
# config opt mal_listing = 58
# config opt checkpoint_dir = ${prefix}/var/MonetDB5/chkpnt
# config opt mapi_port = 50000
# config opt mapi_open = false
# config opt sql_debug = 0
# config opt sql_logdir = ${prefix}/var/MonetDB5/sql_logs
# config opt sql_init = ${prefix}/lib64/MonetDB5/sql_init.sql
# cmdline opt config = /home/sjoerd/Monet/etc/monetdb5.conf
# cmdline opt gdk_nr_threads = 0
# cmdline opt monet_mod_path =
/home/sjoerd/src/MonetDB/devel/geom/x86_64-unknown-linux-gnu/src/monetdb5/.libs:/home/sjoerd/src/MonetDB/devel/geom/x86_64-unknown-linux-gnu/src/monetdb5:/home/sjoerd/Monet/lib64/MonetDB5:/home/sjoerd/Monet/lib64/MonetDB5/lib:/home/sjoerd/Monet/lib64/MonetDB5/bin:/home/sjoerd/Monet/lib64/MonetDB5:/home/sjoerd/Monet/lib64/MonetDB5/lib:/home/sjoerd/Monet/lib64/MonetDB5/bin
# cmdline opt gdk_dbfarm =
/home/sjoerd/src/MonetDB/devel/geom/x86_64-unknown-linux-gnu/dbfarm
# cmdline opt sql_logdir =
/home/sjoerd/src/MonetDB/devel/geom/x86_64-unknown-linux-gnu/sql_logs
# cmdline opt xquery_logdir =
/home/sjoerd/src/MonetDB/devel/geom/x86_64-unknown-linux-gnu/xquery_logs
# cmdline opt mapi_open = true
# cmdline opt xrpc_open = true
# cmdline opt mapi_port = 38689
# cmdline opt xrpc_port = 41370
# cmdline opt monet_prompt =
# cmdline opt gdk_dbname = mTests_src_sql
# cmdline opt mal_listing = 0
# cmdline opt gdk_debug = 10
#warning: please don't forget to set your vault key!
#(see /home/sjoerd/Monet/etc/monetdb5.conf)
# 20:49:34 >
# 20:49:34 > mclient -lsql -umonetdb -Pmonetdb --host=koolmees --port=38689
# 20:49:34 >
MAPI = mone...@ottar:32754
QUERY = INSERT INTO lines values ('POINT(10 10)');
ERROR = !MALException:wkb.FromText:Geometry type 'Line' not found
MAPI = mone...@ottar:32754
QUERY = INSERT INTO lines values ('POLYGON((10 10, 10 20, 20 20, 20 15, 10
10))');
ERROR = !MALException:wkb.FromText:Geometry type 'Line' not found
MAPI = mone...@ottar:32754
QUERY = INSERT INTO lines values ('POLYGON((10 10, 10 20, 20 20, 20 15, 10 10),
(15 15, 15 20, 10 15, 15 15))');
ERROR = !MALException:wkb.FromText:Geometry type 'Line' not found
MAPI = mone...@ottar:32754
QUERY = INSERT INTO lines values ('LINESTRING(10 10)');
ERROR = !MALException:wkb.FromText:IllegalArgumentException: point array must
contain 0 or >1 elements
MAPI = mone...@ottar:32754
QUERY = INSERT INTO lines values ('LINESTRING(10)');
ERROR = !MALException:wkb.FromText:ParseException: Expected number but
encountered ')'
MAPI = mone...@ottar:32754
QUERY = INSERT INTO lines values ('LINESTRING()');
ERROR = !MALException:wkb.FromText:ParseException: Expected number but
encountered ')'
MAPI = mone...@ottar:32754
QUERY = INSERT INTO lines values ('LINESTRING');
ERROR = !MALException:wkb.FromText:ParseException: Expected word but
encountered end of stream
MAPI = mone...@ottar:32754
QUERY = INSERT INTO lines values ('');
ERROR = !MALException:wkb.FromText:ParseException: Expected word but
encountered end of stream
# 21:15:15 >
# 21:15:15 > Done.
# 21:15:15 >
--- spatial.stable.err.Five DELETED ---
--- geom_mbr.stable.err.Five DELETED ---
--- NEW FILE: geom_surface.stable.err ---
stderr of test 'geom_surface` in directory 'src/sql` itself:
# 21:15:15 >
# 21:15:15 > Mtimeout -timeout 180 Mserver
"--config=/ufs/niels/scratch/monetdb/Linux-x86_64/etc/MonetDB.conf" --debug=10
--set
"monet_mod_path=/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB4:/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB4/lib:/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB4/bin"
--set "gdk_dbfarm=/ufs/niels/scratch/monetdb/Linux-x86_64/var/MonetDB4/dbfarm"
--set
"sql_logdir=/ufs/niels/scratch/monetdb/Linux-x86_64/var/MonetDB4/sql_logs"
--set
"xquery_logdir=/ufs/niels/scratch/monetdb/Linux-x86_64/var/MonetDB4/xquery_logs"
--set mapi_port=36438 --set xrpc_port=48112 --set monet_prompt= --trace
"--dbname=mTests_src_sql" --dbinit="module(geom);module(sql_server);
module(sql_server);" ; echo ; echo Over..
# 21:15:15 >
# builtin opt gdk_arch = 64bitx86_64-unknown-linux-gnu
# builtin opt gdk_version = 1.25.0
# builtin opt monet_pid = 4442
# builtin opt prefix = /home/sjoerd/Monet
# builtin opt exec_prefix = ${prefix}
# builtin opt gdk_dbname = tst
# builtin opt gdk_dbfarm = ${prefix}/var/MonetDB
# builtin opt gdk_debug = 8
# builtin opt gdk_mem_bigsize = 262144
# builtin opt gdk_alloc_map = yes
# builtin opt gdk_mem_pagebits = 14
# builtin opt gdk_vmtrim = yes
# builtin opt monet_admin = adm
# builtin opt monet_prompt = >
# builtin opt monet_welcome = yes
# builtin opt monet_mod_path = ${prefix}/lib64/MonetDB:${prefix}/lib64/bin
# builtin opt monet_daemon = yes
# builtin opt host = localhost
# builtin opt mapi_port = 50000
# builtin opt mapi_noheaders = no
# builtin opt mapi_debug = 0
# builtin opt mapi_clients = 2
# builtin opt sql_debug = 0
# builtin opt sql_logdir = ${prefix}/var/MonetDB
# builtin opt xquery_logdir = ${prefix}/var/MonetDB
# builtin opt standoff_ns = http://monetdb.cwi.nl/standoff
# builtin opt standoff_start = start
# builtin opt standoff_end = end
# config opt prefix = /home/sjoerd/Monet
# config opt config = ${prefix}/etc/monetdb5.conf
# config opt prefix = /home/sjoerd/Monet
# config opt exec_prefix = ${prefix}
# config opt gdk_dbfarm = ${prefix}/var/MonetDB5/dbfarm
# config opt gdk_dbname = demo
# config opt gdk_alloc_map = no
# config opt gdk_embedded = no
# config opt gdk_debug = 0
# config opt monet_mod_path =
${prefix}/lib64/MonetDB5:${prefix}/lib64/MonetDB5/lib:${prefix}/lib64/MonetDB5/bin
# config opt monet_daemon = no
# config opt monet_welcome = yes
# config opt mero_msglog = ${prefix}/var/log/merovingian.log
# config opt mero_errlog = ${prefix}/var/log/merovingian.log
# config opt mero_timeinterval = 600
# config opt mero_pidfile = ${prefix}/var/run/merovingian.pid
# config opt mero_exittimeout = 7
# config opt mero_doproxy = yes
# config opt mero_discoveryttl = 600
# config opt mal_init = ${prefix}/lib64/MonetDB5/mal_init.mal
# config opt mal_listing = 58
# config opt checkpoint_dir = ${prefix}/var/MonetDB5/chkpnt
# config opt mapi_port = 50000
# config opt mapi_open = false
# config opt sql_debug = 0
# config opt sql_logdir = ${prefix}/var/MonetDB5/sql_logs
# config opt sql_init = ${prefix}/lib64/MonetDB5/sql_init.sql
# cmdline opt config = /home/sjoerd/Monet/etc/monetdb5.conf
# cmdline opt gdk_nr_threads = 0
# cmdline opt monet_mod_path =
/home/sjoerd/src/MonetDB/devel/geom/x86_64-unknown-linux-gnu/src/monetdb5/.libs:/home/sjoerd/src/MonetDB/devel/geom/x86_64-unknown-linux-gnu/src/monetdb5:/home/sjoerd/Monet/lib64/MonetDB5:/home/sjoerd/Monet/lib64/MonetDB5/lib:/home/sjoerd/Monet/lib64/MonetDB5/bin:/home/sjoerd/Monet/lib64/MonetDB5:/home/sjoerd/Monet/lib64/MonetDB5/lib:/home/sjoerd/Monet/lib64/MonetDB5/bin
# cmdline opt gdk_dbfarm =
/home/sjoerd/src/MonetDB/devel/geom/x86_64-unknown-linux-gnu/dbfarm
# cmdline opt sql_logdir =
/home/sjoerd/src/MonetDB/devel/geom/x86_64-unknown-linux-gnu/sql_logs
# cmdline opt xquery_logdir =
/home/sjoerd/src/MonetDB/devel/geom/x86_64-unknown-linux-gnu/xquery_logs
# cmdline opt mapi_open = true
# cmdline opt xrpc_open = true
# cmdline opt mapi_port = 38689
# cmdline opt xrpc_port = 41370
# cmdline opt monet_prompt =
# cmdline opt gdk_dbname = mTests_src_sql
# cmdline opt mal_listing = 0
# cmdline opt gdk_debug = 10
#warning: please don't forget to set your vault key!
#(see /home/sjoerd/Monet/etc/monetdb5.conf)
# 20:49:34 >
# 20:49:34 > mclient -lsql -umonetdb -Pmonetdb --host=koolmees --port=38689
# 20:49:34 >
MAPI = mone...@ottar:32754
QUERY = INSERT INTO surfaces values ('LINESTRING(10 10, 20 20)');
ERROR = !MALException:wkb.FromText:Geometry type 'Polygon' not found
MAPI = mone...@ottar:32754
QUERY = INSERT INTO surfaces values ('LINESTRING(10 10, 20 20, 30 40)');
ERROR = !MALException:wkb.FromText:Geometry type 'Polygon' not found
MAPI = mone...@ottar:32754
QUERY = INSERT INTO surfaces values ('POINT(10 10)');
ERROR = !MALException:wkb.FromText:Geometry type 'Polygon' not found
MAPI = mone...@ottar:32754
QUERY = INSERT INTO surfaces values ('POLYGON(10 10)');
ERROR = !MALException:wkb.FromText:ParseException: Expected word but
encountered number: '10'
MAPI = mone...@ottar:32754
QUERY = INSERT INTO surfaces values ('POLYGON(10)');
ERROR = !MALException:wkb.FromText:ParseException: Expected word but
encountered number: '10'
MAPI = mone...@ottar:32754
QUERY = INSERT INTO surfaces values ('POLYGON()');
ERROR = !MALException:wkb.FromText:ParseException: Expected 'EMPTY' or '(' but
encountered : ')'
MAPI = mone...@ottar:32754
QUERY = INSERT INTO surfaces values ('POLYGON');
ERROR = !MALException:wkb.FromText:ParseException: Expected word but
encountered end of stream
MAPI = mone...@ottar:32754
QUERY = INSERT INTO surfaces values ('');
ERROR = !MALException:wkb.FromText:ParseException: Expected word but
encountered end of stream
# 21:15:15 >
# 21:15:15 > Done.
# 21:15:15 >
--- NEW FILE: geom_geometry.stable.err ---
stderr of test 'geom_geometry` in directory 'src/sql` itself:
# 21:15:13 >
# 21:15:13 > Mtimeout -timeout 180 Mserver
"--config=/ufs/niels/scratch/monetdb/Linux-x86_64/etc/MonetDB.conf" --debug=10
--set
"monet_mod_path=/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB4:/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB4/lib:/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB4/bin"
--set "gdk_dbfarm=/ufs/niels/scratch/monetdb/Linux-x86_64/var/MonetDB4/dbfarm"
--set
"sql_logdir=/ufs/niels/scratch/monetdb/Linux-x86_64/var/MonetDB4/sql_logs"
--set
"xquery_logdir=/ufs/niels/scratch/monetdb/Linux-x86_64/var/MonetDB4/xquery_logs"
--set mapi_port=36438 --set xrpc_port=48112 --set monet_prompt= --trace
"--dbname=mTests_src_sql" --dbinit="module(geom);module(sql_server);
module(sql_server);" ; echo ; echo Over..
# 21:15:13 >
# 21:15:13 >
# 21:15:13 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=36438
# 21:15:13 >
MAPI = mone...@ottar:32754
QUERY = INSERT INTO geoms values ('LINESTRING(10 10)');
ERROR = !MALException:wkb.FromText:IllegalArgumentException: point array must
contain 0 or >1 elements
MAPI = mone...@ottar:32754
QUERY = INSERT INTO geoms values ('LINESTRING(10)');
ERROR = !MALException:wkb.FromText:ParseException: Expected number but
encountered ')'
MAPI = mone...@ottar:32754
QUERY = INSERT INTO geoms values ('LINESTRING()');
ERROR = !MALException:wkb.FromText:ParseException: Expected number but
encountered ')'
MAPI = mone...@ottar:32754
QUERY = INSERT INTO geoms values ('LINESTRING');
ERROR = !MALException:wkb.FromText:ParseException: Expected word but
encountered end of stream
MAPI = mone...@ottar:32754
QUERY = INSERT INTO geoms values ('');
ERROR = !MALException:wkb.FromText:ParseException: Expected word but
encountered end of stream
MAPI = mone...@ottar:32754
QUERY = INSERT INTO geoms values ('POINT(10)');
ERROR = !MALException:wkb.FromText:ParseException: Expected number but
encountered ')'
MAPI = mone...@ottar:32754
QUERY = INSERT INTO geoms values ('POINT()');
ERROR = !MALException:wkb.FromText:ParseException: Expected number but
encountered ')'
MAPI = mone...@ottar:32754
QUERY = INSERT INTO geoms values ('POINT');
ERROR = !MALException:wkb.FromText:ParseException: Expected word but
encountered end of stream
MAPI = mone...@ottar:32754
QUERY = INSERT INTO geoms values ('');
ERROR = !MALException:wkb.FromText:ParseException: Expected word but
encountered end of stream
# 21:57:03 >
# 21:57:03 > Done.
# 21:57:03 >
--- NEW FILE: basic.stable.err ---
stderr of test 'basic` in directory 'src/sql` itself:
# 09:07:40 >
# 09:07:40 > Mtimeout -timeout 180 Mserver
"--config=/ufs/niels/scratch/g2/Linux-x86_64/etc/MonetDB.conf" --debug=10 --set
"monet_mod_path=/ufs/niels/scratch/g2/Linux-x86_64/lib/MonetDB4:/ufs/niels/scratch/g2/Linux-x86_64/lib/MonetDB4/lib:/ufs/niels/scratch/g2/Linux-x86_64/lib/MonetDB4/bin"
--set "gdk_dbfarm=/ufs/niels/scratch/g2/Linux-x86_64/var/MonetDB4/dbfarm"
--set "sql_logdir=/ufs/niels/scratch/g2/Linux-x86_64/var/MonetDB4/sql_logs"
--set
"xquery_logdir=/ufs/niels/scratch/g2/Linux-x86_64/var/MonetDB4/xquery_logs"
--set mapi_open=true --set xrpc_open=true --set mapi_port=34403 --set
xrpc_port=45888 --set monet_prompt= --trace "--dbname=mTests_src_sql"
--dbinit="module(geom); module(sql_server);" ; echo ; echo Over..
# 09:07:40 >
# 09:07:41 >
# 09:07:41 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=koala --port=34403
# 09:07:41 >
MAPI = mone...@koolmees:38689
QUERY = INSERT INTO geoms values ('LINESTRING(10 10)');
ERROR = !MALException:wkb.FromText:IllegalArgumentException: point array must
contain 0 or >1 elements
MAPI = mone...@koolmees:38689
QUERY = INSERT INTO geoms values ('LINESTRING(10)');
ERROR = !MALException:wkb.FromText:ParseException: Expected number but
encountered ')'
MAPI = mone...@koolmees:38689
QUERY = INSERT INTO geoms values ('LINESTRING()');
ERROR = !MALException:wkb.FromText:ParseException: Expected number but
encountered ')'
MAPI = mone...@koolmees:38689
QUERY = INSERT INTO geoms values ('LINESTRING');
ERROR = !MALException:wkb.FromText:ParseException: Expected word but
encountered end of stream
MAPI = mone...@koolmees:38689
QUERY = INSERT INTO geoms values ('');
ERROR = !MALException:wkb.FromText:ParseException: Expected word but
encountered end of stream
MAPI = mone...@koolmees:38689
QUERY = INSERT INTO geoms values ('POINT(10)');
ERROR = !MALException:wkb.FromText:ParseException: Expected number but
encountered ')'
MAPI = mone...@koolmees:38689
QUERY = INSERT INTO geoms values ('POINT()');
ERROR = !MALException:wkb.FromText:ParseException: Expected number but
encountered ')'
MAPI = mone...@koolmees:38689
QUERY = INSERT INTO geoms values ('POINT');
ERROR = !MALException:wkb.FromText:ParseException: Expected word but
encountered end of stream
MAPI = mone...@koolmees:38689
QUERY = INSERT INTO geoms values ('');
ERROR = !MALException:wkb.FromText:ParseException: Expected word but
encountered end of stream
# 09:07:41 >
# 09:07:41 > Done.
# 09:07:41 >
--- NEW FILE: relation.stable.err ---
stderr of test 'relation` in directory 'src/sql` itself:
# 22:42:46 >
# 22:42:46 > Mtimeout -timeout 180 Mserver
"--config=/ufs/niels/scratch/rc/Linux-x86_64/etc/MonetDB.conf" --debug=10 --set
"monet_mod_path=/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB4:/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB4/lib:/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB4/bin"
--set "gdk_dbfarm=/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB4/dbfarm"
--set "sql_logdir=/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB4/sql_logs"
--set
"xquery_logdir=/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB4/xquery_logs"
--set mapi_open=true --set xrpc_open=true --set mapi_port=32262 --set
xrpc_port=47875 --set monet_prompt= --trace "--dbname=mTests_src_sql"
--dbinit="module(geom); module(sql_server);" ; echo ; echo Over..
# 22:42:46 >
# 22:42:46 >
# 22:42:46 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=koala --port=32262
# 22:42:46 >
MAPI = mone...@koolmees:30183
QUERY = INSERT INTO geoms values ('LINESTRING(10 10)');
ERROR = !MALException:wkb.FromText:IllegalArgumentException: point array must
contain 0 or >1 elements
MAPI = mone...@koolmees:30183
QUERY = INSERT INTO geoms values ('LINESTRING(10)');
ERROR = !MALException:wkb.FromText:ParseException: Expected number but
encountered ')'
MAPI = mone...@koolmees:30183
QUERY = INSERT INTO geoms values ('LINESTRING()');
ERROR = !MALException:wkb.FromText:ParseException: Expected number but
encountered ')'
MAPI = mone...@koolmees:30183
QUERY = INSERT INTO geoms values ('LINESTRING');
ERROR = !MALException:wkb.FromText:ParseException: Expected word but
encountered end of stream
MAPI = mone...@koolmees:30183
QUERY = INSERT INTO geoms values ('');
ERROR = !MALException:wkb.FromText:ParseException: Expected word but
encountered end of stream
MAPI = mone...@koolmees:30183
QUERY = INSERT INTO geoms values ('POINT(10)');
ERROR = !MALException:wkb.FromText:ParseException: Expected number but
encountered ')'
MAPI = mone...@koolmees:30183
QUERY = INSERT INTO geoms values ('POINT()');
ERROR = !MALException:wkb.FromText:ParseException: Expected number but
encountered ')'
MAPI = mone...@koolmees:30183
QUERY = INSERT INTO geoms values ('POINT');
ERROR = !MALException:wkb.FromText:ParseException: Expected word but
encountered end of stream
MAPI = mone...@koolmees:30183
QUERY = INSERT INTO geoms values ('');
ERROR = !MALException:wkb.FromText:ParseException: Expected word but
encountered end of stream
# 20:50:35 >
# 20:50:35 > Done.
# 20:50:35 >
--- NEW FILE: geom_point.stable.err ---
stderr of test 'geom_point` in directory 'src/sql` itself:
# 21:15:12 >
# 21:15:12 > Mtimeout -timeout 180 Mserver
"--config=/ufs/niels/scratch/monetdb/Linux-x86_64/etc/MonetDB.conf" --debug=10
--set
"monet_mod_path=/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB4:/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB4/lib:/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB4/bin"
--set "gdk_dbfarm=/ufs/niels/scratch/monetdb/Linux-x86_64/var/MonetDB4/dbfarm"
--set
"sql_logdir=/ufs/niels/scratch/monetdb/Linux-x86_64/var/MonetDB4/sql_logs"
--set
"xquery_logdir=/ufs/niels/scratch/monetdb/Linux-x86_64/var/MonetDB4/xquery_logs"
--set mapi_port=36438 --set xrpc_port=48112 --set monet_prompt= --trace
"--dbname=mTests_src_sql" --dbinit="module(geom);module(sql_server);
module(sql_server);" ; echo ; echo Over..
# 21:15:12 >
# builtin opt gdk_arch = 64bitx86_64-unknown-linux-gnu
# builtin opt gdk_version = 1.25.0
# builtin opt monet_pid = 4365
# builtin opt prefix = /home/sjoerd/Monet
# builtin opt exec_prefix = ${prefix}
# builtin opt gdk_dbname = tst
# builtin opt gdk_dbfarm = ${prefix}/var/MonetDB
# builtin opt gdk_debug = 8
# builtin opt gdk_mem_bigsize = 262144
# builtin opt gdk_alloc_map = yes
# builtin opt gdk_mem_pagebits = 14
# builtin opt gdk_vmtrim = yes
# builtin opt monet_admin = adm
# builtin opt monet_prompt = >
# builtin opt monet_welcome = yes
# builtin opt monet_mod_path = ${prefix}/lib64/MonetDB:${prefix}/lib64/bin
# builtin opt monet_daemon = yes
# builtin opt host = localhost
# builtin opt mapi_port = 50000
# builtin opt mapi_noheaders = no
# builtin opt mapi_debug = 0
# builtin opt mapi_clients = 2
# builtin opt sql_debug = 0
# builtin opt sql_logdir = ${prefix}/var/MonetDB
# builtin opt xquery_logdir = ${prefix}/var/MonetDB
# builtin opt standoff_ns = http://monetdb.cwi.nl/standoff
# builtin opt standoff_start = start
# builtin opt standoff_end = end
# config opt prefix = /home/sjoerd/Monet
# config opt config = ${prefix}/etc/monetdb5.conf
# config opt prefix = /home/sjoerd/Monet
# config opt exec_prefix = ${prefix}
# config opt gdk_dbfarm = ${prefix}/var/MonetDB5/dbfarm
# config opt gdk_dbname = demo
# config opt gdk_alloc_map = no
# config opt gdk_embedded = no
# config opt gdk_debug = 0
# config opt monet_mod_path =
${prefix}/lib64/MonetDB5:${prefix}/lib64/MonetDB5/lib:${prefix}/lib64/MonetDB5/bin
# config opt monet_daemon = no
# config opt monet_welcome = yes
# config opt mero_msglog = ${prefix}/var/log/merovingian.log
# config opt mero_errlog = ${prefix}/var/log/merovingian.log
# config opt mero_timeinterval = 600
# config opt mero_pidfile = ${prefix}/var/run/merovingian.pid
# config opt mero_exittimeout = 7
# config opt mero_doproxy = yes
# config opt mero_discoveryttl = 600
# config opt mal_init = ${prefix}/lib64/MonetDB5/mal_init.mal
# config opt mal_listing = 58
# config opt checkpoint_dir = ${prefix}/var/MonetDB5/chkpnt
# config opt mapi_port = 50000
# config opt mapi_open = false
# config opt sql_debug = 0
# config opt sql_logdir = ${prefix}/var/MonetDB5/sql_logs
# config opt sql_init = ${prefix}/lib64/MonetDB5/sql_init.sql
# cmdline opt config = /home/sjoerd/Monet/etc/monetdb5.conf
# cmdline opt gdk_nr_threads = 0
# cmdline opt monet_mod_path =
/home/sjoerd/src/MonetDB/devel/geom/x86_64-unknown-linux-gnu/src/monetdb5/.libs:/home/sjoerd/src/MonetDB/devel/geom/x86_64-unknown-linux-gnu/src/monetdb5:/home/sjoerd/Monet/lib64/MonetDB5:/home/sjoerd/Monet/lib64/MonetDB5/lib:/home/sjoerd/Monet/lib64/MonetDB5/bin:/home/sjoerd/Monet/lib64/MonetDB5:/home/sjoerd/Monet/lib64/MonetDB5/lib:/home/sjoerd/Monet/lib64/MonetDB5/bin
# cmdline opt gdk_dbfarm =
/home/sjoerd/src/MonetDB/devel/geom/x86_64-unknown-linux-gnu/dbfarm
# cmdline opt sql_logdir =
/home/sjoerd/src/MonetDB/devel/geom/x86_64-unknown-linux-gnu/sql_logs
# cmdline opt xquery_logdir =
/home/sjoerd/src/MonetDB/devel/geom/x86_64-unknown-linux-gnu/xquery_logs
# cmdline opt mapi_open = true
# cmdline opt xrpc_open = true
# cmdline opt mapi_port = 38689
# cmdline opt xrpc_port = 41370
# cmdline opt monet_prompt =
# cmdline opt gdk_dbname = mTests_src_sql
# cmdline opt mal_listing = 0
# cmdline opt gdk_debug = 10
#warning: please don't forget to set your vault key!
#(see /home/sjoerd/Monet/etc/monetdb5.conf)
# 20:49:34 >
# 20:49:34 > mclient -lsql -umonetdb -Pmonetdb --host=koolmees --port=38689
# 20:49:34 >
MAPI = mone...@ottar:32754
QUERY = INSERT INTO points values ('POINT(10)');
ERROR = !MALException:wkb.FromText:ParseException: Expected number but
encountered ')'
MAPI = mone...@ottar:32754
QUERY = INSERT INTO points values ('POINT()');
ERROR = !MALException:wkb.FromText:ParseException: Expected number but
encountered ')'
MAPI = mone...@ottar:32754
QUERY = INSERT INTO points values ('POINT');
ERROR = !MALException:wkb.FromText:ParseException: Expected word but
encountered end of stream
MAPI = mone...@ottar:32754
QUERY = INSERT INTO points values ('');
ERROR = !MALException:wkb.FromText:ParseException: Expected word but
encountered end of stream
# 21:15:13 >
# 21:15:13 > Done.
# 21:15:13 >
--- geom_curve.stable.err.Five DELETED ---
--- relation.stable.err.Five DELETED ---
--- geom_point.stable.err.Five DELETED ---
--- geom_geometry.stable.err.Five DELETED ---
--- NEW FILE: geom_polygon.stable.err ---
stderr of test 'geom_polygon` in directory 'src/sql` itself:
# 21:15:16 >
# 21:15:16 > Mtimeout -timeout 180 Mserver
"--config=/ufs/niels/scratch/monetdb/Linux-x86_64/etc/MonetDB.conf" --debug=10
--set
"monet_mod_path=/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB4:/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB4/lib:/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB4/bin"
--set "gdk_dbfarm=/ufs/niels/scratch/monetdb/Linux-x86_64/var/MonetDB4/dbfarm"
--set
"sql_logdir=/ufs/niels/scratch/monetdb/Linux-x86_64/var/MonetDB4/sql_logs"
--set
"xquery_logdir=/ufs/niels/scratch/monetdb/Linux-x86_64/var/MonetDB4/xquery_logs"
--set mapi_port=36438 --set xrpc_port=48112 --set monet_prompt= --trace
"--dbname=mTests_src_sql" --dbinit="module(geom);module(sql_server);
module(sql_server);" ; echo ; echo Over..
# 21:15:16 >
# builtin opt gdk_arch = 64bitx86_64-unknown-linux-gnu
# builtin opt gdk_version = 1.25.0
# builtin opt monet_pid = 4460
# builtin opt prefix = /home/sjoerd/Monet
# builtin opt exec_prefix = ${prefix}
# builtin opt gdk_dbname = tst
# builtin opt gdk_dbfarm = ${prefix}/var/MonetDB
# builtin opt gdk_debug = 8
# builtin opt gdk_mem_bigsize = 262144
# builtin opt gdk_alloc_map = yes
# builtin opt gdk_mem_pagebits = 14
# builtin opt gdk_vmtrim = yes
# builtin opt monet_admin = adm
# builtin opt monet_prompt = >
# builtin opt monet_welcome = yes
# builtin opt monet_mod_path = ${prefix}/lib64/MonetDB:${prefix}/lib64/bin
# builtin opt monet_daemon = yes
# builtin opt host = localhost
# builtin opt mapi_port = 50000
# builtin opt mapi_noheaders = no
# builtin opt mapi_debug = 0
# builtin opt mapi_clients = 2
# builtin opt sql_debug = 0
# builtin opt sql_logdir = ${prefix}/var/MonetDB
# builtin opt xquery_logdir = ${prefix}/var/MonetDB
# builtin opt standoff_ns = http://monetdb.cwi.nl/standoff
# builtin opt standoff_start = start
# builtin opt standoff_end = end
# config opt prefix = /home/sjoerd/Monet
# config opt config = ${prefix}/etc/monetdb5.conf
# config opt prefix = /home/sjoerd/Monet
# config opt exec_prefix = ${prefix}
# config opt gdk_dbfarm = ${prefix}/var/MonetDB5/dbfarm
# config opt gdk_dbname = demo
# config opt gdk_alloc_map = no
# config opt gdk_embedded = no
# config opt gdk_debug = 0
# config opt monet_mod_path =
${prefix}/lib64/MonetDB5:${prefix}/lib64/MonetDB5/lib:${prefix}/lib64/MonetDB5/bin
# config opt monet_daemon = no
# config opt monet_welcome = yes
# config opt mero_msglog = ${prefix}/var/log/merovingian.log
# config opt mero_errlog = ${prefix}/var/log/merovingian.log
# config opt mero_timeinterval = 600
# config opt mero_pidfile = ${prefix}/var/run/merovingian.pid
# config opt mero_exittimeout = 7
# config opt mero_doproxy = yes
# config opt mero_discoveryttl = 600
# config opt mal_init = ${prefix}/lib64/MonetDB5/mal_init.mal
# config opt mal_listing = 58
# config opt checkpoint_dir = ${prefix}/var/MonetDB5/chkpnt
# config opt mapi_port = 50000
# config opt mapi_open = false
# config opt sql_debug = 0
# config opt sql_logdir = ${prefix}/var/MonetDB5/sql_logs
# config opt sql_init = ${prefix}/lib64/MonetDB5/sql_init.sql
# cmdline opt config = /home/sjoerd/Monet/etc/monetdb5.conf
# cmdline opt gdk_nr_threads = 0
# cmdline opt monet_mod_path =
/home/sjoerd/src/MonetDB/devel/geom/x86_64-unknown-linux-gnu/src/monetdb5/.libs:/home/sjoerd/src/MonetDB/devel/geom/x86_64-unknown-linux-gnu/src/monetdb5:/home/sjoerd/Monet/lib64/MonetDB5:/home/sjoerd/Monet/lib64/MonetDB5/lib:/home/sjoerd/Monet/lib64/MonetDB5/bin:/home/sjoerd/Monet/lib64/MonetDB5:/home/sjoerd/Monet/lib64/MonetDB5/lib:/home/sjoerd/Monet/lib64/MonetDB5/bin
# cmdline opt gdk_dbfarm =
/home/sjoerd/src/MonetDB/devel/geom/x86_64-unknown-linux-gnu/dbfarm
# cmdline opt sql_logdir =
/home/sjoerd/src/MonetDB/devel/geom/x86_64-unknown-linux-gnu/sql_logs
# cmdline opt xquery_logdir =
/home/sjoerd/src/MonetDB/devel/geom/x86_64-unknown-linux-gnu/xquery_logs
# cmdline opt mapi_open = true
# cmdline opt xrpc_open = true
# cmdline opt mapi_port = 38689
# cmdline opt xrpc_port = 41370
# cmdline opt monet_prompt =
# cmdline opt gdk_dbname = mTests_src_sql
# cmdline opt mal_listing = 0
# cmdline opt gdk_debug = 10
#warning: please don't forget to set your vault key!
#(see /home/sjoerd/Monet/etc/monetdb5.conf)
# 20:49:35 >
# 20:49:35 > mclient -lsql -umonetdb -Pmonetdb --host=koolmees --port=38689
# 20:49:35 >
MAPI = mone...@ottar:32754
QUERY = INSERT INTO polygons values ('LINESTRING(10 10, 20 20)');
ERROR = !MALException:wkb.FromText:Geometry type 'Polygon' not found
MAPI = mone...@ottar:32754
QUERY = INSERT INTO polygons values ('LINESTRING(10 10, 20 20, 30 40)');
ERROR = !MALException:wkb.FromText:Geometry type 'Polygon' not found
MAPI = mone...@ottar:32754
QUERY = INSERT INTO polygons values ('POLYGON((10 10, 10 20, 20 20, 20 15))');
ERROR = !MALException:wkb.FromText:IllegalArgumentException: points must form a
closed linestring
MAPI = mone...@ottar:32754
QUERY = INSERT INTO polygons values ('POINT(10 10)');
ERROR = !MALException:wkb.FromText:Geometry type 'Polygon' not found
MAPI = mone...@ottar:32754
QUERY = INSERT INTO polygons values ('POLYGON((10 10))');
ERROR = !MALException:wkb.FromText:IllegalArgumentException: point array must
contain 0 or >1 elements
MAPI = mone...@ottar:32754
QUERY = INSERT INTO polygons values ('POLYGON((10))');
ERROR = !MALException:wkb.FromText:ParseException: Expected number but
encountered ')'
MAPI = mone...@ottar:32754
QUERY = INSERT INTO polygons values ('POLYGON(())');
ERROR = !MALException:wkb.FromText:ParseException: Expected number but
encountered ')'
MAPI = mone...@ottar:32754
QUERY = INSERT INTO polygons values ('POLYGON()');
ERROR = !MALException:wkb.FromText:ParseException: Expected 'EMPTY' or '(' but
encountered : ')'
MAPI = mone...@ottar:32754
QUERY = INSERT INTO polygons values ('POLYGON');
ERROR = !MALException:wkb.FromText:ParseException: Expected word but
encountered end of stream
MAPI = mone...@ottar:32754
QUERY = INSERT INTO polygons values ('');
ERROR = !MALException:wkb.FromText:ParseException: Expected word but
encountered end of stream
# 21:15:16 >
# 21:15:16 > Done.
# 21:15:16 >
--- geom_surface.stable.err.Five DELETED ---
--- geom_linestring.stable.err.Five DELETED ---
--- NEW FILE: spatial.stable.err ---
stderr of test 'spatial` in directory 'src/sql` itself:
# 22:58:03 >
# 22:58:03 > Mtimeout -timeout 180 Mserver
"--config=/ufs/niels/scratch/rc/Linux-x86_64/etc/MonetDB.conf" --debug=10 --set
"monet_mod_path=/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB4:/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB4/lib:/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB4/bin"
--set "gdk_dbfarm=/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB4/dbfarm"
--set "sql_logdir=/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB4/sql_logs"
--set
"xquery_logdir=/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB4/xquery_logs"
--set mapi_open=true --set xrpc_open=true --set mapi_port=35790 --set
xrpc_port=47197 --set monet_prompt= --trace "--dbname=mTests_src_sql"
--dbinit="module(geom); module(sql_server);" ; echo ; echo Over..
# 22:58:03 >
# 22:58:03 >
# 22:58:03 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=koala --port=35790
# 22:58:03 >
MAPI = mone...@koolmees:38689
QUERY = INSERT INTO geoms values ('LINESTRING(10 10)');
ERROR = !MALException:wkb.FromText:IllegalArgumentException: point array must
contain 0 or >1 elements
MAPI = mone...@koolmees:38689
QUERY = INSERT INTO geoms values ('LINESTRING(10)');
ERROR = !MALException:wkb.FromText:ParseException: Expected number but
encountered ')'
MAPI = mone...@koolmees:38689
QUERY = INSERT INTO geoms values ('LINESTRING()');
ERROR = !MALException:wkb.FromText:ParseException: Expected number but
encountered ')'
MAPI = mone...@koolmees:38689
QUERY = INSERT INTO geoms values ('LINESTRING');
ERROR = !MALException:wkb.FromText:ParseException: Expected word but
encountered end of stream
MAPI = mone...@koolmees:38689
QUERY = INSERT INTO geoms values ('');
ERROR = !MALException:wkb.FromText:ParseException: Expected word but
encountered end of stream
MAPI = mone...@koolmees:38689
QUERY = INSERT INTO geoms values ('POINT(10)');
ERROR = !MALException:wkb.FromText:ParseException: Expected number but
encountered ')'
MAPI = mone...@koolmees:38689
QUERY = INSERT INTO geoms values ('POINT()');
ERROR = !MALException:wkb.FromText:ParseException: Expected number but
encountered ')'
MAPI = mone...@koolmees:38689
QUERY = INSERT INTO geoms values ('POINT');
ERROR = !MALException:wkb.FromText:ParseException: Expected word but
encountered end of stream
MAPI = mone...@koolmees:38689
QUERY = INSERT INTO geoms values ('');
ERROR = !MALException:wkb.FromText:ParseException: Expected word but
encountered end of stream
# 22:58:03 >
# 22:58:03 > Done.
# 22:58:03 >
--- geom_polygon.stable.err.Five DELETED ---
--- basic.stable.err.Five DELETED ---
--- NEW FILE: geom_curve.stable.err ---
stderr of test 'geom_curve` in directory 'src/sql` itself:
# 21:15:14 >
# 21:15:14 > Mtimeout -timeout 180 Mserver
"--config=/ufs/niels/scratch/monetdb/Linux-x86_64/etc/MonetDB.conf" --debug=10
--set
"monet_mod_path=/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB4:/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB4/lib:/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB4/bin"
--set "gdk_dbfarm=/ufs/niels/scratch/monetdb/Linux-x86_64/var/MonetDB4/dbfarm"
--set
"sql_logdir=/ufs/niels/scratch/monetdb/Linux-x86_64/var/MonetDB4/sql_logs"
--set
"xquery_logdir=/ufs/niels/scratch/monetdb/Linux-x86_64/var/MonetDB4/xquery_logs"
--set mapi_port=36438 --set xrpc_port=48112 --set monet_prompt= --trace
"--dbname=mTests_src_sql" --dbinit="module(geom);module(sql_server);
module(sql_server);" ; echo ; echo Over..
# 21:15:14 >
# builtin opt gdk_arch = 64bitx86_64-unknown-linux-gnu
# builtin opt gdk_version = 1.25.0
# builtin opt monet_pid = 4937
# builtin opt prefix = /home/sjoerd/Monet
# builtin opt exec_prefix = ${prefix}
# builtin opt gdk_dbname = tst
# builtin opt gdk_dbfarm = ${prefix}/var/MonetDB
# builtin opt gdk_debug = 8
# builtin opt gdk_mem_bigsize = 262144
# builtin opt gdk_alloc_map = yes
# builtin opt gdk_mem_pagebits = 14
# builtin opt gdk_vmtrim = yes
# builtin opt monet_admin = adm
# builtin opt monet_prompt = >
# builtin opt monet_welcome = yes
# builtin opt monet_mod_path = ${prefix}/lib64/MonetDB:${prefix}/lib64/bin
# builtin opt monet_daemon = yes
# builtin opt host = localhost
# builtin opt mapi_port = 50000
# builtin opt mapi_noheaders = no
# builtin opt mapi_debug = 0
# builtin opt mapi_clients = 2
# builtin opt sql_debug = 0
# builtin opt sql_logdir = ${prefix}/var/MonetDB
# builtin opt xquery_logdir = ${prefix}/var/MonetDB
# builtin opt standoff_ns = http://monetdb.cwi.nl/standoff
# builtin opt standoff_start = start
# builtin opt standoff_end = end
# config opt prefix = /home/sjoerd/Monet
# config opt config = ${prefix}/etc/monetdb5.conf
# config opt prefix = /home/sjoerd/Monet
# config opt exec_prefix = ${prefix}
# config opt gdk_dbfarm = ${prefix}/var/MonetDB5/dbfarm
# config opt gdk_dbname = demo
# config opt gdk_alloc_map = no
# config opt gdk_embedded = no
# config opt gdk_debug = 0
# config opt monet_mod_path =
${prefix}/lib64/MonetDB5:${prefix}/lib64/MonetDB5/lib:${prefix}/lib64/MonetDB5/bin
# config opt monet_daemon = no
# config opt monet_welcome = yes
# config opt mero_msglog = ${prefix}/var/log/merovingian.log
# config opt mero_errlog = ${prefix}/var/log/merovingian.log
# config opt mero_timeinterval = 600
# config opt mero_pidfile = ${prefix}/var/run/merovingian.pid
# config opt mero_exittimeout = 7
# config opt mero_doproxy = yes
# config opt mero_discoveryttl = 600
# config opt mal_init = ${prefix}/lib64/MonetDB5/mal_init.mal
# config opt mal_listing = 58
# config opt checkpoint_dir = ${prefix}/var/MonetDB5/chkpnt
# config opt mapi_port = 50000
# config opt mapi_open = false
# config opt sql_debug = 0
# config opt sql_logdir = ${prefix}/var/MonetDB5/sql_logs
# config opt sql_init = ${prefix}/lib64/MonetDB5/sql_init.sql
# cmdline opt config = /home/sjoerd/Monet/etc/monetdb5.conf
# cmdline opt gdk_nr_threads = 0
# cmdline opt monet_mod_path =
/home/sjoerd/src/MonetDB/devel/geom/x86_64-unknown-linux-gnu/src/monetdb5/.libs:/home/sjoerd/src/MonetDB/devel/geom/x86_64-unknown-linux-gnu/src/monetdb5:/home/sjoerd/Monet/lib64/MonetDB5:/home/sjoerd/Monet/lib64/MonetDB5/lib:/home/sjoerd/Monet/lib64/MonetDB5/bin:/home/sjoerd/Monet/lib64/MonetDB5:/home/sjoerd/Monet/lib64/MonetDB5/lib:/home/sjoerd/Monet/lib64/MonetDB5/bin
# cmdline opt gdk_dbfarm =
/home/sjoerd/src/MonetDB/devel/geom/x86_64-unknown-linux-gnu/dbfarm
# cmdline opt sql_logdir =
/home/sjoerd/src/MonetDB/devel/geom/x86_64-unknown-linux-gnu/sql_logs
# cmdline opt xquery_logdir =
/home/sjoerd/src/MonetDB/devel/geom/x86_64-unknown-linux-gnu/xquery_logs
# cmdline opt mapi_open = true
# cmdline opt xrpc_open = true
# cmdline opt mapi_port = 30183
# cmdline opt xrpc_port = 40872
# cmdline opt monet_prompt =
# cmdline opt gdk_dbname = mTests_src_sql
# cmdline opt mal_listing = 0
# cmdline opt gdk_debug = 10
#warning: please don't forget to set your vault key!
#(see /home/sjoerd/Monet/etc/monetdb5.conf)
# 20:50:33 >
# 20:50:33 > mclient -lsql -umonetdb -Pmonetdb --host=koolmees --port=30183
# 20:50:33 >
MAPI = mone...@ottar:32754
QUERY = INSERT INTO curves values ('POINT(10 10)');
ERROR = !MALException:wkb.FromText:Geometry type 'Line' not found
MAPI = mone...@ottar:32754
QUERY = INSERT INTO curves values ('POLYGON((10 10, 10 20, 20 20, 20 15, 10
10))');
ERROR = !MALException:wkb.FromText:Geometry type 'Line' not found
MAPI = mone...@ottar:32754
QUERY = INSERT INTO curves values ('POLYGON((10 10, 10 20, 20 20, 20 15, 10
10), (15 15, 15 20, 10 15, 15 15))');
ERROR = !MALException:wkb.FromText:Geometry type 'Line' not found
MAPI = mone...@ottar:32754
QUERY = INSERT INTO curves values ('LINESTRING(10 10)');
ERROR = !MALException:wkb.FromText:IllegalArgumentException: point array must
contain 0 or >1 elements
MAPI = mone...@ottar:32754
QUERY = INSERT INTO curves values ('LINESTRING(10)');
ERROR = !MALException:wkb.FromText:ParseException: Expected number but
encountered ')'
MAPI = mone...@ottar:32754
QUERY = INSERT INTO curves values ('LINESTRING()');
ERROR = !MALException:wkb.FromText:ParseException: Expected number but
encountered ')'
MAPI = mone...@ottar:32754
QUERY = INSERT INTO curves values ('LINESTRING');
ERROR = !MALException:wkb.FromText:ParseException: Expected word but
encountered end of stream
MAPI = mone...@ottar:32754
QUERY = INSERT INTO curves values ('');
ERROR = !MALException:wkb.FromText:ParseException: Expected word but
encountered end of stream
# 21:15:14 >
# 21:15:14 > Done.
# 21:15:14 >
--- NEW FILE: geom_mbr.stable.err ---
stderr of test 'geom_mbr` in directory 'src/sql` itself:
# 21:15:16 >
# 21:15:16 > Mtimeout -timeout 180 Mserver
"--config=/ufs/niels/scratch/monetdb/Linux-x86_64/etc/MonetDB.conf" --debug=10
--set
"monet_mod_path=/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB4:/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB4/lib:/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB4/bin"
--set "gdk_dbfarm=/ufs/niels/scratch/monetdb/Linux-x86_64/var/MonetDB4/dbfarm"
--set
"sql_logdir=/ufs/niels/scratch/monetdb/Linux-x86_64/var/MonetDB4/sql_logs"
--set
"xquery_logdir=/ufs/niels/scratch/monetdb/Linux-x86_64/var/MonetDB4/xquery_logs"
--set mapi_port=36438 --set xrpc_port=48112 --set monet_prompt= --trace
"--dbname=mTests_src_sql" --dbinit="module(geom);module(sql_server);
module(sql_server);" ; echo ; echo Over..
# 21:15:16 >
# builtin opt gdk_arch = 64bitx86_64-unknown-linux-gnu
# builtin opt gdk_version = 1.30.1
# builtin opt prefix = /ufs/sjoerd/Monet-Stable
# builtin opt exec_prefix = ${prefix}
# builtin opt gdk_dbname = tst
# builtin opt gdk_dbfarm = ${prefix}/var/MonetDB
# builtin opt gdk_debug = 8
# builtin opt gdk_alloc_map = yes
# builtin opt gdk_vmtrim = yes
# builtin opt monet_admin = adm
# builtin opt monet_prompt = >
# builtin opt monet_welcome = yes
# builtin opt monet_mod_path = ${prefix}/lib64/MonetDB
# builtin opt monet_daemon = yes
# builtin opt host = localhost
# builtin opt mapi_port = 50000
# builtin opt mapi_noheaders = no
# builtin opt mapi_debug = 0
# builtin opt mapi_clients = 2
# builtin opt sql_debug = 0
# builtin opt sql_logdir = sql_logs
# builtin opt xquery_logdir = xquery_logs
# builtin opt standoff_ns = http://monetdb.cwi.nl/standoff
# builtin opt standoff_start = start
# builtin opt standoff_end = end
# config opt prefix = /ufs/sjoerd/Monet-Stable
# config opt config = ${prefix}/etc/monetdb5.conf
# config opt prefix = /ufs/sjoerd/Monet-Stable
# config opt exec_prefix = ${prefix}
# config opt gdk_dbfarm = ${prefix}/var/MonetDB5/dbfarm
# config opt gdk_dbname = demo
# config opt gdk_alloc_map = no
# config opt gdk_embedded = no
# config opt gdk_debug = 0
# config opt monet_mod_path =
${prefix}/lib64/MonetDB5:${prefix}/lib64/MonetDB5/lib:${prefix}/lib64/MonetDB5/bin
# config opt monet_daemon = no
# config opt monet_welcome = yes
# config opt mero_msglog = ${prefix}/var/log/MonetDB/merovingian.log
# config opt mero_errlog = ${prefix}/var/log/MonetDB/merovingian.log
# config opt mero_pidfile = ${prefix}/var/run/MonetDB/merovingian.pid
# config opt mero_exittimeout = 7
# config opt mero_doproxy = yes
# config opt mero_discoveryttl = 600
# config opt mal_init = ${prefix}/lib64/MonetDB5/mal_init.mal
# config opt mal_listing = 2
# config opt mapi_port = 50000
# config opt mapi_open = false
# config opt sql_logdir = sql_logs
# cmdline opt config = /ufs/sjoerd/Monet-Stable/etc/monetdb5.conf
# cmdline opt gdk_nr_threads = 0
# cmdline opt monet_mod_path =
/ufs/sjoerd/src/MonetDB/stable/geom/x86_64-unknown-linux-gnu/src/monetdb5/.libs:/ufs/sjoerd/src/MonetDB/stable/geom/x86_64-unknown-linux-gnu/src/monetdb5:/ufs/sjoerd/Monet-Stable/lib64/MonetDB5:/ufs/sjoerd/Monet-Stable/lib64/MonetDB5/lib:/ufs/sjoerd/Monet-Stable/lib64/MonetDB5/bin:/ufs/sjoerd/Monet-Stable/lib64/MonetDB5:/ufs/sjoerd/Monet-Stable/lib64/MonetDB5/lib:/ufs/sjoerd/Monet-Stable/lib64/MonetDB5/bin
# cmdline opt gdk_dbfarm =
/ufs/sjoerd/src/MonetDB/stable/geom/x86_64-unknown-linux-gnu/dbfarm
# cmdline opt mapi_open = true
# cmdline opt xrpc_open = true
# cmdline opt mapi_port = 32754
# cmdline opt xrpc_port = 48622
# cmdline opt monet_prompt =
# cmdline opt gdk_dbname = mTests_src_sql
# cmdline opt mal_listing = 0
#warning: please don't forget to set your vault key!
#(see /ufs/sjoerd/Monet-Stable/etc/monetdb5.conf)
# 18:34:07 >
# 18:34:07 > mclient -lsql -umonetdb -Pmonetdb --host=ottar --port=32754
# 18:34:07 >
MAPI = mone...@ottar:32754
QUERY = INSERT INTO mbrs values (mbr('POINT(10)'));
ERROR = !MALException:wkb.FromText:ParseException: Expected number but
encountered ')'
MAPI = mone...@ottar:32754
QUERY = INSERT INTO mbrs values (mbr('POINT()'));
ERROR = !MALException:wkb.FromText:ParseException: Expected number but
encountered ')'
MAPI = mone...@ottar:32754
QUERY = INSERT INTO mbrs values (mbr('POINT'));
ERROR = !MALException:wkb.FromText:ParseException: Expected word but
encountered end of stream
MAPI = mone...@ottar:32754
QUERY = INSERT INTO mbrs values (mbr(''));
ERROR = !MALException:wkb.FromText:ParseException: Expected word but
encountered end of stream
# 21:15:17 >
# 21:15:17 > Done.
# 21:15:17 >
------------------------------------------------------------------------------
The Planet: dedicated and managed hosting, cloud storage, colocation
Stay online with enterprise data centers and the best network in the business
Choose flexible plans and management services without long-term contracts
Personal 24x7 support from experience hosting pros just a phone call away.
http://p.sf.net/sfu/theplanet-com
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
