Update of /cvsroot/monetdb/sql/src/test/Triggers/Tests
In directory sc8-pr-cvs16:/tmp/cvs-serv21440/Tests
Modified Files:
recursive_triggers.stable.out
referencing_clause_new.stable.out
referencing_clause_old.stable.out
Log Message:
New out outputs for recursive and cascaded triggers. The previous out were
wrong.
Index: recursive_triggers.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/Triggers/Tests/recursive_triggers.stable.out,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -d -r1.1 -r1.2
--- recursive_triggers.stable.out 7 Dec 2006 15:26:07 -0000 1.1
+++ recursive_triggers.stable.out 10 May 2007 16:28:52 -0000 1.2
@@ -1,19 +1,19 @@
stdout of test 'recursive_triggers` in directory 'src/test/Triggers` itself:
-# 15:06:05 >
-# 15:06:05 > 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/MonetDB:/ufs/goncalve/scratch/MonetDB/monetdb4/lib/MonetDB/lib:/ufs/goncalve/scratch/MonetDB/monetdb4/lib/MonetDB/bin"
--set "gdk_dbfarm=/ufs/goncalve/scratch/MonetDB/monetdb4/var/MonetDB/dbfarm"
--set "sql_logdir=/ufs/goncalve/scratch/MonetDB/monetdb4/var/MonetDB/sql_logs"
--set "xquery_logdir=something" --set mapi_port=38417 --set monet_prompt=
--trace "--dbname=mTests_src_test_Triggers" --dbinit=" module(sql_server);" ;
echo ; echo Over..
-# 15:06:05 >
+# 18:22:49 >
+# 18:22:49 > 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=31273 --set xrpc_port=46173 --set monet_prompt= --trace
"--dbname=mTests_src_test_Triggers" --dbinit=' include sql;' ; echo ; echo
Over..
+# 18:22:49 >
-# Monet Database Server V4.15.0
-# Copyright (c) 1993-2006, 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");
+
+# MonetDB Server v5.0.0_beta2_1
+# Copyright (c) 1993-2007 CWI, all rights reserved
+# Compiled for x86_64-redhat-linux-gnu/64bit with 64bit OIDs dynamically linked
+# dbname:mTests_src_test_Triggers
+# Visit http://monetdb.cwi.nl/ for further information
Ready.
-quit();
Over..
@@ -35,7 +35,6 @@
% 1, 1 # length
[ 4 ]
[ 1 ]
-[ 4 ]
[ 1 ]
% sys.t1, sys.t1, sys.t1 # table_name
% id, name, age # name
@@ -53,14 +52,9 @@
[ 1, 24 ]
[ 2, 26 ]
[ 1, 24 ]
-[ 1, 25 ]
-[ 1, 24 ]
-[ 2, 26 ]
-[ 1, 24 ]
[ 1 ]
[ 6 ]
[ 1 ]
-[ 6 ]
[ 1 ]
% sys.t1, sys.t1, sys.t1 # table_name
% id, name, age # name
@@ -80,10 +74,6 @@
[ 1, 24 ]
[ 2, 26 ]
[ 1, 24 ]
-[ 1, 25 ]
-[ 1, 24 ]
-[ 2, 26 ]
-[ 1, 24 ]
[ 1, 23 ]
[ 1, 25 ]
[ 1, 24 ]
@@ -91,12 +81,6 @@
[ 1, 24 ]
[ 3, 27 ]
[ 1, 24 ]
-[ 1, 25 ]
-[ 1, 24 ]
-[ 2, 26 ]
-[ 1, 24 ]
-[ 3, 27 ]
-[ 1, 24 ]
[ 1 ]
[ 4 ]
% sys.t1, sys.t1, sys.t1 # table_name
@@ -112,10 +96,6 @@
[ 1, 24 ]
[ 2, 26 ]
[ 1, 24 ]
-[ 1, 25 ]
-[ 1, 24 ]
-[ 2, 26 ]
-[ 1, 24 ]
[ 1, 23 ]
[ 1, 25 ]
[ 1, 24 ]
@@ -123,12 +103,6 @@
[ 1, 24 ]
[ 3, 27 ]
[ 1, 24 ]
-[ 1, 25 ]
-[ 1, 24 ]
-[ 2, 26 ]
-[ 1, 24 ]
-[ 3, 27 ]
-[ 1, 24 ]
[ 1 ]
[ 1 ]
% sys.t1, sys.t1, sys.t1 # table_name
@@ -144,10 +118,6 @@
[ 1, 24 ]
[ 2, 26 ]
[ 1, 24 ]
-[ 1, 25 ]
-[ 1, 24 ]
-[ 2, 26 ]
-[ 1, 24 ]
[ 1, 23 ]
[ 1, 25 ]
[ 1, 24 ]
@@ -155,12 +125,6 @@
[ 1, 24 ]
[ 3, 27 ]
[ 1, 24 ]
-[ 1, 25 ]
-[ 1, 24 ]
-[ 2, 26 ]
-[ 1, 24 ]
-[ 3, 27 ]
-[ 1, 24 ]
# 15:06:05 >
# 15:06:05 > Done.
Index: referencing_clause_new.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/Triggers/Tests/referencing_clause_new.stable.out,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -d -r1.1 -r1.2
--- referencing_clause_new.stable.out 7 Dec 2006 15:26:08 -0000 1.1
+++ referencing_clause_new.stable.out 10 May 2007 16:28:52 -0000 1.2
@@ -1,19 +1,17 @@
stdout of test 'referencing_clause_new` in directory 'src/test/Triggers`
itself:
-# 16:00:56 >
-# 16:00:56 > 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/MonetDB:/ufs/goncalve/scratch/MonetDB/monetdb4/lib/MonetDB/lib:/ufs/goncalve/scratch/MonetDB/monetdb4/lib/MonetDB/bin"
--set "gdk_dbfarm=/ufs/goncalve/scratch/MonetDB/monetdb4/var/MonetDB/dbfarm"
--set "sql_logdir=/ufs/goncalve/scratch/MonetDB/monetdb4/var/MonetDB/sql_logs"
--set "xquery_logdir=something" --set mapi_port=35011 --set monet_prompt=
--trace "--dbname=mTests_src_test_Triggers" --dbinit=" module(sql_server);" ;
echo ; echo Over..
-# 16:00:56 >
-
-# Monet Database Server V4.15.0
-# Copyright (c) 1993-2006, 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.
+# 18:27:25 >
+# 18:27:25 > 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=30901 --set xrpc_port=40751 --set monet_prompt= --trace
"--dbname=mTests_src_test_Triggers" --dbinit=' include sql;' ; echo ; echo
Over..
+# 18:27:25 >
-printf("\nReady.\n");
+# MonetDB Server v5.0.0_beta2_1
+# Copyright (c) 1993-2007 CWI, all rights reserved
+# Compiled for x86_64-redhat-linux-gnu/64bit with 64bit OIDs dynamically linked
+# dbname:mTests_src_test_Triggers
+# Visit http://monetdb.cwi.nl/ for further information
Ready.
-quit();
Over..
@@ -45,18 +43,6 @@
[ 1 ]
[ 1 ]
[ 1 ]
-[ 1 ]
-[ 1 ]
-[ 1 ]
-[ 1 ]
-[ 1 ]
-[ 1 ]
-[ 1 ]
-[ 1 ]
-[ 1 ]
-[ 1 ]
-[ 1 ]
-[ 1 ]
% sys.t1, sys.t1 # table_name
% id, name # name
% int, varchar # type
@@ -67,19 +53,7 @@
[ 1, "insert_new_row" ]
[ 2, "insert_new_row" ]
[ 3, "insert_new_row" ]
-[ 1, "insert_new_row" ]
-[ 0, "insert_new_row" ]
-[ 2, "insert_new_row" ]
-[ 3, "insert_new_row" ]
-[ 2, "insert_new_row" ]
-[ 0, "insert_new_row" ]
-[ 1, "insert_new_row" ]
-[ 3, "insert_new_row" ]
-[ 3, "insert_new_row" ]
-[ 0, "insert_new_row" ]
-[ 1, "insert_new_row" ]
-[ 2, "insert_new_row" ]
-[ 18 ]
+[ 6 ]
[ 1 ]
[ 1 ]
[ 1 ]
Index: referencing_clause_old.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/Triggers/Tests/referencing_clause_old.stable.out,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -d -r1.1 -r1.2
--- referencing_clause_old.stable.out 8 Dec 2006 12:17:43 -0000 1.1
+++ referencing_clause_old.stable.out 10 May 2007 16:28:52 -0000 1.2
@@ -1,19 +1,17 @@
stdout of test 'referencing_clause_old` in directory 'src/test/Triggers`
itself:
-# 13:12:16 >
-# 13:12:16 > 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/MonetDB:/ufs/goncalve/scratch/MonetDB/monetdb4/lib/MonetDB/lib:/ufs/goncalve/scratch/MonetDB/monetdb4/lib/MonetDB/bin"
--set "gdk_dbfarm=/ufs/goncalve/scratch/MonetDB/monetdb4/var/MonetDB/dbfarm"
--set "sql_logdir=/ufs/goncalve/scratch/MonetDB/monetdb4/var/MonetDB/sql_logs"
--set "xquery_logdir=something" --set mapi_port=32243 --set monet_prompt=
--trace "--dbname=mTests_src_test_Triggers" --dbinit=" module(sql_server);" ;
echo ; echo Over..
-# 13:12:16 >
-
-# Monet Database Server V4.15.0
-# Copyright (c) 1993-2006, 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.
+# 18:26:44 >
+# 18:26:44 > 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=39986 --set xrpc_port=41666 --set monet_prompt= --trace
"--dbname=mTests_src_test_Triggers" --dbinit=' include sql;' ; echo ; echo
Over..
+# 18:26:44 >
-printf("\nReady.\n");
+# MonetDB Server v5.0.0_beta2_1
+# Copyright (c) 1993-2007 CWI, all rights reserved
+# Compiled for x86_64-redhat-linux-gnu/64bit with 64bit OIDs dynamically linked
+# dbname:mTests_src_test_Triggers
+# Visit http://monetdb.cwi.nl/ for further information
Ready.
-quit();
Over..
@@ -61,18 +59,6 @@
[ 1 ]
[ 1 ]
[ 1 ]
-[ 1 ]
-[ 1 ]
-[ 1 ]
-[ 1 ]
-[ 1 ]
-[ 1 ]
-[ 1 ]
-[ 1 ]
-[ 1 ]
-[ 1 ]
-[ 1 ]
-[ 1 ]
% sys.t1, sys.t1 # table_name
% id, name # name
% int, varchar # type
@@ -83,19 +69,7 @@
[ 1, "insert_old_row" ]
[ 2, "insert_old_row" ]
[ 3, "insert_old_row" ]
-[ 1, "insert_old_row" ]
-[ 0, "insert_old_row" ]
-[ 2, "insert_old_row" ]
-[ 3, "insert_old_row" ]
-[ 2, "insert_old_row" ]
-[ 0, "insert_old_row" ]
-[ 1, "insert_old_row" ]
-[ 3, "insert_old_row" ]
-[ 3, "insert_old_row" ]
-[ 0, "insert_old_row" ]
-[ 1, "insert_old_row" ]
-[ 2, "insert_old_row" ]
-[ 18 ]
+[ 6 ]
[ 1 ]
[ 1 ]
[ 1 ]
@@ -120,8 +94,6 @@
[ 1 ]
[ 1 ]
[ 1 ]
-[ 1 ]
-[ 1 ]
% sys.t1, sys.t1 # table_name
% id, name # name
% int, varchar # type
@@ -130,8 +102,6 @@
[ 20, "monet" ]
[ 1, "insert_old_new_row" ]
[ 3, "insert_old_table_new_row" ]
-[ 3, "insert_old_table_new_row" ]
-[ 1, "insert_old_new_row" ]
[ 1 ]
[ 1 ]
[ 1 ]
@@ -144,8 +114,6 @@
[ 20, "monet" ]
[ 1, "insert_old_new_row" ]
[ 3, "insert_old_table_new_row" ]
-[ 3, "insert_old_table_new_row" ]
-[ 1, "insert_old_new_row" ]
[ 0, "update_old_row__new_table" ]
[ 1, "insert_old_new_row" ]
[ 3, "insert_old_table_new_row" ]
@@ -153,8 +121,6 @@
[ 1 ]
[ 1 ]
[ 1 ]
-[ 1 ]
-[ 1 ]
[ 2 ]
% sys.t1, sys.t1 # table_name
% id, name # name
@@ -162,8 +128,6 @@
% 1, 25 # length
[ 1, "insert_old_new_row" ]
[ 3, "insert_old_table_new_row" ]
-[ 3, "insert_old_table_new_row" ]
-[ 1, "insert_old_new_row" ]
[ 0, "update_old_row__new_table" ]
[ 1, "insert_old_new_row" ]
[ 3, "insert_old_table_new_row" ]
@@ -171,9 +135,7 @@
[ 1, "insert_old_new_row" ]
[ 3, "insert_old_table_new_row" ]
[ 3, "delete_old_row_new_table" ]
-[ 1, "insert_old_new_row" ]
-[ 3, "insert_old_table_new_row" ]
-[ 13 ]
+[ 9 ]
# 13:12:17 >
# 13:12:17 > Done.
-------------------------------------------------------------------------
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
