Update of /cvsroot/monetdb/sql/src/test/Triggers/Tests
In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv22836
Modified Files:
Tag: SQL_2-18
referencing_clause_new.stable.out
referencing_clause_old.stable.out
Log Message:
Approve the new out and err.
Index: referencing_clause_old.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/Triggers/Tests/referencing_clause_old.stable.out,v
retrieving revision 1.2
retrieving revision 1.2.2.1
diff -u -d -r1.2 -r1.2.2.1
--- referencing_clause_old.stable.out 10 May 2007 16:28:52 -0000 1.2
+++ referencing_clause_old.stable.out 8 Jun 2007 12:50:42 -0000 1.2.2.1
@@ -5,6 +5,8 @@
# 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 >
+
+
# 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
@@ -29,14 +31,19 @@
% sys.t1, sys.t1 # table_name
% id, name # name
% int, varchar # type
-% 2, 14 # length
+% 2, 5 # length
[ 10, "mo" ]
[ 20, "monet" ]
+% sys.t2, sys.t2 # table_name
+% id, name # name
+% int, varchar # type
+% 1, 14 # length
[ 0, "update_old_row" ]
[ 1, "update_old_row" ]
[ 2, "update_old_row" ]
[ 3, "update_old_row" ]
-[ 6 ]
+[ 2 ]
+[ 4 ]
[ 1 ]
[ 1 ]
[ 1 ]
@@ -47,6 +54,10 @@
% sys.t1, sys.t1 # table_name
% id, name # name
% int, varchar # type
+% 1, 0 # length
+% sys.t2, sys.t2 # table_name
+% id, name # name
+% int, varchar # type
% 1, 14 # length
[ 0, "delete_old_row" ]
[ 1, "delete_old_row" ]
@@ -62,14 +73,19 @@
% sys.t1, sys.t1 # table_name
% id, name # name
% int, varchar # type
-% 2, 14 # length
+% 2, 7 # length
[ 10, "monetdb" ]
[ 20, "monet" ]
+% sys.t2, sys.t2 # table_name
+% id, name # name
+% int, varchar # type
+% 1, 14 # length
[ 0, "insert_old_row" ]
[ 1, "insert_old_row" ]
[ 2, "insert_old_row" ]
[ 3, "insert_old_row" ]
-[ 6 ]
+[ 2 ]
+[ 4 ]
[ 1 ]
[ 1 ]
[ 1 ]
@@ -81,15 +97,20 @@
% sys.t1, sys.t1 # table_name
% id, name # name
% int, varchar # type
-% 2, 24 # length
+% 2, 5 # length
[ 10, "mo" ]
[ 20, "monet" ]
+% sys.t2, sys.t2 # table_name
+% id, name # name
+% int, varchar # type
+% 1, 24 # length
[ 0, "insert_old_row_table" ]
[ 1, "insert_old_new_row" ]
[ 2, "insert_old__new_table" ]
[ 3, "insert_old_row_new_table" ]
-[ 3, "insert_old_table_new_row" ]
-[ 7 ]
+[ 4, "insert_old_table_new_row" ]
+[ 2 ]
+[ 5 ]
[ 1 ]
[ 1 ]
[ 1 ]
@@ -97,45 +118,48 @@
% sys.t1, sys.t1 # table_name
% id, name # name
% int, varchar # type
-% 2, 24 # length
+% 2, 7 # length
[ 10, "monetdb" ]
[ 20, "monet" ]
+% sys.t2, sys.t2 # table_name
+% id, name # name
+% int, varchar # type
+% 1, 24 # length
[ 1, "insert_old_new_row" ]
-[ 3, "insert_old_table_new_row" ]
-[ 1 ]
-[ 1 ]
+[ 4, "insert_old_table_new_row" ]
[ 1 ]
[ 1 ]
% sys.t1, sys.t1 # table_name
% id, name # name
% int, varchar # type
-% 2, 25 # length
+% 2, 5 # length
[ 10, "mo" ]
[ 20, "monet" ]
+% sys.t2, sys.t2 # table_name
+% id, name # name
+% int, varchar # type
+% 1, 24 # length
[ 1, "insert_old_new_row" ]
-[ 3, "insert_old_table_new_row" ]
-[ 0, "update_old_row__new_table" ]
-[ 1, "insert_old_new_row" ]
-[ 3, "insert_old_table_new_row" ]
-[ 1 ]
-[ 1 ]
+[ 4, "insert_old_table_new_row" ]
+[ 0, "update_old_row_new_table" ]
[ 1 ]
[ 1 ]
[ 2 ]
% sys.t1, sys.t1 # table_name
% id, name # name
% int, varchar # type
-% 1, 25 # length
-[ 1, "insert_old_new_row" ]
-[ 3, "insert_old_table_new_row" ]
-[ 0, "update_old_row__new_table" ]
-[ 1, "insert_old_new_row" ]
-[ 3, "insert_old_table_new_row" ]
-[ 1, "delete_old_new_row" ]
+% 1, 0 # length
+% sys.t2, sys.t2 # table_name
+% id, name # name
+% int, varchar # type
+% 1, 24 # length
[ 1, "insert_old_new_row" ]
-[ 3, "insert_old_table_new_row" ]
+[ 4, "insert_old_table_new_row" ]
+[ 0, "update_old_row_new_table" ]
+[ 2, "delete_old_new_row" ]
[ 3, "delete_old_row_new_table" ]
-[ 9 ]
+[ 0 ]
+[ 5 ]
# 13:12:17 >
# 13:12:17 > 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.2
retrieving revision 1.2.2.1
diff -u -d -r1.2 -r1.2.2.1
--- referencing_clause_new.stable.out 10 May 2007 16:28:52 -0000 1.2
+++ referencing_clause_new.stable.out 8 Jun 2007 12:50:42 -0000 1.2.2.1
@@ -5,6 +5,8 @@
# 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 >
+
+
# 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
@@ -29,48 +31,137 @@
% sys.t1, sys.t1 # table_name
% id, name # name
% int, varchar # type
-% 2, 14 # length
+% 2, 5 # length
[ 10, "mo" ]
[ 20, "monet" ]
+% sys.t2, sys.t2 # table_name
+% id, name # name
+% int, varchar # type
+% 1, 14 # length
[ 0, "update_new_row" ]
[ 1, "update_new_row" ]
[ 2, "update_new_row" ]
[ 3, "update_new_row" ]
-[ 6 ]
+[ 2 ]
+[ 4 ]
[ 1 ]
[ 1 ]
[ 1 ]
[ 1 ]
[ 1 ]
[ 1 ]
+[ 2 ]
% sys.t1, sys.t1 # table_name
% id, name # name
% int, varchar # type
-% 2, 14 # length
+% 1, 0 # length
+% sys.t2, sys.t2 # table_name
+% id, name # name
+% int, varchar # type
+% 1, 14 # length
+[ 0, "delete_new_row" ]
+[ 1, "delete_new_row" ]
+[ 2, "delete_new_row" ]
+[ 3, "delete_new_row" ]
+[ 4 ]
+[ 1 ]
+[ 1 ]
+[ 1 ]
+[ 1 ]
+[ 1 ]
+[ 1 ]
+% sys.t1, sys.t1 # table_name
+% id, name # name
+% int, varchar # type
+% 2, 7 # length
[ 10, "monetdb" ]
[ 20, "monet" ]
+% sys.t2, sys.t2 # table_name
+% id, name # name
+% int, varchar # type
+% 1, 14 # length
[ 0, "insert_new_row" ]
[ 1, "insert_new_row" ]
[ 2, "insert_new_row" ]
[ 3, "insert_new_row" ]
-[ 6 ]
+[ 2 ]
+[ 4 ]
+[ 1 ]
[ 1 ]
[ 1 ]
[ 1 ]
[ 1 ]
[ 1 ]
[ 1 ]
+[ 1 ]
+% sys.t1, sys.t1 # table_name
+% id, name # name
+% int, varchar # type
+% 2, 5 # length
+[ 10, "mo" ]
+[ 20, "monet" ]
+% sys.t2, sys.t2 # table_name
+% id, name # name
+% int, varchar # type
+% 1, 24 # length
+[ 0, "insert_new_row_table" ]
+[ 1, "insert_new_new_row" ]
+[ 2, "insert_new__new_table" ]
+[ 3, "insert_new_row_new_table" ]
+[ 4, "insert_new_table_new_row" ]
[ 2 ]
+[ 5 ]
+[ 1 ]
+[ 1 ]
+[ 1 ]
+[ 1 ]
% sys.t1, sys.t1 # table_name
% id, name # name
% int, varchar # type
-% 1, 14 # length
-[ 0, "delete_new_row" ]
-[ 1, "delete_new_row" ]
-[ 2, "delete_new_row" ]
-[ 3, "delete_new_row" ]
+% 2, 7 # length
+[ 10, "monetdb" ]
+[ 20, "monet" ]
+% sys.t2, sys.t2 # table_name
+% id, name # name
+% int, varchar # type
+% 1, 24 # length
+[ 1, "insert_new_new_row" ]
+[ 4, "insert_new_table_new_row" ]
+[ 1 ]
+[ 1 ]
+% sys.t1, sys.t1 # table_name
+% id, name # name
+% int, varchar # type
+% 2, 5 # length
+[ 10, "mo" ]
+[ 20, "monet" ]
+% sys.t2, sys.t2 # table_name
+% id, name # name
+% int, varchar # type
+% 1, 24 # length
+[ 1, "insert_new_new_row" ]
+[ 4, "insert_new_table_new_row" ]
+[ 0, "update_new_row_new_table" ]
+[ 1 ]
+[ 1 ]
+[ 2 ]
+% sys.t1, sys.t1 # table_name
+% id, name # name
+% int, varchar # type
+% 1, 0 # length
+% sys.t2, sys.t2 # table_name
+% id, name # name
+% int, varchar # type
+% 1, 24 # length
+[ 1, "insert_new_new_row" ]
+[ 4, "insert_new_table_new_row" ]
+[ 0, "update_new_row_new_table" ]
+[ 2, "delete_new_new_row" ]
+[ 3, "delete_new_row_new_table" ]
+[ 0 ]
+[ 5 ]
-# 16:00:56 >
-# 16:00:56 > Done.
-# 16:00:56 >
+# 18:02:48 >
+# 18:02:48 > Done.
+# 18:02:48 >
-------------------------------------------------------------------------
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
