Update of /cvsroot/monetdb/sql/src/test/BugTracker/Tests
In directory sc8-pr-cvs16:/tmp/cvs-serv29919/Tests
Modified Files:
All
Added Files:
crash_on_fkey_update2.SF-1703497.sql
crash_on_fkey_update2.SF-1703497.stable.err
crash_on_fkey_update2.SF-1703497.stable.out
Log Message:
add test for crash on fkey update test (now in a single transaction)
--- NEW FILE: crash_on_fkey_update2.SF-1703497.stable.out ---
stdout of test 'crash_on_fkey_update2.SF-1703497` in directory
'src/test/BugTracker` itself:
# 22:42:12 >
# 22:42:12 > Mtimeout -timeout 180 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_port=33006 --set xrpc_port=41894 --set monet_prompt= --trace
"--dbname=mTests_src_test_BugTracker" --dbinit=" module(sql_server);" ; echo ;
echo Over..
# 22:42:12 >
# Monet Database Server V4.17.1
# 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.
printf("\nReady.\n");
Ready.
quit();
Over..
# 22:42:12 >
# 22:42:12 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=33006
# 22:42:12 >
[ 1 ]
[ 1 ]
# 22:42:12 >
# 22:42:12 > Done.
# 22:42:12 >
--- NEW FILE: crash_on_fkey_update2.SF-1703497.sql ---
START TRANSACTION;
create table t1 (id int, name varchar(1024), PRIMARY KEY(id));
create table t2 (id int, age int, FOREIGN KEY(id) REFERENCES t1(id));
insert into t1 values(3, 'monb');
insert into t2 values(3, 25);
update t2 set id = 10 where id =3;
drop table t2;
drop table t1;
COMMIT;
Index: All
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/BugTracker/Tests/All,v
retrieving revision 1.51
retrieving revision 1.52
diff -u -d -r1.51 -r1.52
--- All 13 May 2007 18:09:58 -0000 1.51
+++ All 13 May 2007 20:44:07 -0000 1.52
@@ -52,6 +52,7 @@
like_join.SF-1684798
prepare_decimal_float.SF-1675795
crash_on_fkey_update.SF-1703497
+crash_on_fkey_update2.SF-1703497
variable_stack_crash_load.SF-1711251
range_predicate.SF-1711242
variable_stack_crash.SF-1711251
--- NEW FILE: crash_on_fkey_update2.SF-1703497.stable.err ---
stderr of test 'crash_on_fkey_update2.SF-1703497` in directory
'src/test/BugTracker` itself:
# 22:42:12 >
# 22:42:12 > Mtimeout -timeout 180 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_port=33006 --set xrpc_port=41894 --set monet_prompt= --trace
"--dbname=mTests_src_test_BugTracker" --dbinit=" module(sql_server);" ; echo ;
echo Over..
# 22:42:12 >
# 22:42:12 >
# 22:42:12 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=33006
# 22:42:12 >
MAPI = [EMAIL PROTECTED]:33006
QUERY = update t2 set id = 10 where id =3;
ERROR = !ERROR: UPDATE: FOREIGN KEY constraint 't2.t2_id_fkey' violated
MAPI = [EMAIL PROTECTED]:33006
QUERY = drop table t2;
ERROR = !current transaction is aborted (please ROLLBACK)
MAPI = [EMAIL PROTECTED]:33006
QUERY = drop table t1;
ERROR = !current transaction is aborted (please ROLLBACK)
MAPI = [EMAIL PROTECTED]:33006
QUERY = COMMIT;
ERROR = !COMMIT: failed
!ERROR: COMMIT: transaction is aborted, will ROLLBACK instead
# 22:42:12 >
# 22:42:12 > Done.
# 22:42:12 >
-------------------------------------------------------------------------
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
