Update of /cvsroot/monetdb/sql/src/test/BugTracker/Tests
In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv31378
Modified Files:
All
Added Files:
auto_commit.SF-1724151.SQL.py
auto_commit.SF-1724151.stable.err
auto_commit.SF-1724151.stable.out auto_commit.SF-1724151.txt
Log Message:
add test script for auto_commit bug
Index: All
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/BugTracker/Tests/All,v
retrieving revision 1.57
retrieving revision 1.58
diff -u -d -r1.57 -r1.58
--- All 24 May 2007 08:27:38 -0000 1.57
+++ All 29 May 2007 11:58:48 -0000 1.58
@@ -70,3 +70,4 @@
bind_with_cast.SF-1720934
groupby_orderby_nonselected.SF-1723863
rand_not_executed_for_every_row.SF-1723791
+auto_commit.SF-1724151
--- NEW FILE: auto_commit.SF-1724151.SQL.py ---
import os, sys
cltcmd = "%s %s" % (os.getenv('SQL_CLIENT'),
os.path.join(os.getenv('TSTSRCDIR'), sys.argv[1]+".txt"))
os.system(cltcmd);
--- NEW FILE: auto_commit.SF-1724151.stable.err ---
stderr of test 'auto_commit.SF-1724151` in directory 'src/test/BugTracker`
itself:
# 13:54:45 >
# 13:54:45 > Mtimeout -timeout 240 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=31445 --set xrpc_port=44465 --set monet_prompt= --trace
"--dbname=mTests_src_test_BugTracker" --dbinit=" module(sql_server);" ; echo ;
echo Over..
# 13:54:45 >
# 13:54:46 >
# 13:54:46 > Mtimeout -timeout 120 /usr/bin/python
auto_commit.SF-1724151.SQL.py auto_commit.SF-1724151
# 13:54:46 >
# 13:54:46 >
# 13:54:46 > Done.
# 13:54:46 >
--- NEW FILE: auto_commit.SF-1724151.stable.out ---
stdout of test 'auto_commit.SF-1724151` in directory 'src/test/BugTracker`
itself:
# 13:54:45 >
# 13:54:45 > Mtimeout -timeout 240 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=31445 --set xrpc_port=44465 --set monet_prompt= --trace
"--dbname=mTests_src_test_BugTracker" --dbinit=" module(sql_server);" ; echo ;
echo Over..
# 13:54:45 >
# 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..
# 13:54:46 >
# 13:54:46 > Mtimeout -timeout 120 /usr/bin/python
auto_commit.SF-1724151.SQL.py auto_commit.SF-1724151
# 13:54:46 >
[ 1 ]
[ 1 ]
[ 1 ]
[ 1 ]
[ 1 ]
[ 1 ]
[ 1 ]
[ 1 ]
[ 1 ]
[ 1 ]
[ 1 ]
[ 1 ]
% sys.tbl_xy, sys.tbl_xy # table_name
% x, y # name
% int, int # type
% 2, 4 # length
[ 0, 0 ]
[ 1, 1 ]
[ 2, 2 ]
[ 3, 3 ]
[ 4, 4 ]
[ 5, 5 ]
[ 6, 6 ]
[ 7, 7 ]
[ -1, -100 ]
[ 8, 8 ]
[ 9, 9 ]
[ 10, 10 ]
# 13:54:46 >
# 13:54:46 > Done.
# 13:54:46 >
--- NEW FILE: auto_commit.SF-1724151.txt ---
start transaction;
create table tbl_xy (x int , y int);
insert into tbl_xy values (0,0);
insert into tbl_xy values (1,1);
commit;
start transaction;
insert into tbl_xy values (2,2);
insert into tbl_xy values (3,3);
insert into tbl_xy values (4,4);
commit;
start transaction;
insert into tbl_xy values (5,5);
insert into tbl_xy values (6,6);
insert into tbl_xy values (7,7);
commit;
insert into tbl_xy values (-1, -100);
start transaction;
insert into tbl_xy values (8,8);
insert into tbl_xy values (9,9);
insert into tbl_xy values (10,10);
commit;
select * from tbl_xy;
drop table tbl_xy;
-------------------------------------------------------------------------
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
