Update of /cvsroot/monetdb/sql/src/test/Update_Delete_action/Tests
In directory sc8-pr-cvs16:/tmp/cvs-serv15090
Modified Files:
delete_cascade.sql delete_no_action.sql
delete_no_action.stable.err update_cascade.sql
Added Files:
delete_set_default.stable.err delete_set_null.stable.err
update_delete_set_null.stable.err
update_set_default.stable.err update_set_null.stable.err
Log Message:
New approves of err outputs..
Index: delete_no_action.sql
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/Update_Delete_action/Tests/delete_no_action.sql,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- delete_no_action.sql 2 Apr 2007 13:08:05 -0000 1.2
+++ delete_no_action.sql 18 Apr 2007 09:18:03 -0000 1.3
@@ -41,4 +41,3 @@
drop table t3;
drop table t2;
drop table t1;
-
Index: delete_no_action.stable.err
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/Update_Delete_action/Tests/delete_no_action.stable.err,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -d -r1.1 -r1.2
--- delete_no_action.stable.err 2 Apr 2007 13:08:06 -0000 1.1
+++ delete_no_action.stable.err 18 Apr 2007 09:18:04 -0000 1.2
@@ -1,13 +1,13 @@
stderr of test 'delete_no_action` in directory 'src/test/Update_Delete_action`
itself:
-# 16:04:23 >
-# 16:04:23 > Mtimeout -timeout 180 mserver5
"--config=/ufs/goncalve/scratch/MonetDB/MonetDB5/etc/monetdb5.conf" --debug=10
--set
"monet_mod_path=/ufs/goncalve/scratch/MonetDB/MonetDB5/lib/MonetDB5:/ufs/goncalve/scratch/MonetDB/MonetDB5/lib/MonetDB5/lib:/ufs/goncalve/scratch/MonetDB/MonetDB5/lib/MonetDB5/bin"
--set "gdk_dbfarm=/ufs/goncalve/scratch/MonetDB/MonetDB5/var/MonetDB5/dbfarm"
--set "sql_logdir=/ufs/goncalve/scratch/MonetDB/MonetDB5/var/MonetDB5/sql_logs"
--set
"xquery_logdir=/ufs/goncalve/scratch/MonetDB/MonetDB5/var/MonetDB5/xquery_logs"
--set mapi_port=31477 --set xrpc_port=42976 --set monet_prompt= --trace
"--dbname=mTests_src_test_Update_Delete_action" --dbinit='include sql;' ; echo
; echo Over..
-# 16:04:23 >
+# 15:35:33 >
+# 15:35:33 > Mtimeout -timeout 180 Mserver
"--config=/ufs/goncalve/scratch/MonetDB/MonetDB4/etc/MonetDB.conf" --debug=10
--set
"monet_mod_path=/ufs/goncalve/scratch/MonetDB/MonetDB4/lib/MonetDB4:/ufs/goncalve/scratch/MonetDB/MonetDB4/lib/MonetDB4/lib:/ufs/goncalve/scratch/MonetDB/MonetDB4/lib/MonetDB4/bin"
--set "gdk_dbfarm=/ufs/goncalve/scratch/MonetDB/MonetDB4/var/MonetDB4/dbfarm"
--set "sql_logdir=/ufs/goncalve/scratch/MonetDB/MonetDB4/var/MonetDB4/sql_logs"
--set
"xquery_logdir=/ufs/goncalve/scratch/MonetDB/MonetDB4/var/MonetDB4/xquery_logs"
--set mapi_port=37767 --set xrpc_port=48239 --set monet_prompt= --trace
"--dbname=mTests_src_test_Update_Delete_action" --dbinit=" module(sql_server);"
; echo ; echo Over..
+# 15:35:33 >
# builtin opt gdk_arch = 64bitx86_64-redhat-linux-gnu
# builtin opt gdk_version = 1.17.1
-# builtin opt monet_pid = 29132
+# builtin opt monet_pid = 3855
# builtin opt prefix = /ufs/goncalve/scratch/MonetDB/MonetDB
# builtin opt exec_prefix = ${prefix}
# builtin opt gdk_dbname = tst
@@ -33,48 +33,57 @@
# builtin opt standoff_ns = http://monetdb.cwi.nl/standoff
# builtin opt standoff_start = start
# builtin opt standoff_end = end
-# config opt prefix = /ufs/goncalve/scratch/MonetDB/MonetDB5
-# config opt config = ${prefix}/etc/monetdb5.conf
-# config opt prefix = /ufs/goncalve/scratch/MonetDB/MonetDB5
+# config opt prefix = /ufs/goncalve/scratch/MonetDB/MonetDB4
+# config opt config = ${prefix}/etc/MonetDB.conf
+# config opt prefix = /ufs/goncalve/scratch/MonetDB/MonetDB4
# config opt exec_prefix = ${prefix}
-# config opt gdk_dbfarm = ${prefix}/var/MonetDB5/dbfarm
+# config opt datadir = ${prefix}/share
+# 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_mod_path =
${exec_prefix}/lib/MonetDB5:${exec_prefix}/lib/MonetDB5/lib:${exec_prefix}/lib/MonetDB5/bin
-# config opt monet_daemon = no
+# config opt monet_admin = adm
+# config opt monet_prompt = MonetDB>
# config opt monet_welcome = yes
-# config opt delay = 120
-# config opt mal_init = ${exec_prefix}/lib/MonetDB5/mal_init.mal
-# config opt mal_listing = 15
-# config opt checkpoint_dir = ${prefix}/var/MonetDB5/chkpnt
-# config opt mapi_port = 0
+# config opt monet_mod_path =
${exec_prefix}/lib/MonetDB4:${exec_prefix}/lib/MonetDB4/lib:${exec_prefix}/lib/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/MonetDB5/sql_logs
-# config opt pf_httpd_port = 8080
+# config opt sql_logdir = ${prefix}/var/MonetDB4/sql_logs
# config opt xquery_output = dm
# config opt xquery_cacheMB = 100
-# config opt xquery_logdir = ${prefix}/var/MonetDB5/xquery_logs
-# cmdline opt config =
/ufs/goncalve/scratch/MonetDB/MonetDB5/etc/monetdb5.conf
+# 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 = true
+# config opt xrpc_options =
+# config opt xrpc_admin = 127.0.0.1
+# config opt xrpc_user = 127.0.0.1
+# config opt xrpc_trusted =
http://monetdb.cwi.nl;${prefix}/share/MonetDB/xrpc/export
+# config opt standoff_ns =
+# config opt standoff_start = start
+# config opt standoff_end = end
+# cmdline opt config = /ufs/goncalve/scratch/MonetDB/MonetDB4/etc/MonetDB.conf
# cmdline opt gdk_debug = 10
-# cmdline opt monet_mod_path =
/ufs/goncalve/scratch/MonetDB/MonetDB5/lib/MonetDB5:/ufs/goncalve/scratch/MonetDB/MonetDB5/lib/MonetDB5/lib:/ufs/goncalve/scratch/MonetDB/MonetDB5/lib/MonetDB5/bin
-# cmdline opt gdk_dbfarm =
/ufs/goncalve/scratch/MonetDB/MonetDB5/var/MonetDB5/dbfarm
-# cmdline opt sql_logdir =
/ufs/goncalve/scratch/MonetDB/MonetDB5/var/MonetDB5/sql_logs
-# cmdline opt xquery_logdir =
/ufs/goncalve/scratch/MonetDB/MonetDB5/var/MonetDB5/xquery_logs
-# cmdline opt mapi_port = 31477
-# cmdline opt xrpc_port = 42976
+# cmdline opt monet_mod_path =
/ufs/goncalve/scratch/MonetDB/MonetDB4/lib/MonetDB4:/ufs/goncalve/scratch/MonetDB/MonetDB4/lib/MonetDB4/lib:/ufs/goncalve/scratch/MonetDB/MonetDB4/lib/MonetDB4/bin
+# cmdline opt gdk_dbfarm =
/ufs/goncalve/scratch/MonetDB/MonetDB4/var/MonetDB4/dbfarm
+# cmdline opt sql_logdir =
/ufs/goncalve/scratch/MonetDB/MonetDB4/var/MonetDB4/sql_logs
+# cmdline opt xquery_logdir =
/ufs/goncalve/scratch/MonetDB/MonetDB4/var/MonetDB4/xquery_logs
+# cmdline opt mapi_port = 37767
+# cmdline opt xrpc_port = 48239
# cmdline opt monet_prompt =
# cmdline opt gdk_dbname = mTests_src_test_Update_Delete_action
-#warning: please don't forget to set your vault key!
-#(see /ufs/goncalve/scratch/MonetDB/MonetDB5/etc/monetdb5.conf)
-# 16:04:24 >
-# 16:04:24 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=31477
-# 16:04:24 >
+# 15:35:33 >
+# 15:35:33 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=37767
+# 15:35:33 >
-# 16:04:27 >
-# 16:04:27 > Done.
-# 16:04:27 >
+# 15:35:33 >
+# 15:35:33 > Done.
+# 15:35:33 >
Index: delete_cascade.sql
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/Update_Delete_action/Tests/delete_cascade.sql,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- delete_cascade.sql 2 Apr 2007 13:07:59 -0000 1.2
+++ delete_cascade.sql 18 Apr 2007 09:18:03 -0000 1.3
@@ -4,8 +4,6 @@
create table t3 (id int, num int, FOREIGN KEY(id) REFERENCES t2(id) ON DELETE
CASCADE);
-
-
insert into t1 values(1, 'monetdb');
insert into t1 values(2, 'mon');
insert into t1 values(3, 'monb');
@@ -41,4 +39,3 @@
drop table t3;
drop table t2;
drop table t1;
-
--- NEW FILE: update_set_default.stable.err ---
stderr of test 'update_set_default` in directory
'src/test/Update_Delete_action` itself:
# 11:13:36 >
# 11:13:36 > Mtimeout -timeout 180 Mserver
"--config=/ufs/goncalve/scratch/MonetDB/MonetDB4/etc/MonetDB.conf" --debug=10
--set
"monet_mod_path=/ufs/goncalve/scratch/MonetDB/MonetDB4/lib/MonetDB4:/ufs/goncalve/scratch/MonetDB/MonetDB4/lib/MonetDB4/lib:/ufs/goncalve/scratch/MonetDB/MonetDB4/lib/MonetDB4/bin"
--set "gdk_dbfarm=/ufs/goncalve/scratch/MonetDB/MonetDB4/var/MonetDB4/dbfarm"
--set "sql_logdir=/ufs/goncalve/scratch/MonetDB/MonetDB4/var/MonetDB4/sql_logs"
--set
"xquery_logdir=/ufs/goncalve/scratch/MonetDB/MonetDB4/var/MonetDB4/xquery_logs"
--set mapi_port=33372 --set xrpc_port=43851 --set monet_prompt= --trace
"--dbname=mTests_src_test_Update_Delete_action" --dbinit=" module(sql_server);"
; echo ; echo Over..
# 11:13:36 >
# builtin opt gdk_arch = 64bitx86_64-redhat-linux-gnu
# builtin opt gdk_version = 1.17.1
# builtin opt monet_pid = 6635
# builtin opt prefix = /ufs/goncalve/scratch/MonetDB/MonetDB
# 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 =
${exec_prefix}/lib/MonetDB:${exec_prefix}/lib/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/goncalve/scratch/MonetDB/MonetDB4
# config opt config = ${prefix}/etc/MonetDB.conf
# config opt prefix = /ufs/goncalve/scratch/MonetDB/MonetDB4
# config opt exec_prefix = ${prefix}
# config opt datadir = ${prefix}/share
# 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 =
${exec_prefix}/lib/MonetDB4:${exec_prefix}/lib/MonetDB4/lib:${exec_prefix}/lib/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 = true
# config opt xrpc_options =
# config opt xrpc_admin = 127.0.0.1
# config opt xrpc_user = 127.0.0.1
# config opt xrpc_trusted =
http://monetdb.cwi.nl;${prefix}/share/MonetDB/xrpc/export
# config opt standoff_ns =
# config opt standoff_start = start
# config opt standoff_end = end
# cmdline opt config = /ufs/goncalve/scratch/MonetDB/MonetDB4/etc/MonetDB.conf
# cmdline opt gdk_debug = 10
# cmdline opt monet_mod_path =
/ufs/goncalve/scratch/MonetDB/MonetDB4/lib/MonetDB4:/ufs/goncalve/scratch/MonetDB/MonetDB4/lib/MonetDB4/lib:/ufs/goncalve/scratch/MonetDB/MonetDB4/lib/MonetDB4/bin
# cmdline opt gdk_dbfarm =
/ufs/goncalve/scratch/MonetDB/MonetDB4/var/MonetDB4/dbfarm
# cmdline opt sql_logdir =
/ufs/goncalve/scratch/MonetDB/MonetDB4/var/MonetDB4/sql_logs
# cmdline opt xquery_logdir =
/ufs/goncalve/scratch/MonetDB/MonetDB4/var/MonetDB4/xquery_logs
# cmdline opt mapi_port = 33372
# cmdline opt xrpc_port = 43851
# cmdline opt monet_prompt =
# cmdline opt gdk_dbname = mTests_src_test_Update_Delete_action
# 11:13:36 >
# 11:13:36 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=33372
# 11:13:36 >
# 11:13:36 >
# 11:13:36 > Done.
# 11:13:36 >
--- NEW FILE: update_set_null.stable.err ---
stderr of test 'update_set_null` in directory 'src/test/Update_Delete_action`
itself:
# 11:14:02 >
# 11:14:02 > Mtimeout -timeout 180 Mserver
"--config=/ufs/goncalve/scratch/MonetDB/MonetDB4/etc/MonetDB.conf" --debug=10
--set
"monet_mod_path=/ufs/goncalve/scratch/MonetDB/MonetDB4/lib/MonetDB4:/ufs/goncalve/scratch/MonetDB/MonetDB4/lib/MonetDB4/lib:/ufs/goncalve/scratch/MonetDB/MonetDB4/lib/MonetDB4/bin"
--set "gdk_dbfarm=/ufs/goncalve/scratch/MonetDB/MonetDB4/var/MonetDB4/dbfarm"
--set "sql_logdir=/ufs/goncalve/scratch/MonetDB/MonetDB4/var/MonetDB4/sql_logs"
--set
"xquery_logdir=/ufs/goncalve/scratch/MonetDB/MonetDB4/var/MonetDB4/xquery_logs"
--set mapi_port=36748 --set xrpc_port=44176 --set monet_prompt= --trace
"--dbname=mTests_src_test_Update_Delete_action" --dbinit=" module(sql_server);"
; echo ; echo Over..
# 11:14:02 >
# builtin opt gdk_arch = 64bitx86_64-redhat-linux-gnu
# builtin opt gdk_version = 1.17.1
# builtin opt monet_pid = 6679
# builtin opt prefix = /ufs/goncalve/scratch/MonetDB/MonetDB
# 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 =
${exec_prefix}/lib/MonetDB:${exec_prefix}/lib/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/goncalve/scratch/MonetDB/MonetDB4
# config opt config = ${prefix}/etc/MonetDB.conf
# config opt prefix = /ufs/goncalve/scratch/MonetDB/MonetDB4
# config opt exec_prefix = ${prefix}
# config opt datadir = ${prefix}/share
# 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 =
${exec_prefix}/lib/MonetDB4:${exec_prefix}/lib/MonetDB4/lib:${exec_prefix}/lib/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 = true
# config opt xrpc_options =
# config opt xrpc_admin = 127.0.0.1
# config opt xrpc_user = 127.0.0.1
# config opt xrpc_trusted =
http://monetdb.cwi.nl;${prefix}/share/MonetDB/xrpc/export
# config opt standoff_ns =
# config opt standoff_start = start
# config opt standoff_end = end
# cmdline opt config = /ufs/goncalve/scratch/MonetDB/MonetDB4/etc/MonetDB.conf
# cmdline opt gdk_debug = 10
# cmdline opt monet_mod_path =
/ufs/goncalve/scratch/MonetDB/MonetDB4/lib/MonetDB4:/ufs/goncalve/scratch/MonetDB/MonetDB4/lib/MonetDB4/lib:/ufs/goncalve/scratch/MonetDB/MonetDB4/lib/MonetDB4/bin
# cmdline opt gdk_dbfarm =
/ufs/goncalve/scratch/MonetDB/MonetDB4/var/MonetDB4/dbfarm
# cmdline opt sql_logdir =
/ufs/goncalve/scratch/MonetDB/MonetDB4/var/MonetDB4/sql_logs
# cmdline opt xquery_logdir =
/ufs/goncalve/scratch/MonetDB/MonetDB4/var/MonetDB4/xquery_logs
# cmdline opt mapi_port = 36748
# cmdline opt xrpc_port = 44176
# cmdline opt monet_prompt =
# cmdline opt gdk_dbname = mTests_src_test_Update_Delete_action
# 11:14:02 >
# 11:14:02 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=36748
# 11:14:02 >
# 11:14:02 >
# 11:14:02 > Done.
# 11:14:02 >
--- NEW FILE: delete_set_null.stable.err ---
stderr of test 'delete_set_null` in directory 'src/test/Update_Delete_action`
itself:
# 11:11:30 >
# 11:11:30 > Mtimeout -timeout 180 Mserver
"--config=/ufs/goncalve/scratch/MonetDB/MonetDB4/etc/MonetDB.conf" --debug=10
--set
"monet_mod_path=/ufs/goncalve/scratch/MonetDB/MonetDB4/lib/MonetDB4:/ufs/goncalve/scratch/MonetDB/MonetDB4/lib/MonetDB4/lib:/ufs/goncalve/scratch/MonetDB/MonetDB4/lib/MonetDB4/bin"
--set "gdk_dbfarm=/ufs/goncalve/scratch/MonetDB/MonetDB4/var/MonetDB4/dbfarm"
--set "sql_logdir=/ufs/goncalve/scratch/MonetDB/MonetDB4/var/MonetDB4/sql_logs"
--set
"xquery_logdir=/ufs/goncalve/scratch/MonetDB/MonetDB4/var/MonetDB4/xquery_logs"
--set mapi_port=36107 --set xrpc_port=49819 --set monet_prompt= --trace
"--dbname=mTests_src_test_Update_Delete_action" --dbinit=" module(sql_server);"
; echo ; echo Over..
# 11:11:30 >
# builtin opt gdk_arch = 64bitx86_64-redhat-linux-gnu
# builtin opt gdk_version = 1.17.1
# builtin opt monet_pid = 6419
# builtin opt prefix = /ufs/goncalve/scratch/MonetDB/MonetDB
# 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 =
${exec_prefix}/lib/MonetDB:${exec_prefix}/lib/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/goncalve/scratch/MonetDB/MonetDB4
# config opt config = ${prefix}/etc/MonetDB.conf
# config opt prefix = /ufs/goncalve/scratch/MonetDB/MonetDB4
# config opt exec_prefix = ${prefix}
# config opt datadir = ${prefix}/share
# 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 =
${exec_prefix}/lib/MonetDB4:${exec_prefix}/lib/MonetDB4/lib:${exec_prefix}/lib/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 = true
# config opt xrpc_options =
# config opt xrpc_admin = 127.0.0.1
# config opt xrpc_user = 127.0.0.1
# config opt xrpc_trusted =
http://monetdb.cwi.nl;${prefix}/share/MonetDB/xrpc/export
# config opt standoff_ns =
# config opt standoff_start = start
# config opt standoff_end = end
# cmdline opt config = /ufs/goncalve/scratch/MonetDB/MonetDB4/etc/MonetDB.conf
# cmdline opt gdk_debug = 10
# cmdline opt monet_mod_path =
/ufs/goncalve/scratch/MonetDB/MonetDB4/lib/MonetDB4:/ufs/goncalve/scratch/MonetDB/MonetDB4/lib/MonetDB4/lib:/ufs/goncalve/scratch/MonetDB/MonetDB4/lib/MonetDB4/bin
# cmdline opt gdk_dbfarm =
/ufs/goncalve/scratch/MonetDB/MonetDB4/var/MonetDB4/dbfarm
# cmdline opt sql_logdir =
/ufs/goncalve/scratch/MonetDB/MonetDB4/var/MonetDB4/sql_logs
# cmdline opt xquery_logdir =
/ufs/goncalve/scratch/MonetDB/MonetDB4/var/MonetDB4/xquery_logs
# cmdline opt mapi_port = 36107
# cmdline opt xrpc_port = 49819
# cmdline opt monet_prompt =
# cmdline opt gdk_dbname = mTests_src_test_Update_Delete_action
# 11:11:31 >
# 11:11:31 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=36107
# 11:11:31 >
# 11:11:31 >
# 11:11:31 > Done.
# 11:11:31 >
--- NEW FILE: update_delete_set_null.stable.err ---
stderr of test 'update_delete_set_null` in directory
'src/test/Update_Delete_action` itself:
# 11:12:55 >
# 11:12:55 > Mtimeout -timeout 180 Mserver
"--config=/ufs/goncalve/scratch/MonetDB/MonetDB4/etc/MonetDB.conf" --debug=10
--set
"monet_mod_path=/ufs/goncalve/scratch/MonetDB/MonetDB4/lib/MonetDB4:/ufs/goncalve/scratch/MonetDB/MonetDB4/lib/MonetDB4/lib:/ufs/goncalve/scratch/MonetDB/MonetDB4/lib/MonetDB4/bin"
--set "gdk_dbfarm=/ufs/goncalve/scratch/MonetDB/MonetDB4/var/MonetDB4/dbfarm"
--set "sql_logdir=/ufs/goncalve/scratch/MonetDB/MonetDB4/var/MonetDB4/sql_logs"
--set
"xquery_logdir=/ufs/goncalve/scratch/MonetDB/MonetDB4/var/MonetDB4/xquery_logs"
--set mapi_port=38399 --set xrpc_port=48718 --set monet_prompt= --trace
"--dbname=mTests_src_test_Update_Delete_action" --dbinit=" module(sql_server);"
; echo ; echo Over..
# 11:12:55 >
# builtin opt gdk_arch = 64bitx86_64-redhat-linux-gnu
# builtin opt gdk_version = 1.17.1
# builtin opt monet_pid = 6584
# builtin opt prefix = /ufs/goncalve/scratch/MonetDB/MonetDB
# 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 =
${exec_prefix}/lib/MonetDB:${exec_prefix}/lib/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/goncalve/scratch/MonetDB/MonetDB4
# config opt config = ${prefix}/etc/MonetDB.conf
# config opt prefix = /ufs/goncalve/scratch/MonetDB/MonetDB4
# config opt exec_prefix = ${prefix}
# config opt datadir = ${prefix}/share
# 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 =
${exec_prefix}/lib/MonetDB4:${exec_prefix}/lib/MonetDB4/lib:${exec_prefix}/lib/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 = true
# config opt xrpc_options =
# config opt xrpc_admin = 127.0.0.1
# config opt xrpc_user = 127.0.0.1
# config opt xrpc_trusted =
http://monetdb.cwi.nl;${prefix}/share/MonetDB/xrpc/export
# config opt standoff_ns =
# config opt standoff_start = start
# config opt standoff_end = end
# cmdline opt config = /ufs/goncalve/scratch/MonetDB/MonetDB4/etc/MonetDB.conf
# cmdline opt gdk_debug = 10
# cmdline opt monet_mod_path =
/ufs/goncalve/scratch/MonetDB/MonetDB4/lib/MonetDB4:/ufs/goncalve/scratch/MonetDB/MonetDB4/lib/MonetDB4/lib:/ufs/goncalve/scratch/MonetDB/MonetDB4/lib/MonetDB4/bin
# cmdline opt gdk_dbfarm =
/ufs/goncalve/scratch/MonetDB/MonetDB4/var/MonetDB4/dbfarm
# cmdline opt sql_logdir =
/ufs/goncalve/scratch/MonetDB/MonetDB4/var/MonetDB4/sql_logs
# cmdline opt xquery_logdir =
/ufs/goncalve/scratch/MonetDB/MonetDB4/var/MonetDB4/xquery_logs
# cmdline opt mapi_port = 38399
# cmdline opt xrpc_port = 48718
# cmdline opt monet_prompt =
# cmdline opt gdk_dbname = mTests_src_test_Update_Delete_action
# 11:12:56 >
# 11:12:56 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=38399
# 11:12:56 >
# 11:12:56 >
# 11:12:56 > Done.
# 11:12:56 >
Index: update_cascade.sql
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/Update_Delete_action/Tests/update_cascade.sql,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- update_cascade.sql 2 Apr 2007 13:08:08 -0000 1.2
+++ update_cascade.sql 18 Apr 2007 09:18:05 -0000 1.3
@@ -27,9 +27,9 @@
insert into t3 values(5, 7);
update t1 set id = 10 where id =1;
-update t1 set id = 11 where id =2;
-update t1 set id = 12 where id =3;
-update t1 set id = 13 where id =4;
+--update t1 set id = 11 where id =2;
+--update t1 set id = 12 where id =3;
+--update t1 set id = 13 where id =4;
select * from t1;
select * from t2;
--- NEW FILE: delete_set_default.stable.err ---
stderr of test 'delete_set_default` in directory
'src/test/Update_Delete_action` itself:
# 11:10:52 >
# 11:10:52 > Mtimeout -timeout 180 Mserver
"--config=/ufs/goncalve/scratch/MonetDB/MonetDB4/etc/MonetDB.conf" --debug=10
--set
"monet_mod_path=/ufs/goncalve/scratch/MonetDB/MonetDB4/lib/MonetDB4:/ufs/goncalve/scratch/MonetDB/MonetDB4/lib/MonetDB4/lib:/ufs/goncalve/scratch/MonetDB/MonetDB4/lib/MonetDB4/bin"
--set "gdk_dbfarm=/ufs/goncalve/scratch/MonetDB/MonetDB4/var/MonetDB4/dbfarm"
--set "sql_logdir=/ufs/goncalve/scratch/MonetDB/MonetDB4/var/MonetDB4/sql_logs"
--set
"xquery_logdir=/ufs/goncalve/scratch/MonetDB/MonetDB4/var/MonetDB4/xquery_logs"
--set mapi_port=37796 --set xrpc_port=46913 --set monet_prompt= --trace
"--dbname=mTests_src_test_Update_Delete_action" --dbinit=" module(sql_server);"
; echo ; echo Over..
# 11:10:52 >
# builtin opt gdk_arch = 64bitx86_64-redhat-linux-gnu
# builtin opt gdk_version = 1.17.1
# builtin opt monet_pid = 6359
# builtin opt prefix = /ufs/goncalve/scratch/MonetDB/MonetDB
# 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 =
${exec_prefix}/lib/MonetDB:${exec_prefix}/lib/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/goncalve/scratch/MonetDB/MonetDB4
# config opt config = ${prefix}/etc/MonetDB.conf
# config opt prefix = /ufs/goncalve/scratch/MonetDB/MonetDB4
# config opt exec_prefix = ${prefix}
# config opt datadir = ${prefix}/share
# 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 =
${exec_prefix}/lib/MonetDB4:${exec_prefix}/lib/MonetDB4/lib:${exec_prefix}/lib/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 = true
# config opt xrpc_options =
# config opt xrpc_admin = 127.0.0.1
# config opt xrpc_user = 127.0.0.1
# config opt xrpc_trusted =
http://monetdb.cwi.nl;${prefix}/share/MonetDB/xrpc/export
# config opt standoff_ns =
# config opt standoff_start = start
# config opt standoff_end = end
# cmdline opt config = /ufs/goncalve/scratch/MonetDB/MonetDB4/etc/MonetDB.conf
# cmdline opt gdk_debug = 10
# cmdline opt monet_mod_path =
/ufs/goncalve/scratch/MonetDB/MonetDB4/lib/MonetDB4:/ufs/goncalve/scratch/MonetDB/MonetDB4/lib/MonetDB4/lib:/ufs/goncalve/scratch/MonetDB/MonetDB4/lib/MonetDB4/bin
# cmdline opt gdk_dbfarm =
/ufs/goncalve/scratch/MonetDB/MonetDB4/var/MonetDB4/dbfarm
# cmdline opt sql_logdir =
/ufs/goncalve/scratch/MonetDB/MonetDB4/var/MonetDB4/sql_logs
# cmdline opt xquery_logdir =
/ufs/goncalve/scratch/MonetDB/MonetDB4/var/MonetDB4/xquery_logs
# cmdline opt mapi_port = 37796
# cmdline opt xrpc_port = 46913
# cmdline opt monet_prompt =
# cmdline opt gdk_dbname = mTests_src_test_Update_Delete_action
# 11:10:52 >
# 11:10:52 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=37796
# 11:10:52 >
# 11:10:52 >
# 11:10:52 > Done.
# 11:10:52 >
-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
