Update of /cvsroot/monetdb/sql/src/test/Dump/Tests
In directory sc8-pr-cvs7.sourceforge.net:/tmp/cvs-serv23040/Dump/Tests
Added Files:
Tag: SQL_2-16
All clean.sql clean.stable.err clean.stable.out dump.SQL.py
dump.stable.err dump.stable.out load.sql load.stable.err
load.stable.out reload.SQL.py reload.stable.err
reload.stable.out test.sql test.stable.err test.stable.out
Log Message:
Test dump and restore (only of a table with a sequence so far).
--- NEW FILE: reload.stable.out ---
stdout of test 'reload` in directory 'src/test/Dump` itself:
# 17:36:22 >
# 17:36:22 > Mtimeout -timeout 180 Mserver
"--config=/ufs/sjoerd/etc/MonetDB.conf" --debug=10 --set
"monet_mod_path=/ufs/sjoerd/src/MonetDB/stable/sql/Linux/src/backends/monet4/.libs:/ufs/sjoerd/src/MonetDB/stable/sql/Linux/src/backends/monet4:/ufs/sjoerd/src/MonetDB/stable/sql/src/backends/monet4:/ufs/sjoerd/lib64/MonetDB4:/ufs/sjoerd/lib64/MonetDB4/lib:/ufs/sjoerd/lib64/MonetDB4/bin"
--set "gdk_dbfarm=/ufs/sjoerd/src/MonetDB/stable/sql/Linux/dbfarm" --set
"sql_logdir=/ufs/sjoerd/src/MonetDB/stable/sql/Linux/sql_logs" --set
"xquery_logdir=/ufs/sjoerd/src/MonetDB/stable/sql/Linux/xquery_logs" --set
mapi_port=32825 --set xrpc_port=48908 --set monet_prompt= --trace
"--dbname=mTests_src_test_Dump" --dbinit=" module(sql_server);" ; echo ; echo
Over..
# 17:36:22 >
# Monet Database Server V4.16.1
# Copyright (c) 1993-2007, CWI. All rights reserved.
# Compiled for x86_64-redhat-linux-gnu/64bit with 64bit OIDs; dynamically
linked.
# Visit http://monetdb.cwi.nl/ for further information.
printf("\nReady.\n");
Ready.
quit();
Over..
# 17:36:22 >
# 17:36:22 > Mtimeout -timeout 60 /ufs/sjoerd/bin/x86_64/python reload.SQL.py
reload
# 17:36:22 >
[ 5 ]
# 17:36:22 >
# 17:36:22 > Done.
# 17:36:22 >
--- NEW FILE: All ---
load
dump
clean
reload
test
--- NEW FILE: reload.stable.err ---
stderr of test 'reload` in directory 'src/test/Dump` itself:
# 17:36:22 >
# 17:36:22 > Mtimeout -timeout 180 Mserver
"--config=/ufs/sjoerd/etc/MonetDB.conf" --debug=10 --set
"monet_mod_path=/ufs/sjoerd/src/MonetDB/stable/sql/Linux/src/backends/monet4/.libs:/ufs/sjoerd/src/MonetDB/stable/sql/Linux/src/backends/monet4:/ufs/sjoerd/src/MonetDB/stable/sql/src/backends/monet4:/ufs/sjoerd/lib64/MonetDB4:/ufs/sjoerd/lib64/MonetDB4/lib:/ufs/sjoerd/lib64/MonetDB4/bin"
--set "gdk_dbfarm=/ufs/sjoerd/src/MonetDB/stable/sql/Linux/dbfarm" --set
"sql_logdir=/ufs/sjoerd/src/MonetDB/stable/sql/Linux/sql_logs" --set
"xquery_logdir=/ufs/sjoerd/src/MonetDB/stable/sql/Linux/xquery_logs" --set
mapi_port=32825 --set xrpc_port=48908 --set monet_prompt= --trace
"--dbname=mTests_src_test_Dump" --dbinit=" module(sql_server);" ; echo ; echo
Over..
# 17:36:22 >
# builtin opt gdk_arch = 64bitx86_64-redhat-linux-gnu
# builtin opt gdk_version = 1.16.1
# builtin opt monet_pid = 21800
# builtin opt prefix = /ufs/sjoerd
# 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_vm_minsize = 137438953472
# builtin opt gdk_alloc_map = yes
# builtin opt gdk_mem_pagebits = 14
# 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/sql_logs
# builtin opt xquery_logdir = ${prefix}/var/MonetDB/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
# config opt config = ${prefix}/etc/MonetDB.conf
# config opt prefix = /ufs/sjoerd
# config opt exec_prefix = ${prefix}
# config opt gdk_dbfarm = ${prefix}/var/MonetDB4/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_admin = adm
# config opt monet_prompt = MonetDB>
# config opt monet_welcome = yes
# config opt monet_mod_path =
${prefix}/lib64/MonetDB4:${prefix}/lib64/MonetDB4/lib:${prefix}/lib64/MonetDB4/bin
# config opt monet_daemon = no
# config opt mapi_port = 50000
# config opt mapi_open = false
# config opt mapi_debug = 0
# config opt sql_debug = 0
# config opt sql_logdir = ${prefix}/var/MonetDB4/sql_logs
# config opt xquery_output = dm
# config opt xquery_cacheMB = 100
# config opt xquery_cacherules =
# config opt xquery_procMB = 128
# config opt xquery_logdir = ${prefix}/var/MonetDB4/xquery_logs
# config opt xrpc_port =
# config opt xrpc_open = yes
# config opt xrpc_admin = 127.0.0.1
# config opt xrpc_trusted =
http://monetdb.cwi.nl;${prefix}/share/MonetDB/www/export
# config opt standoff_ns =
# config opt standoff_start = start
# config opt standoff_end = end
# cmdline opt config = /ufs/sjoerd/etc/MonetDB.conf
# cmdline opt gdk_debug = 10
# cmdline opt monet_mod_path =
/ufs/sjoerd/src/MonetDB/stable/sql/Linux/src/backends/monet4/.libs:/ufs/sjoerd/src/MonetDB/stable/sql/Linux/src/backends/monet4:/ufs/sjoerd/src/MonetDB/stable/sql/src/backends/monet4:/ufs/sjoerd/lib64/MonetDB4:/ufs/sjoerd/lib64/MonetDB4/lib:/ufs/sjoerd/lib64/MonetDB4/bin
# cmdline opt gdk_dbfarm = /ufs/sjoerd/src/MonetDB/stable/sql/Linux/dbfarm
# cmdline opt sql_logdir = /ufs/sjoerd/src/MonetDB/stable/sql/Linux/sql_logs
# cmdline opt xquery_logdir =
/ufs/sjoerd/src/MonetDB/stable/sql/Linux/xquery_logs
# cmdline opt mapi_port = 32825
# cmdline opt xrpc_port = 48908
# cmdline opt monet_prompt =
# cmdline opt gdk_dbname = mTests_src_test_Dump
# 17:36:22 >
# 17:36:22 > Mtimeout -timeout 60 /ufs/sjoerd/bin/x86_64/python reload.SQL.py
reload
# 17:36:22 >
# 17:36:22 >
# 17:36:22 > Done.
# 17:36:22 >
--- NEW FILE: reload.SQL.py ---
import os
TSTTRGDIR = os.environ['TSTTRGDIR']
SQLCLIENT = os.environ['SQLCLIENT']
MAPIPORT = os.environ['MAPIPORT']
f = open(os.path.join(TSTTRGDIR, 'dumpoutput.sql'), 'r')
p = os.popen('%s -p %s' % (SQLCLIENT, MAPIPORT), 'w')
p.write(f.read())
p.close()
f.close()
--- NEW FILE: test.stable.out ---
stdout of test 'test` in directory 'src/test/Dump` itself:
# 17:36:22 >
# 17:36:22 > Mtimeout -timeout 180 Mserver
"--config=/ufs/sjoerd/etc/MonetDB.conf" --debug=10 --set
"monet_mod_path=/ufs/sjoerd/src/MonetDB/stable/sql/Linux/src/backends/monet4/.libs:/ufs/sjoerd/src/MonetDB/stable/sql/Linux/src/backends/monet4:/ufs/sjoerd/src/MonetDB/stable/sql/src/backends/monet4:/ufs/sjoerd/lib64/MonetDB4:/ufs/sjoerd/lib64/MonetDB4/lib:/ufs/sjoerd/lib64/MonetDB4/bin"
--set "gdk_dbfarm=/ufs/sjoerd/src/MonetDB/stable/sql/Linux/dbfarm" --set
"sql_logdir=/ufs/sjoerd/src/MonetDB/stable/sql/Linux/sql_logs" --set
"xquery_logdir=/ufs/sjoerd/src/MonetDB/stable/sql/Linux/xquery_logs" --set
mapi_port=32825 --set xrpc_port=48908 --set monet_prompt= --trace
"--dbname=mTests_src_test_Dump" --dbinit=" module(sql_server);" ; echo ; echo
Over..
# 17:36:22 >
# Monet Database Server V4.16.1
# Copyright (c) 1993-2007, CWI. All rights reserved.
# Compiled for x86_64-redhat-linux-gnu/64bit with 64bit OIDs; dynamically
linked.
# Visit http://monetdb.cwi.nl/ for further information.
printf("\nReady.\n");
Ready.
quit();
Over..
# 17:36:22 >
# 17:36:22 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=32825 < test.sql
# 17:36:22 >
[ 1 ]
[ 1 ]
% sys.test, sys.test # table_name
% id, i # name
% int, smallint # type
% 1, 2 # length
[ 0, 7 ]
[ 1, 10 ]
[ 2, 5 ]
[ 3, 8 ]
[ 4, 5 ]
[ 5, 8 ]
[ 6, 5 ]
# 17:36:22 >
# 17:36:22 > Done.
# 17:36:22 >
--- NEW FILE: clean.stable.err ---
stderr of test 'clean` in directory 'src/test/Dump` itself:
# 17:36:21 >
# 17:36:21 > Mtimeout -timeout 180 Mserver
"--config=/ufs/sjoerd/etc/MonetDB.conf" --debug=10 --set
"monet_mod_path=/ufs/sjoerd/src/MonetDB/stable/sql/Linux/src/backends/monet4/.libs:/ufs/sjoerd/src/MonetDB/stable/sql/Linux/src/backends/monet4:/ufs/sjoerd/src/MonetDB/stable/sql/src/backends/monet4:/ufs/sjoerd/lib64/MonetDB4:/ufs/sjoerd/lib64/MonetDB4/lib:/ufs/sjoerd/lib64/MonetDB4/bin"
--set "gdk_dbfarm=/ufs/sjoerd/src/MonetDB/stable/sql/Linux/dbfarm" --set
"sql_logdir=/ufs/sjoerd/src/MonetDB/stable/sql/Linux/sql_logs" --set
"xquery_logdir=/ufs/sjoerd/src/MonetDB/stable/sql/Linux/xquery_logs" --set
mapi_port=32825 --set xrpc_port=48908 --set monet_prompt= --trace
"--dbname=mTests_src_test_Dump" --dbinit=" module(sql_server);" ; echo ; echo
Over..
# 17:36:21 >
# builtin opt gdk_arch = 64bitx86_64-redhat-linux-gnu
# builtin opt gdk_version = 1.16.1
# builtin opt monet_pid = 21783
# builtin opt prefix = /ufs/sjoerd
# 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_vm_minsize = 137438953472
# builtin opt gdk_alloc_map = yes
# builtin opt gdk_mem_pagebits = 14
# 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/sql_logs
# builtin opt xquery_logdir = ${prefix}/var/MonetDB/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
# config opt config = ${prefix}/etc/MonetDB.conf
# config opt prefix = /ufs/sjoerd
# config opt exec_prefix = ${prefix}
# config opt gdk_dbfarm = ${prefix}/var/MonetDB4/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_admin = adm
# config opt monet_prompt = MonetDB>
# config opt monet_welcome = yes
# config opt monet_mod_path =
${prefix}/lib64/MonetDB4:${prefix}/lib64/MonetDB4/lib:${prefix}/lib64/MonetDB4/bin
# config opt monet_daemon = no
# config opt mapi_port = 50000
# config opt mapi_open = false
# config opt mapi_debug = 0
# config opt sql_debug = 0
# config opt sql_logdir = ${prefix}/var/MonetDB4/sql_logs
# config opt xquery_output = dm
# config opt xquery_cacheMB = 100
# config opt xquery_cacherules =
# config opt xquery_procMB = 128
# config opt xquery_logdir = ${prefix}/var/MonetDB4/xquery_logs
# config opt xrpc_port =
# config opt xrpc_open = yes
# config opt xrpc_admin = 127.0.0.1
# config opt xrpc_trusted =
http://monetdb.cwi.nl;${prefix}/share/MonetDB/www/export
# config opt standoff_ns =
# config opt standoff_start = start
# config opt standoff_end = end
# cmdline opt config = /ufs/sjoerd/etc/MonetDB.conf
# cmdline opt gdk_debug = 10
# cmdline opt monet_mod_path =
/ufs/sjoerd/src/MonetDB/stable/sql/Linux/src/backends/monet4/.libs:/ufs/sjoerd/src/MonetDB/stable/sql/Linux/src/backends/monet4:/ufs/sjoerd/src/MonetDB/stable/sql/src/backends/monet4:/ufs/sjoerd/lib64/MonetDB4:/ufs/sjoerd/lib64/MonetDB4/lib:/ufs/sjoerd/lib64/MonetDB4/bin
# cmdline opt gdk_dbfarm = /ufs/sjoerd/src/MonetDB/stable/sql/Linux/dbfarm
# cmdline opt sql_logdir = /ufs/sjoerd/src/MonetDB/stable/sql/Linux/sql_logs
# cmdline opt xquery_logdir =
/ufs/sjoerd/src/MonetDB/stable/sql/Linux/xquery_logs
# cmdline opt mapi_port = 32825
# cmdline opt xrpc_port = 48908
# cmdline opt monet_prompt =
# cmdline opt gdk_dbname = mTests_src_test_Dump
# 17:36:21 >
# 17:36:21 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=32825 < clean.sql
# 17:36:21 >
# 17:36:21 >
# 17:36:21 > Done.
# 17:36:21 >
--- NEW FILE: load.sql ---
create sequence "test_seq" as smallint start with 7 increment by 3 minvalue 5
maxvalue 10 cycle;
create table "test" (
id integer,
i smallint default next value for test_seq);
insert into test (id) values (0);
insert into test (id) values (1);
insert into test (id) values (2);
insert into test (id) values (3);
insert into test (id) values (4);
select * from test;
--- NEW FILE: dump.SQL.py ---
import os
TSTTRGDIR = os.environ['TSTTRGDIR']
SQLDUMP = os.environ['SQLDUMP']
MAPIPORT = os.environ['MAPIPORT']
f = open(os.path.join(TSTTRGDIR, 'dumpoutput.sql'), 'w')
p = os.popen('%s -p %s' % (SQLDUMP, MAPIPORT), 'r')
f.write(p.read())
p.close()
f.close()
--- NEW FILE: load.stable.out ---
stdout of test 'load` in directory 'src/test/Dump` itself:
# 17:36:20 >
# 17:36:20 > Mtimeout -timeout 180 Mserver
"--config=/ufs/sjoerd/etc/MonetDB.conf" --debug=10 --set
"monet_mod_path=/ufs/sjoerd/src/MonetDB/stable/sql/Linux/src/backends/monet4/.libs:/ufs/sjoerd/src/MonetDB/stable/sql/Linux/src/backends/monet4:/ufs/sjoerd/src/MonetDB/stable/sql/src/backends/monet4:/ufs/sjoerd/lib64/MonetDB4:/ufs/sjoerd/lib64/MonetDB4/lib:/ufs/sjoerd/lib64/MonetDB4/bin"
--set "gdk_dbfarm=/ufs/sjoerd/src/MonetDB/stable/sql/Linux/dbfarm" --set
"sql_logdir=/ufs/sjoerd/src/MonetDB/stable/sql/Linux/sql_logs" --set
"xquery_logdir=/ufs/sjoerd/src/MonetDB/stable/sql/Linux/xquery_logs" --set
mapi_port=32825 --set xrpc_port=48908 --set monet_prompt= --trace
"--dbname=mTests_src_test_Dump" --dbinit=" module(sql_server);" ; echo ; echo
Over..
# 17:36:20 >
# Monet Database Server V4.16.1
# Copyright (c) 1993-2007, CWI. All rights reserved.
# Compiled for x86_64-redhat-linux-gnu/64bit with 64bit OIDs; dynamically
linked.
# Visit http://monetdb.cwi.nl/ for further information.
printf("\nReady.\n");
Ready.
quit();
Over..
# 17:36:20 >
# 17:36:20 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=32825 < load.sql
# 17:36:20 >
[ 1 ]
[ 1 ]
[ 1 ]
[ 1 ]
[ 1 ]
% sys.test, sys.test # table_name
% id, i # name
% int, smallint # type
% 1, 2 # length
[ 0, 7 ]
[ 1, 10 ]
[ 2, 5 ]
[ 3, 8 ]
[ 4, 5 ]
# 17:36:20 >
# 17:36:20 > Done.
# 17:36:20 >
--- NEW FILE: load.stable.err ---
stderr of test 'load` in directory 'src/test/Dump` itself:
# 17:36:20 >
# 17:36:20 > Mtimeout -timeout 180 Mserver
"--config=/ufs/sjoerd/etc/MonetDB.conf" --debug=10 --set
"monet_mod_path=/ufs/sjoerd/src/MonetDB/stable/sql/Linux/src/backends/monet4/.libs:/ufs/sjoerd/src/MonetDB/stable/sql/Linux/src/backends/monet4:/ufs/sjoerd/src/MonetDB/stable/sql/src/backends/monet4:/ufs/sjoerd/lib64/MonetDB4:/ufs/sjoerd/lib64/MonetDB4/lib:/ufs/sjoerd/lib64/MonetDB4/bin"
--set "gdk_dbfarm=/ufs/sjoerd/src/MonetDB/stable/sql/Linux/dbfarm" --set
"sql_logdir=/ufs/sjoerd/src/MonetDB/stable/sql/Linux/sql_logs" --set
"xquery_logdir=/ufs/sjoerd/src/MonetDB/stable/sql/Linux/xquery_logs" --set
mapi_port=32825 --set xrpc_port=48908 --set monet_prompt= --trace
"--dbname=mTests_src_test_Dump" --dbinit=" module(sql_server);" ; echo ; echo
Over..
# 17:36:20 >
# builtin opt gdk_arch = 64bitx86_64-redhat-linux-gnu
# builtin opt gdk_version = 1.16.1
# builtin opt monet_pid = 21748
# builtin opt prefix = /ufs/sjoerd
# 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_vm_minsize = 137438953472
# builtin opt gdk_alloc_map = yes
# builtin opt gdk_mem_pagebits = 14
# 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/sql_logs
# builtin opt xquery_logdir = ${prefix}/var/MonetDB/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
# config opt config = ${prefix}/etc/MonetDB.conf
# config opt prefix = /ufs/sjoerd
# config opt exec_prefix = ${prefix}
# config opt gdk_dbfarm = ${prefix}/var/MonetDB4/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_admin = adm
# config opt monet_prompt = MonetDB>
# config opt monet_welcome = yes
# config opt monet_mod_path =
${prefix}/lib64/MonetDB4:${prefix}/lib64/MonetDB4/lib:${prefix}/lib64/MonetDB4/bin
# config opt monet_daemon = no
# config opt mapi_port = 50000
# config opt mapi_open = false
# config opt mapi_debug = 0
# config opt sql_debug = 0
# config opt sql_logdir = ${prefix}/var/MonetDB4/sql_logs
# config opt xquery_output = dm
# config opt xquery_cacheMB = 100
# config opt xquery_cacherules =
# config opt xquery_procMB = 128
# config opt xquery_logdir = ${prefix}/var/MonetDB4/xquery_logs
# config opt xrpc_port =
# config opt xrpc_open = yes
# config opt xrpc_admin = 127.0.0.1
# config opt xrpc_trusted =
http://monetdb.cwi.nl;${prefix}/share/MonetDB/www/export
# config opt standoff_ns =
# config opt standoff_start = start
# config opt standoff_end = end
# cmdline opt config = /ufs/sjoerd/etc/MonetDB.conf
# cmdline opt gdk_debug = 10
# cmdline opt monet_mod_path =
/ufs/sjoerd/src/MonetDB/stable/sql/Linux/src/backends/monet4/.libs:/ufs/sjoerd/src/MonetDB/stable/sql/Linux/src/backends/monet4:/ufs/sjoerd/src/MonetDB/stable/sql/src/backends/monet4:/ufs/sjoerd/lib64/MonetDB4:/ufs/sjoerd/lib64/MonetDB4/lib:/ufs/sjoerd/lib64/MonetDB4/bin
# cmdline opt gdk_dbfarm = /ufs/sjoerd/src/MonetDB/stable/sql/Linux/dbfarm
# cmdline opt sql_logdir = /ufs/sjoerd/src/MonetDB/stable/sql/Linux/sql_logs
# cmdline opt xquery_logdir =
/ufs/sjoerd/src/MonetDB/stable/sql/Linux/xquery_logs
# cmdline opt mapi_port = 32825
# cmdline opt xrpc_port = 48908
# cmdline opt monet_prompt =
# cmdline opt gdk_dbname = mTests_src_test_Dump
# 17:36:20 >
# 17:36:20 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=32825 < load.sql
# 17:36:20 >
# 17:36:20 >
# 17:36:20 > Done.
# 17:36:20 >
--- NEW FILE: dump.stable.out ---
stdout of test 'dump` in directory 'src/test/Dump` itself:
# 17:36:21 >
# 17:36:21 > Mtimeout -timeout 180 Mserver
"--config=/ufs/sjoerd/etc/MonetDB.conf" --debug=10 --set
"monet_mod_path=/ufs/sjoerd/src/MonetDB/stable/sql/Linux/src/backends/monet4/.libs:/ufs/sjoerd/src/MonetDB/stable/sql/Linux/src/backends/monet4:/ufs/sjoerd/src/MonetDB/stable/sql/src/backends/monet4:/ufs/sjoerd/lib64/MonetDB4:/ufs/sjoerd/lib64/MonetDB4/lib:/ufs/sjoerd/lib64/MonetDB4/bin"
--set "gdk_dbfarm=/ufs/sjoerd/src/MonetDB/stable/sql/Linux/dbfarm" --set
"sql_logdir=/ufs/sjoerd/src/MonetDB/stable/sql/Linux/sql_logs" --set
"xquery_logdir=/ufs/sjoerd/src/MonetDB/stable/sql/Linux/xquery_logs" --set
mapi_port=32825 --set xrpc_port=48908 --set monet_prompt= --trace
"--dbname=mTests_src_test_Dump" --dbinit=" module(sql_server);" ; echo ; echo
Over..
# 17:36:21 >
# Monet Database Server V4.16.1
# Copyright (c) 1993-2007, CWI. All rights reserved.
# Compiled for x86_64-redhat-linux-gnu/64bit with 64bit OIDs; dynamically
linked.
# Visit http://monetdb.cwi.nl/ for further information.
printf("\nReady.\n");
Ready.
quit();
Over..
# 17:36:21 >
# 17:36:21 > Mtimeout -timeout 60 /ufs/sjoerd/bin/x86_64/python dump.SQL.py
dump
# 17:36:21 >
# 17:36:21 >
# 17:36:21 > Done.
# 17:36:21 >
--- NEW FILE: test.sql ---
insert into test (id) values (5);
insert into test (id) values (6);
select * from test;
--- NEW FILE: dump.stable.err ---
stderr of test 'dump` in directory 'src/test/Dump` itself:
# 17:36:21 >
# 17:36:21 > Mtimeout -timeout 180 Mserver
"--config=/ufs/sjoerd/etc/MonetDB.conf" --debug=10 --set
"monet_mod_path=/ufs/sjoerd/src/MonetDB/stable/sql/Linux/src/backends/monet4/.libs:/ufs/sjoerd/src/MonetDB/stable/sql/Linux/src/backends/monet4:/ufs/sjoerd/src/MonetDB/stable/sql/src/backends/monet4:/ufs/sjoerd/lib64/MonetDB4:/ufs/sjoerd/lib64/MonetDB4/lib:/ufs/sjoerd/lib64/MonetDB4/bin"
--set "gdk_dbfarm=/ufs/sjoerd/src/MonetDB/stable/sql/Linux/dbfarm" --set
"sql_logdir=/ufs/sjoerd/src/MonetDB/stable/sql/Linux/sql_logs" --set
"xquery_logdir=/ufs/sjoerd/src/MonetDB/stable/sql/Linux/xquery_logs" --set
mapi_port=32825 --set xrpc_port=48908 --set monet_prompt= --trace
"--dbname=mTests_src_test_Dump" --dbinit=" module(sql_server);" ; echo ; echo
Over..
# 17:36:21 >
# builtin opt gdk_arch = 64bitx86_64-redhat-linux-gnu
# builtin opt gdk_version = 1.16.1
# builtin opt monet_pid = 21765
# builtin opt prefix = /ufs/sjoerd
# 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_vm_minsize = 137438953472
# builtin opt gdk_alloc_map = yes
# builtin opt gdk_mem_pagebits = 14
# 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/sql_logs
# builtin opt xquery_logdir = ${prefix}/var/MonetDB/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
# config opt config = ${prefix}/etc/MonetDB.conf
# config opt prefix = /ufs/sjoerd
# config opt exec_prefix = ${prefix}
# config opt gdk_dbfarm = ${prefix}/var/MonetDB4/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_admin = adm
# config opt monet_prompt = MonetDB>
# config opt monet_welcome = yes
# config opt monet_mod_path =
${prefix}/lib64/MonetDB4:${prefix}/lib64/MonetDB4/lib:${prefix}/lib64/MonetDB4/bin
# config opt monet_daemon = no
# config opt mapi_port = 50000
# config opt mapi_open = false
# config opt mapi_debug = 0
# config opt sql_debug = 0
# config opt sql_logdir = ${prefix}/var/MonetDB4/sql_logs
# config opt xquery_output = dm
# config opt xquery_cacheMB = 100
# config opt xquery_cacherules =
# config opt xquery_procMB = 128
# config opt xquery_logdir = ${prefix}/var/MonetDB4/xquery_logs
# config opt xrpc_port =
# config opt xrpc_open = yes
# config opt xrpc_admin = 127.0.0.1
# config opt xrpc_trusted =
http://monetdb.cwi.nl;${prefix}/share/MonetDB/www/export
# config opt standoff_ns =
# config opt standoff_start = start
# config opt standoff_end = end
# cmdline opt config = /ufs/sjoerd/etc/MonetDB.conf
# cmdline opt gdk_debug = 10
# cmdline opt monet_mod_path =
/ufs/sjoerd/src/MonetDB/stable/sql/Linux/src/backends/monet4/.libs:/ufs/sjoerd/src/MonetDB/stable/sql/Linux/src/backends/monet4:/ufs/sjoerd/src/MonetDB/stable/sql/src/backends/monet4:/ufs/sjoerd/lib64/MonetDB4:/ufs/sjoerd/lib64/MonetDB4/lib:/ufs/sjoerd/lib64/MonetDB4/bin
# cmdline opt gdk_dbfarm = /ufs/sjoerd/src/MonetDB/stable/sql/Linux/dbfarm
# cmdline opt sql_logdir = /ufs/sjoerd/src/MonetDB/stable/sql/Linux/sql_logs
# cmdline opt xquery_logdir =
/ufs/sjoerd/src/MonetDB/stable/sql/Linux/xquery_logs
# cmdline opt mapi_port = 32825
# cmdline opt xrpc_port = 48908
# cmdline opt monet_prompt =
# cmdline opt gdk_dbname = mTests_src_test_Dump
# 17:36:21 >
# 17:36:21 > Mtimeout -timeout 60 /ufs/sjoerd/bin/x86_64/python dump.SQL.py
dump
# 17:36:21 >
# 17:36:21 >
# 17:36:21 > Done.
# 17:36:21 >
--- NEW FILE: clean.stable.out ---
stdout of test 'clean` in directory 'src/test/Dump` itself:
# 17:36:21 >
# 17:36:21 > Mtimeout -timeout 180 Mserver
"--config=/ufs/sjoerd/etc/MonetDB.conf" --debug=10 --set
"monet_mod_path=/ufs/sjoerd/src/MonetDB/stable/sql/Linux/src/backends/monet4/.libs:/ufs/sjoerd/src/MonetDB/stable/sql/Linux/src/backends/monet4:/ufs/sjoerd/src/MonetDB/stable/sql/src/backends/monet4:/ufs/sjoerd/lib64/MonetDB4:/ufs/sjoerd/lib64/MonetDB4/lib:/ufs/sjoerd/lib64/MonetDB4/bin"
--set "gdk_dbfarm=/ufs/sjoerd/src/MonetDB/stable/sql/Linux/dbfarm" --set
"sql_logdir=/ufs/sjoerd/src/MonetDB/stable/sql/Linux/sql_logs" --set
"xquery_logdir=/ufs/sjoerd/src/MonetDB/stable/sql/Linux/xquery_logs" --set
mapi_port=32825 --set xrpc_port=48908 --set monet_prompt= --trace
"--dbname=mTests_src_test_Dump" --dbinit=" module(sql_server);" ; echo ; echo
Over..
# 17:36:21 >
# Monet Database Server V4.16.1
# Copyright (c) 1993-2007, CWI. All rights reserved.
# Compiled for x86_64-redhat-linux-gnu/64bit with 64bit OIDs; dynamically
linked.
# Visit http://monetdb.cwi.nl/ for further information.
printf("\nReady.\n");
Ready.
quit();
Over..
# 17:36:21 >
# 17:36:21 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=32825 < clean.sql
# 17:36:21 >
# 17:36:21 >
# 17:36:21 > Done.
# 17:36:21 >
--- NEW FILE: test.stable.err ---
stderr of test 'test` in directory 'src/test/Dump` itself:
# 17:36:22 >
# 17:36:22 > Mtimeout -timeout 180 Mserver
"--config=/ufs/sjoerd/etc/MonetDB.conf" --debug=10 --set
"monet_mod_path=/ufs/sjoerd/src/MonetDB/stable/sql/Linux/src/backends/monet4/.libs:/ufs/sjoerd/src/MonetDB/stable/sql/Linux/src/backends/monet4:/ufs/sjoerd/src/MonetDB/stable/sql/src/backends/monet4:/ufs/sjoerd/lib64/MonetDB4:/ufs/sjoerd/lib64/MonetDB4/lib:/ufs/sjoerd/lib64/MonetDB4/bin"
--set "gdk_dbfarm=/ufs/sjoerd/src/MonetDB/stable/sql/Linux/dbfarm" --set
"sql_logdir=/ufs/sjoerd/src/MonetDB/stable/sql/Linux/sql_logs" --set
"xquery_logdir=/ufs/sjoerd/src/MonetDB/stable/sql/Linux/xquery_logs" --set
mapi_port=32825 --set xrpc_port=48908 --set monet_prompt= --trace
"--dbname=mTests_src_test_Dump" --dbinit=" module(sql_server);" ; echo ; echo
Over..
# 17:36:22 >
# builtin opt gdk_arch = 64bitx86_64-redhat-linux-gnu
# builtin opt gdk_version = 1.16.1
# builtin opt monet_pid = 21818
# builtin opt prefix = /ufs/sjoerd
# 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_vm_minsize = 137438953472
# builtin opt gdk_alloc_map = yes
# builtin opt gdk_mem_pagebits = 14
# 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/sql_logs
# builtin opt xquery_logdir = ${prefix}/var/MonetDB/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
# config opt config = ${prefix}/etc/MonetDB.conf
# config opt prefix = /ufs/sjoerd
# config opt exec_prefix = ${prefix}
# config opt gdk_dbfarm = ${prefix}/var/MonetDB4/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_admin = adm
# config opt monet_prompt = MonetDB>
# config opt monet_welcome = yes
# config opt monet_mod_path =
${prefix}/lib64/MonetDB4:${prefix}/lib64/MonetDB4/lib:${prefix}/lib64/MonetDB4/bin
# config opt monet_daemon = no
# config opt mapi_port = 50000
# config opt mapi_open = false
# config opt mapi_debug = 0
# config opt sql_debug = 0
# config opt sql_logdir = ${prefix}/var/MonetDB4/sql_logs
# config opt xquery_output = dm
# config opt xquery_cacheMB = 100
# config opt xquery_cacherules =
# config opt xquery_procMB = 128
# config opt xquery_logdir = ${prefix}/var/MonetDB4/xquery_logs
# config opt xrpc_port =
# config opt xrpc_open = yes
# config opt xrpc_admin = 127.0.0.1
# config opt xrpc_trusted =
http://monetdb.cwi.nl;${prefix}/share/MonetDB/www/export
# config opt standoff_ns =
# config opt standoff_start = start
# config opt standoff_end = end
# cmdline opt config = /ufs/sjoerd/etc/MonetDB.conf
# cmdline opt gdk_debug = 10
# cmdline opt monet_mod_path =
/ufs/sjoerd/src/MonetDB/stable/sql/Linux/src/backends/monet4/.libs:/ufs/sjoerd/src/MonetDB/stable/sql/Linux/src/backends/monet4:/ufs/sjoerd/src/MonetDB/stable/sql/src/backends/monet4:/ufs/sjoerd/lib64/MonetDB4:/ufs/sjoerd/lib64/MonetDB4/lib:/ufs/sjoerd/lib64/MonetDB4/bin
# cmdline opt gdk_dbfarm = /ufs/sjoerd/src/MonetDB/stable/sql/Linux/dbfarm
# cmdline opt sql_logdir = /ufs/sjoerd/src/MonetDB/stable/sql/Linux/sql_logs
# cmdline opt xquery_logdir =
/ufs/sjoerd/src/MonetDB/stable/sql/Linux/xquery_logs
# cmdline opt mapi_port = 32825
# cmdline opt xrpc_port = 48908
# cmdline opt monet_prompt =
# cmdline opt gdk_dbname = mTests_src_test_Dump
# 17:36:22 >
# 17:36:22 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=32825 < test.sql
# 17:36:22 >
# 17:36:22 >
# 17:36:22 > Done.
# 17:36:22 >
--- NEW FILE: clean.sql ---
drop table "test";
drop sequence "test_seq";
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
