Update of /cvsroot/monetdb/sql/src/test/Triggers/Tests
In directory 
23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv21442/src/test/Triggers/Tests

Modified Files:
        cascaded_triggers.stable.out referencing_clause_new.stable.out 
        referencing_clause_old.stable.out trigger_action.stable.out 
        trigger_activation.stable.out trigger_insert.stable.out 
        trigger_owner.stable.out triggers_schema_operations.stable.out 
Log Message:
algebra now has insert,update and delete operators.
mostly code moved from sql_updates.mx into rel_bin.mx
In the process, within functions we no longer output 'rows affected' 
results of insert, update and deletes.

alter table use update instead insert now (column/idx bat with default
values is generated by the storage layer).

create user, now uses the table_funcs interface 
same holds for granting and revoking privileges on tables.
This was needed to remove dependency on old insert/delete code.


U triggers_schema_operations.stable.out
Index: triggers_schema_operations.stable.out
===================================================================
RCS file: 
/cvsroot/monetdb/sql/src/test/Triggers/Tests/triggers_schema_operations.stable.out,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- triggers_schema_operations.stable.out       8 Dec 2006 13:18:13 -0000       
1.2
+++ triggers_schema_operations.stable.out       21 Dec 2008 19:38:23 -0000      
1.3
@@ -1,19 +1,23 @@
 stdout of test 'triggers_schema_operations` in directory 'src/test/Triggers` 
itself:
 
 
-# 14:01:51 >  
-# 14:01:51 >  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=32415 --set monet_prompt= 
--trace "--dbname=mTests_src_test_Triggers" --dbinit=" module(sql_server);" ; 
echo ; echo Over..
-# 14:01:51 >  
-
-# 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.
+# 20:28:20 >  
+# 20:28:20 >   mserver5 
"--config=/ufs/niels/scratch/monetdb/Linux-x86_64/etc/monetdb5.conf" --debug=10 
--set gdk_nr_threads=4 --set 
"monet_mod_path=/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB5:/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB5/lib:/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB5/bin"
 --set "gdk_dbfarm=/ufs/niels/scratch/monetdb/Linux-x86_64/var/MonetDB5/dbfarm" 
--set 
"sql_logdir=/ufs/niels/scratch/monetdb/Linux-x86_64/var/MonetDB5/sql_logs"  
--set mapi_open=true --set xrpc_open=true --set mapi_port=35138 --set 
xrpc_port=49382 --set monet_prompt= --trace  
"--dbname=mTests_src_test_Triggers" --set mal_listing=0 "--dbinit= include 
sql;" ; echo ; echo Over..
+# 20:28:20 >  
 
-printf("\nReady.\n");
+# MonetDB server v5.9.0, based on kernel v1.27.0
+# Serving database 'mTests_src_test_Triggers', using 4 threads
+# Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs dynamically 
linked
+# Copyright (c) 1993-July 2008 CWI.
+# Copyright (c) August 2008- MonetDB B.V., all rights reserved
+# Visit http://monetdb.cwi.nl/ for further information
+# Listening for connection requests on mapi:monetdb://alf.ins.cwi.nl:35138/
+# MonetDB/SQL module v2.27.0 loaded
 
 Ready.
-quit();
+#function user.main():void;
+#    clients.quit();
+#end main;
 
 Over..
 

U referencing_clause_old.stable.out
Index: referencing_clause_old.stable.out
===================================================================
RCS file: 
/cvsroot/monetdb/sql/src/test/Triggers/Tests/referencing_clause_old.stable.out,v
retrieving revision 1.3
retrieving revision 1.4
diff -u -d -r1.3 -r1.4
--- referencing_clause_old.stable.out   12 Jun 2007 17:26:13 -0000      1.3
+++ referencing_clause_old.stable.out   21 Dec 2008 19:38:23 -0000      1.4
@@ -24,10 +24,6 @@
 [ 1    ]
 [ 1    ]
 [ 1    ]
-[ 1    ]
-[ 1    ]
-[ 1    ]
-[ 1    ]
 % sys.t1,      sys.t1 # table_name
 % id,  name # name
 % int, varchar # type
@@ -46,10 +42,6 @@
 [ 4    ]
 [ 1    ]
 [ 1    ]
-[ 1    ]
-[ 1    ]
-[ 1    ]
-[ 1    ]
 [ 2    ]
 % sys.t1,      sys.t1 # table_name
 % id,  name # name
@@ -66,10 +58,6 @@
 [ 4    ]
 [ 1    ]
 [ 1    ]
-[ 1    ]
-[ 1    ]
-[ 1    ]
-[ 1    ]
 % sys.t1,      sys.t1 # table_name
 % id,  name # name
 % int, varchar # type
@@ -89,11 +77,6 @@
 [ 1    ]
 [ 1    ]
 [ 1    ]
-[ 1    ]
-[ 1    ]
-[ 1    ]
-[ 1    ]
-[ 1    ]
 % sys.t1,      sys.t1 # table_name
 % id,  name # name
 % int, varchar # type
@@ -113,8 +96,6 @@
 [ 5    ]
 [ 1    ]
 [ 1    ]
-[ 1    ]
-[ 1    ]
 % sys.t1,      sys.t1 # table_name
 % id,  name # name
 % int, varchar # type
@@ -128,7 +109,6 @@
 [ 1,   "insert_old_new_row"    ]
 [ 4,   "insert_old_table_new_row"      ]
 [ 1    ]
-[ 1    ]
 % sys.t1,      sys.t1 # table_name
 % id,  name # name
 % int, varchar # type
@@ -142,8 +122,6 @@
 [ 1,   "insert_old_new_row"    ]
 [ 4,   "insert_old_table_new_row"      ]
 [ 0,   "update_old_row_new_table"      ]
-[ 1    ]
-[ 1    ]
 [ 2    ]
 % sys.t1,      sys.t1 # table_name
 % id,  name # name

U referencing_clause_new.stable.out
Index: referencing_clause_new.stable.out
===================================================================
RCS file: 
/cvsroot/monetdb/sql/src/test/Triggers/Tests/referencing_clause_new.stable.out,v
retrieving revision 1.3
retrieving revision 1.4
diff -u -d -r1.3 -r1.4
--- referencing_clause_new.stable.out   12 Jun 2007 17:26:13 -0000      1.3
+++ referencing_clause_new.stable.out   21 Dec 2008 19:38:23 -0000      1.4
@@ -24,10 +24,6 @@
 [ 1    ]
 [ 1    ]
 [ 1    ]
-[ 1    ]
-[ 1    ]
-[ 1    ]
-[ 1    ]
 % sys.t1,      sys.t1 # table_name
 % id,  name # name
 % int, varchar # type
@@ -46,10 +42,6 @@
 [ 4    ]
 [ 1    ]
 [ 1    ]
-[ 1    ]
-[ 1    ]
-[ 1    ]
-[ 1    ]
 [ 2    ]
 % sys.t1,      sys.t1 # table_name
 % id,  name # name
@@ -66,10 +58,6 @@
 [ 4    ]
 [ 1    ]
 [ 1    ]
-[ 1    ]
-[ 1    ]
-[ 1    ]
-[ 1    ]
 % sys.t1,      sys.t1 # table_name
 % id,  name # name
 % int, varchar # type
@@ -89,11 +77,6 @@
 [ 1    ]
 [ 1    ]
 [ 1    ]
-[ 1    ]
-[ 1    ]
-[ 1    ]
-[ 1    ]
-[ 1    ]
 % sys.t1,      sys.t1 # table_name
 % id,  name # name
 % int, varchar # type
@@ -113,8 +96,6 @@
 [ 5    ]
 [ 1    ]
 [ 1    ]
-[ 1    ]
-[ 1    ]
 % sys.t1,      sys.t1 # table_name
 % id,  name # name
 % int, varchar # type
@@ -128,7 +109,6 @@
 [ 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
@@ -142,8 +122,6 @@
 [ 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

U cascaded_triggers.stable.out
Index: cascaded_triggers.stable.out
===================================================================
RCS file: 
/cvsroot/monetdb/sql/src/test/Triggers/Tests/cascaded_triggers.stable.out,v
retrieving revision 1.3
retrieving revision 1.4
diff -u -d -r1.3 -r1.4
--- cascaded_triggers.stable.out        6 Nov 2007 15:45:21 -0000       1.3
+++ cascaded_triggers.stable.out        21 Dec 2008 19:38:23 -0000      1.4
@@ -1,23 +1,23 @@
 stdout of test 'cascaded_triggers` in directory 'src/test/Triggers` itself:
 
 
-# 12:53:18 >  
-# 12:53:18 >   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_open=true --set xrpc_open=true --set mapi_port=39231 --set 
xrpc_port=40555 --set monet_prompt= --trace "--dbname=mTests_src_test_Triggers" 
"--dbinit= module(sql_server);" ; echo ; echo Over..
-# 12:53:18 >  
-
-
-
-# MonetDB Server v4.21.0
-# based on GDK   v1.21.0
-# 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.
-# MonetDB/SQL module v2.21.0 loaded
+# 20:28:18 >  
+# 20:28:18 >   mserver5 
"--config=/ufs/niels/scratch/monetdb/Linux-x86_64/etc/monetdb5.conf" --debug=10 
--set gdk_nr_threads=4 --set 
"monet_mod_path=/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB5:/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB5/lib:/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB5/bin"
 --set "gdk_dbfarm=/ufs/niels/scratch/monetdb/Linux-x86_64/var/MonetDB5/dbfarm" 
--set 
"sql_logdir=/ufs/niels/scratch/monetdb/Linux-x86_64/var/MonetDB5/sql_logs"  
--set mapi_open=true --set xrpc_open=true --set mapi_port=35138 --set 
xrpc_port=49382 --set monet_prompt= --trace  
"--dbname=mTests_src_test_Triggers" --set mal_listing=0 "--dbinit= include 
sql;" ; echo ; echo Over..
+# 20:28:18 >  
 
-printf("\nReady.\n");
+# MonetDB server v5.9.0, based on kernel v1.27.0
+# Serving database 'mTests_src_test_Triggers', using 4 threads
+# Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs dynamically 
linked
+# Copyright (c) 1993-July 2008 CWI.
+# Copyright (c) August 2008- MonetDB B.V., all rights reserved
+# Visit http://monetdb.cwi.nl/ for further information
+# Listening for connection requests on mapi:monetdb://alf.ins.cwi.nl:35138/
+# MonetDB/SQL module v2.27.0 loaded
 
 Ready.
-quit();
+#function user.main():void;
+#    clients.quit();
+#end main;
 
 Over..
 
@@ -26,7 +26,6 @@
 # 14:51:08 >  
 
 [ 1    ]
-[ 1    ]
 % sys.t1,      sys.t1, sys.t1 # table_name
 % id,  name,   age # name
 % int, varchar,        int # type
@@ -38,8 +37,6 @@
 % 1,   2 # length
 [ 1,   25      ]
 [ 1    ]
-[ 1    ]
-[ 1    ]
 % sys.t1,      sys.t1, sys.t1 # table_name
 % id,  name,   age # name
 % int, varchar,        int # type
@@ -51,9 +48,6 @@
 % 1,   2 # length
 [ 1,   25      ]
 [ 3,   27      ]
-[ 2    ]
-[ 1    ]
-[ 2    ]
 [ 0    ]
 % sys.t1,      sys.t1, sys.t1 # table_name
 % id,  name,   age # name

U trigger_activation.stable.out
Index: trigger_activation.stable.out
===================================================================
RCS file: 
/cvsroot/monetdb/sql/src/test/Triggers/Tests/trigger_activation.stable.out,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -d -r1.1 -r1.2
--- trigger_activation.stable.out       8 Dec 2006 14:22:56 -0000       1.1
+++ trigger_activation.stable.out       21 Dec 2008 19:38:23 -0000      1.2
@@ -1,19 +1,23 @@
 stdout of test 'trigger_activation` in directory 'src/test/Triggers` itself:
 
 
-# 15:21:32 >  
-# 15:21:32 >  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=37927 --set monet_prompt= 
--trace "--dbname=mTests_src_test_Triggers" --dbinit=" module(sql_server);" ; 
echo ; echo Over..
-# 15:21:32 >  
-
-# 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.
+# 20:28:19 >  
+# 20:28:19 >   mserver5 
"--config=/ufs/niels/scratch/monetdb/Linux-x86_64/etc/monetdb5.conf" --debug=10 
--set gdk_nr_threads=4 --set 
"monet_mod_path=/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB5:/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB5/lib:/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB5/bin"
 --set "gdk_dbfarm=/ufs/niels/scratch/monetdb/Linux-x86_64/var/MonetDB5/dbfarm" 
--set 
"sql_logdir=/ufs/niels/scratch/monetdb/Linux-x86_64/var/MonetDB5/sql_logs"  
--set mapi_open=true --set xrpc_open=true --set mapi_port=35138 --set 
xrpc_port=49382 --set monet_prompt= --trace  
"--dbname=mTests_src_test_Triggers" --set mal_listing=0 "--dbinit= include 
sql;" ; echo ; echo Over..
+# 20:28:19 >  
 
-printf("\nReady.\n");
+# MonetDB server v5.9.0, based on kernel v1.27.0
+# Serving database 'mTests_src_test_Triggers', using 4 threads
+# Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs dynamically 
linked
+# Copyright (c) 1993-July 2008 CWI.
+# Copyright (c) August 2008- MonetDB B.V., all rights reserved
+# Visit http://monetdb.cwi.nl/ for further information
+# Listening for connection requests on mapi:monetdb://alf.ins.cwi.nl:35138/
+# MonetDB/SQL module v2.27.0 loaded
 
 Ready.
-quit();
+#function user.main():void;
+#    clients.quit();
+#end main;
 
 Over..
 
@@ -24,10 +28,6 @@
 [ 1    ]
 [ 1    ]
 [ 1    ]
-[ 1    ]
-[ 1    ]
-[ 1    ]
-[ 1    ]
 % sys.t1,      sys.t1 # table_name
 % id,  name # name
 % int, varchar # type

U trigger_owner.stable.out
Index: trigger_owner.stable.out
===================================================================
RCS file: 
/cvsroot/monetdb/sql/src/test/Triggers/Tests/trigger_owner.stable.out,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -d -r1.1 -r1.2
--- trigger_owner.stable.out    8 Dec 2006 13:18:13 -0000       1.1
+++ trigger_owner.stable.out    21 Dec 2008 19:38:23 -0000      1.2
@@ -1,19 +1,23 @@
 stdout of test 'trigger_owner` in directory 'src/test/Triggers` itself:
 
 
-# 14:14:17 >  
-# 14:14:17 >  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=35358 --set monet_prompt= 
--trace "--dbname=mTests_src_test_Triggers" --dbinit=" module(sql_server);" ; 
echo ; echo Over..
-# 14:14:17 >  
-
-# 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.
+# 20:28:20 >  
+# 20:28:20 >   mserver5 
"--config=/ufs/niels/scratch/monetdb/Linux-x86_64/etc/monetdb5.conf" --debug=10 
--set gdk_nr_threads=4 --set 
"monet_mod_path=/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB5:/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB5/lib:/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB5/bin"
 --set "gdk_dbfarm=/ufs/niels/scratch/monetdb/Linux-x86_64/var/MonetDB5/dbfarm" 
--set 
"sql_logdir=/ufs/niels/scratch/monetdb/Linux-x86_64/var/MonetDB5/sql_logs"  
--set mapi_open=true --set xrpc_open=true --set mapi_port=35138 --set 
xrpc_port=49382 --set monet_prompt= --trace  
"--dbname=mTests_src_test_Triggers" --set mal_listing=0 "--dbinit= include 
sql;" ; echo ; echo Over..
+# 20:28:20 >  
 
-printf("\nReady.\n");
+# MonetDB server v5.9.0, based on kernel v1.27.0
+# Serving database 'mTests_src_test_Triggers', using 4 threads
+# Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs dynamically 
linked
+# Copyright (c) 1993-July 2008 CWI.
+# Copyright (c) August 2008- MonetDB B.V., all rights reserved
+# Visit http://monetdb.cwi.nl/ for further information
+# Listening for connection requests on mapi:monetdb://alf.ins.cwi.nl:35138/
+# MonetDB/SQL module v2.27.0 loaded
 
 Ready.
-quit();
+#function user.main():void;
+#    clients.quit();
+#end main;
 
 Over..
 

U trigger_action.stable.out
Index: trigger_action.stable.out
===================================================================
RCS file: 
/cvsroot/monetdb/sql/src/test/Triggers/Tests/trigger_action.stable.out,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -d -r1.1 -r1.2
--- trigger_action.stable.out   10 Dec 2006 20:22:34 -0000      1.1
+++ trigger_action.stable.out   21 Dec 2008 19:38:23 -0000      1.2
@@ -1,19 +1,23 @@
 stdout of test 'trigger_action` in directory 'src/test/Triggers` itself:
 
 
-# 21:20:07 >  
-# 21:20:07 >  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=37598 --set monet_prompt= 
--trace "--dbname=mTests_src_test_Triggers" --dbinit=" module(sql_server);" ; 
echo ; echo Over..
-# 21:20:07 >  
-
-# 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.
+# 20:28:19 >  
+# 20:28:19 >   mserver5 
"--config=/ufs/niels/scratch/monetdb/Linux-x86_64/etc/monetdb5.conf" --debug=10 
--set gdk_nr_threads=4 --set 
"monet_mod_path=/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB5:/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB5/lib:/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB5/bin"
 --set "gdk_dbfarm=/ufs/niels/scratch/monetdb/Linux-x86_64/var/MonetDB5/dbfarm" 
--set 
"sql_logdir=/ufs/niels/scratch/monetdb/Linux-x86_64/var/MonetDB5/sql_logs"  
--set mapi_open=true --set xrpc_open=true --set mapi_port=35138 --set 
xrpc_port=49382 --set monet_prompt= --trace  
"--dbname=mTests_src_test_Triggers" --set mal_listing=0 "--dbinit= include 
sql;" ; echo ; echo Over..
+# 20:28:19 >  
 
-printf("\nReady.\n");
+# MonetDB server v5.9.0, based on kernel v1.27.0
+# Serving database 'mTests_src_test_Triggers', using 4 threads
+# Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs dynamically 
linked
+# Copyright (c) 1993-July 2008 CWI.
+# Copyright (c) August 2008- MonetDB B.V., all rights reserved
+# Visit http://monetdb.cwi.nl/ for further information
+# Listening for connection requests on mapi:monetdb://alf.ins.cwi.nl:35138/
+# MonetDB/SQL module v2.27.0 loaded
 
 Ready.
-quit();
+#function user.main():void;
+#    clients.quit();
+#end main;
 
 Over..
 
@@ -24,14 +28,6 @@
 [ 1    ]
 [ 1    ]
 [ 1    ]
-[ 1    ]
-[ 1    ]
-[ 1    ]
-[ 1    ]
-[ 1    ]
-[ 1    ]
-[ 1    ]
-[ 1    ]
 % sys.t1,      sys.t1 # table_name
 % id,  name # name
 % int, varchar # type
@@ -50,11 +46,6 @@
 [ 1    ]
 [ 1    ]
 [ 1    ]
-[ 1    ]
-[ 1    ]
-[ 1    ]
-[ 1    ]
-[ 1    ]
 % sys.t1,      sys.t1 # table_name
 % id,  name # name
 % int, varchar # type

U trigger_insert.stable.out
Index: trigger_insert.stable.out
===================================================================
RCS file: 
/cvsroot/monetdb/sql/src/test/Triggers/Tests/trigger_insert.stable.out,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- trigger_insert.stable.out   14 Jul 2008 07:58:46 -0000      1.2
+++ trigger_insert.stable.out   21 Dec 2008 19:38:23 -0000      1.3
@@ -25,7 +25,6 @@
 # 20:24:58 >  
 
 [ 1    ]
-[ 1    ]
 % sys.t1,      sys.t1 # table_name
 % id,  name # name
 % int, varchar # type


------------------------------------------------------------------------------
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins

Reply via email to