Update of /cvsroot/monetdb/sql/src/test/DropCascade/Tests
In directory sc8-pr-cvs16:/tmp/cvs-serv32257
Modified Files:
drop_columns_cascade.sql drop_function_cascade.sql
drop_function_cascade.stable.out drop_pkey_cascade.sql
drop_table_cascade.sql drop_view_cascade.sql
drop_view_cascade.stable.out
Added Files:
drop_columns_cascade.stable.err
drop_columns_cascade.stable.out drop_pkey_cascade.stable.err
drop_pkey_cascade.stable.out drop_table_cascade.stable.err
drop_table_cascade.stable.out
Log Message:
Approve all the DROP CASCADE tests. The tests were also modified to avoid
problems in the output due the different ids in each Mtest execution...
--- NEW FILE: drop_pkey_cascade.stable.err ---
stderr of test 'drop_pkey_cascade` in directory 'src/test/DropCascade` itself:
# 18:02:01 >
# 18:02:01 > 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=39789 --set xrpc_port=40365 --set monet_prompt= --trace
"--dbname=mTests_src_test_DropCascade" --dbinit='include sql;' ; echo ; echo
Over..
# 18:02:01 >
# builtin opt gdk_arch = 64bitx86_64-redhat-linux-gnu
# builtin opt gdk_version = 1.17.1
# builtin opt monet_pid = 23640
# 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/MonetDB5
# config opt config = ${prefix}/etc/monetdb5.conf
# config opt prefix = /ufs/goncalve/scratch/MonetDB/MonetDB5
# config opt exec_prefix = ${prefix}
# config opt gdk_dbfarm = ${prefix}/var/MonetDB5/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_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 sql_debug = 0
# config opt sql_logdir = ${prefix}/var/MonetDB5/sql_logs
# config opt pf_httpd_port = 8080
# 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
# 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 = 39789
# cmdline opt xrpc_port = 40365
# cmdline opt monet_prompt =
# cmdline opt gdk_dbname = mTests_src_test_DropCascade
#warning: please don't forget to set your vault key!
#(see /ufs/goncalve/scratch/MonetDB/MonetDB5/etc/monetdb5.conf)
# 18:02:01 >
# 18:02:01 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=39789
# 18:02:01 >
# 18:02:01 >
# 18:02:01 > Done.
# 18:02:01 >
--- NEW FILE: drop_pkey_cascade.stable.out ---
stdout of test 'drop_pkey_cascade` in directory 'src/test/DropCascade` itself:
# 18:05:38 >
# 18:05:38 > 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=32855 --set xrpc_port=49681 --set monet_prompt= --trace
"--dbname=mTests_src_test_DropCascade" --dbinit='include sql;' ; echo ; echo
Over..
# 18:05:38 >
# 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_DropCascade
# Visit http://monetdb.cwi.nl/ for further information
Ready.
#01 #BBPdir: writing BBP.dir (515 bats).
Over..
# 18:05:38 >
# 18:05:38 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=32855
# 18:05:38 >
% sys.tables # table_name
% name # name
% varchar # type
% 2 # length
[ "t1" ]
% sys.tables # table_name
% name # name
% varchar # type
% 2 # length
[ "t2" ]
% sys.keys # table_name
% name # name
% varchar # type
% 10 # length
[ "t2_id_pkey" ]
# 18:05:38 >
# 18:05:38 > Done.
# 18:05:38 >
--- NEW FILE: drop_table_cascade.stable.out ---
stdout of test 'drop_table_cascade` in directory 'src/test/DropCascade` itself:
# 18:02:48 >
# 18:02:48 > 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=37174 --set xrpc_port=40727 --set monet_prompt= --trace
"--dbname=mTests_src_test_DropCascade" --dbinit='include sql;' ; echo ; echo
Over..
# 18:02:48 >
# 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_DropCascade
# Visit http://monetdb.cwi.nl/ for further information
Ready.
#01 #BBPdir: writing BBP.dir (515 bats).
Over..
# 18:02:48 >
# 18:02:48 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=37174
# 18:02:48 >
% sys.tables # table_name
% name # name
% varchar # type
% 0 # length
% sys.tables # table_name
% name # name
% varchar # type
% 2 # length
[ "t2" ]
% sys.tables # table_name
% name # name
% varchar # type
% 0 # length
% sys.triggers # table_name
% name # name
% varchar # type
% 0 # length
% sys.functions # table_name
% name # name
% varchar # type
% 0 # length
% sys.idxs # table_name
% name # name
% varchar # type
% 0 # length
# 18:02:48 >
# 18:02:48 > Done.
# 18:02:48 >
--- NEW FILE: drop_columns_cascade.stable.out ---
stdout of test 'drop_columns_cascade` in directory 'src/test/DropCascade`
itself:
# 18:11:53 >
# 18:11:53 > 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=36316 --set xrpc_port=46231 --set monet_prompt= --trace
"--dbname=mTests_src_test_DropCascade" --dbinit='include sql;' ; echo ; echo
Over..
# 18:11:53 >
# 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_DropCascade
# Visit http://monetdb.cwi.nl/ for further information
#01 #BBPdir: writing BBP.dir (8 bats).
Ready.
#01 #BBPdir: writing BBP.dir (10 bats).
#01 #BBPdir: writing BBP.dir (12 bats).
#01 #BBPdir: writing BBP.dir (676 bats).
Over..
# 18:11:53 >
# 18:11:53 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=36316
# 18:11:53 >
#02 #BBPdir: writing BBP.dir (787 bats).
#02 #BBPdir: writing BBP.dir (823 bats).
% sys.tables # table_name
% name # name
% varchar # type
% 2 # length
[ "t1" ]
% sys.tables # table_name
% name # name
% varchar # type
% 2 # length
[ "t2" ]
% sys.tables # table_name
% name # name
% varchar # type
% 0 # length
% sys.functions # table_name
% name # name
% varchar # type
% 0 # length
% sys.triggers # table_name
% name # name
% varchar # type
% 0 # length
% sys.idxs # table_name
% name # name
% varchar # type
% 0 # length
% sys.columns # table_name
% name # name
% varchar # type
% 2 # length
[ "id" ]
% sys.keys # table_name
% name # name
% varchar # type
% 10 # length
[ "t2_id_pkey" ]
# 18:11:53 >
# 18:11:53 > Done.
# 18:11:53 >
--- NEW FILE: drop_columns_cascade.stable.err ---
stderr of test 'drop_columns_cascade` in directory 'src/test/DropCascade`
itself:
# 15:54:00 >
# 15:54:00 > 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=35023 --set xrpc_port=43546 --set monet_prompt= --trace
"--dbname=mTests_src_test_DropCascade" --dbinit='include sql;' ; echo ; echo
Over..
# 15:54:00 >
# builtin opt gdk_arch = 64bitx86_64-redhat-linux-gnu
# builtin opt gdk_version = 1.17.1
# builtin opt monet_pid = 30909
# 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/MonetDB5
# config opt config = ${prefix}/etc/monetdb5.conf
# config opt prefix = /ufs/goncalve/scratch/MonetDB/MonetDB5
# config opt exec_prefix = ${prefix}
# config opt gdk_dbfarm = ${prefix}/var/MonetDB5/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_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 sql_debug = 0
# config opt sql_logdir = ${prefix}/var/MonetDB5/sql_logs
# config opt pf_httpd_port = 8080
# 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
# 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 = 35023
# cmdline opt xrpc_port = 43546
# cmdline opt monet_prompt =
# cmdline opt gdk_dbname = mTests_src_test_DropCascade
#warning: please don't forget to set your vault key!
#(see /ufs/goncalve/scratch/MonetDB/MonetDB5/etc/monetdb5.conf)
# 15:54:00 >
# 15:54:00 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=35023
# 15:54:00 >
# 15:54:01 >
# 15:54:01 > Done.
# 15:54:01 >
Index: drop_view_cascade.sql
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/DropCascade/Tests/drop_view_cascade.sql,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -d -r1.1 -r1.2
--- drop_view_cascade.sql 3 Apr 2007 13:42:32 -0000 1.1
+++ drop_view_cascade.sql 16 Apr 2007 16:14:42 -0000 1.2
@@ -37,8 +37,17 @@
drop view v1 cascade;
-select * from tables where name = 'v1';
-select * from tables where name = 'v2';
-select * from functions where name = 'f2';
+select name from tables where name = 'v1';
+select name from tables where name = 'v2';
+select name from functions where name = 'f2';
+
+--just for debug
+--select * from dependencies;
+
+
+drop function f1;
+drop table t1;
+
+--just for debug
+--select * from dependencies;
-select * from dependencies;
--- NEW FILE: drop_table_cascade.stable.err ---
stderr of test 'drop_table_cascade` in directory 'src/test/DropCascade` itself:
# 18:02:01 >
# 18:02:01 > 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=39789 --set xrpc_port=40365 --set monet_prompt= --trace
"--dbname=mTests_src_test_DropCascade" --dbinit='include sql;' ; echo ; echo
Over..
# 18:02:01 >
# builtin opt gdk_arch = 64bitx86_64-redhat-linux-gnu
# builtin opt gdk_version = 1.17.1
# builtin opt monet_pid = 23652
# 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/MonetDB5
# config opt config = ${prefix}/etc/monetdb5.conf
# config opt prefix = /ufs/goncalve/scratch/MonetDB/MonetDB5
# config opt exec_prefix = ${prefix}
# config opt gdk_dbfarm = ${prefix}/var/MonetDB5/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_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 sql_debug = 0
# config opt sql_logdir = ${prefix}/var/MonetDB5/sql_logs
# config opt pf_httpd_port = 8080
# 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
# 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 = 39789
# cmdline opt xrpc_port = 40365
# cmdline opt monet_prompt =
# cmdline opt gdk_dbname = mTests_src_test_DropCascade
#warning: please don't forget to set your vault key!
#(see /ufs/goncalve/scratch/MonetDB/MonetDB5/etc/monetdb5.conf)
# 18:02:01 >
# 18:02:01 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=39789
# 18:02:01 >
# 18:02:02 >
# 18:02:02 > Done.
# 18:02:02 >
Index: drop_table_cascade.sql
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/DropCascade/Tests/drop_table_cascade.sql,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -d -r1.1 -r1.2
--- drop_table_cascade.sql 3 Apr 2007 13:42:32 -0000 1.1
+++ drop_table_cascade.sql 16 Apr 2007 16:14:40 -0000 1.2
@@ -39,14 +39,23 @@
CREATE INDEX id_index ON t1(id);
+--just for debug
+--select * from dependencies;
+
DROP TABLE t1 CASCADE;
-select * from tables where name = 't1';
-select * from tables where name = 't2';
-select * from tables where name = 'v1';
-select * from triggers where name = 'test1';
-select * from functions where name = 'f2';
-select * from idxs where name = 'id_index';
+select name from tables where name = 't1';
+select name from tables where name = 't2';
+select name from tables where name = 'v1';
+select name from triggers where name = 'test1';
+select name from functions where name = 'f2';
+select name from idxs where name = 'id_index';
-select * from dependencies;
+--just for debug
+--select * from dependencies;
+
+drop function f1;
+drop table t2;
+--just for debug
+--select * from dependencies;
Index: drop_columns_cascade.sql
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/DropCascade/Tests/drop_columns_cascade.sql,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -d -r1.1 -r1.2
--- drop_columns_cascade.sql 3 Apr 2007 13:42:32 -0000 1.1
+++ drop_columns_cascade.sql 16 Apr 2007 16:14:36 -0000 1.2
@@ -41,12 +41,22 @@
ALTER TABLE t1 DROP COLUMN id CASCADE;
-select * from tables where name = 't1';
-select * from tables where name = 't2';
-select * from tables where name = 'v1';
-select * from functions where name = 'f2';
-select * from triggers where name = 'test1';
-select * from idxs where name = 'id_index';
+select name from tables where name = 't1';
+select name from tables where name = 't2';
+select name from tables where name = 'v1';
+select name from functions where name = 'f2';
+select name from triggers where name = 'test1';
+select name from idxs where name = 'id_index';
+select name from columns where name = 'id' and table_id in (select * from
tables where name = 't1' or name = 't2');
+select name from keys;
-select * from dependencies;
+--Just for debug
+--select * from dependencies;
+
+drop table t1;
+drop table t2;
+drop function f1;
+
+--Just for debug
+--select * from dependencies;
Index: drop_view_cascade.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/DropCascade/Tests/drop_view_cascade.stable.out,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -d -r1.1 -r1.2
--- drop_view_cascade.stable.out 12 Apr 2007 14:57:05 -0000 1.1
+++ drop_view_cascade.stable.out 16 Apr 2007 16:14:42 -0000 1.2
@@ -21,34 +21,24 @@
Over..
-# 16:55:15 >
-# 16:55:15 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=35276
-# 16:55:15 >
+# 18:02:49 >
+# 18:02:49 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=37174
+# 18:02:49 >
-#02 #BBPdir: writing BBP.dir (798 bats).
-% sys.tables, sys.tables, sys.tables, sys.tables, sys.tables,
sys.tables, sys.tables, sys.tables # table_name
-% id, name, schema_id, query, type, system, commit_action,
temporary # name
-% int, varchar, int, varchar, smallint, boolean,
smallint, smallint # type
-% 1, 0, 1, 0, 1, 5, 1, 1 # length
-% sys.tables, sys.tables, sys.tables, sys.tables, sys.tables,
sys.tables, sys.tables, sys.tables # table_name
-% id, name, schema_id, query, type, system, commit_action,
temporary # name
-% int, varchar, int, varchar, smallint, boolean,
smallint, smallint # type
-% 1, 0, 1, 0, 1, 5, 1, 1 # length
-% sys.functions, sys.functions, sys.functions, sys.functions,
sys.functions, sys.functions, sys.functions # table_name
-% id, name, func, mod, sql, aggr, schema_id # name
-% int, varchar, varchar, varchar, boolean,
boolean, int # type
-% 1, 0, 0, 0, 5, 5, 1 # length
-% sys.dependencies, sys.dependencies, sys.dependencies # table_name
-% id, depend_id, depend_type # name
-% int, int, smallint # type
-% 3, 4, 1 # length
-[ 126, 4801, 7 ]
-% sys.dependencies, sys.dependencies, sys.dependencies # table_name
-% id, depend_id, depend_type # name
-% int, int, smallint # type
-% 1, 1, 1 # length
+% sys.tables # table_name
+% name # name
+% varchar # type
+% 0 # length
+% sys.tables # table_name
+% name # name
+% varchar # type
+% 0 # length
+% sys.functions # table_name
+% name # name
+% varchar # type
+% 0 # length
-# 16:55:15 >
-# 16:55:15 > Done.
-# 16:55:15 >
+# 18:02:49 >
+# 18:02:49 > Done.
+# 18:02:49 >
Index: drop_function_cascade.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/DropCascade/Tests/drop_function_cascade.stable.out,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -d -r1.1 -r1.2
--- drop_function_cascade.stable.out 12 Apr 2007 14:54:14 -0000 1.1
+++ drop_function_cascade.stable.out 16 Apr 2007 16:14:38 -0000 1.2
@@ -19,43 +19,30 @@
Over..
-# 17:28:07 >
-# 17:28:07 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=30730
-# 17:28:07 >
+# 18:06:32 >
+# 18:06:32 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=31889
+# 18:06:32 >
-% sys.tables, sys.tables, sys.tables, sys.tables, sys.tables,
sys.tables, sys.tables, sys.tables # table_name
-% id, name, schema_id, query, type, system, commit_action,
temporary # name
-% int, varchar, int, varchar, smallint, boolean,
smallint, smallint # type
-% 4, 2, 4, 1, 1, 5, 1, 1 # length
-[ 4793, "t1", 4585, NULL, 0, false, 0, 0 ]
-% sys.tables, sys.tables, sys.tables, sys.tables, sys.tables,
sys.tables, sys.tables, sys.tables # table_name
-% id, name, schema_id, query, type, system, commit_action,
temporary # name
-% int, varchar, int, varchar, smallint, boolean,
smallint, smallint # type
-% 4, 2, 4, 35, 1, 5, 1, 1 # length
-[ 4799, "v1", 4585, "create view v1 as select * from t1;", 1,
false, 0, 0 ]
-% sys.functions, sys.functions, sys.functions, sys.functions,
sys.functions, sys.functions, sys.functions # table_name
-% id, name, func, mod, sql, aggr, schema_id # name
-% int, varchar, varchar, varchar, boolean,
boolean, int # type
-% 1, 0, 0, 0, 5, 5, 1 # length
-% sys.functions, sys.functions, sys.functions, sys.functions,
sys.functions, sys.functions, sys.functions # table_name
-% id, name, func, mod, sql, aggr, schema_id # name
-% int, varchar, varchar, varchar, boolean,
boolean, int # type
-% 1, 0, 0, 0, 5, 5, 1 # length
-% sys.dependencies, sys.dependencies, sys.dependencies # table_name
-% id, depend_id, depend_type # name
-% int, int, smallint # type
-% 4, 4, 1 # length
-[ 4794, 4797, 4 ]
-[ 4794, 4799, 5 ]
-[ 4793, 4799, 5 ]
-[ 4795, 4799, 5 ]
-[ 4796, 4799, 5 ]
-% sys.dependencies, sys.dependencies, sys.dependencies # table_name
-% id, depend_id, depend_type # name
-% int, int, smallint # type
-% 1, 1, 1 # length
+% sys.tables # table_name
+% name # name
+% varchar # type
+% 2 # length
+[ "t1" ]
+% sys.tables # table_name
+% name # name
+% varchar # type
+% 2 # length
+[ "v1" ]
+% sys.functions # table_name
+% name # name
+% varchar # type
+% 0 # length
+% sys.functions # table_name
+% name # name
+% varchar # type
+% 0 # length
-# 17:28:07 >
-# 17:28:07 > Done.
-# 17:28:07 >
+# 18:06:32 >
+# 18:06:32 > Done.
+# 18:06:32 >
Index: drop_pkey_cascade.sql
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/DropCascade/Tests/drop_pkey_cascade.sql,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -d -r1.1 -r1.2
--- drop_pkey_cascade.sql 3 Apr 2007 13:42:32 -0000 1.1
+++ drop_pkey_cascade.sql 16 Apr 2007 16:14:38 -0000 1.2
@@ -3,11 +3,19 @@
create table t2 (id int, age int, PRIMARY KEY (ID), FOREIGN KEY(id) REFERENCES
t1(id));
-ALTER TABLE t1 DROP CONSTRAINT t1_id_pkey;
+ALTER TABLE t1 DROP CONSTRAINT t1_id_pkey CASCADE;
-select * from tables where name = 't1';
-select * from tables where name = 't2';
-select * from keys where name = 't1_id_pkey';
+select name from tables where name = 't1';
+select name from tables where name = 't2';
+select name from keys;
+
+--just for debug
+--select * from dependencies;
+
+drop table t1;
+drop table t2;
+
+--just for debug
+--select * from dependencies;
-select * from dependencies;
Index: drop_function_cascade.sql
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/DropCascade/Tests/drop_function_cascade.sql,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -d -r1.1 -r1.2
--- drop_function_cascade.sql 3 Apr 2007 13:42:32 -0000 1.1
+++ drop_function_cascade.sql 16 Apr 2007 16:14:37 -0000 1.2
@@ -34,9 +34,15 @@
DROP FUNCTION f1 CASCADE;
-select * from tables where name = 't1';
-select * from tables where name = 'v1';
-select * from functions where name = 'f1';
-select * from functions where name = 'f2';
+select name from tables where name = 't1';
+select name from tables where name = 'v1';
+select name from functions where name = 'f1';
+select name from functions where name = 'f2';
-select * from dependencies;
+--just for debug
+--select * from dependencies;
+
+drop table t1 cascade;
+
+--just for debug
+--select * from dependencies;
-------------------------------------------------------------------------
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
