Update of /cvsroot/monetdb/sql/src/test/BugTracker/Tests
In directory
23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv14693/src/test/BugTracker/Tests
Modified Files:
cardinality_violation.SF-1240701.stable.err.Five
cardinality_violation.SF-1240701.stable.out
rank_over.SF-1691098.stable.out
with_only_once.SF-1720293.stable.out
Log Message:
Commit of the intermediate state of the new history scheme.
The 'patch' to SQL to produces 'times' results have been removed.
The hardwired code and expensive SQL call to update the history
table has been changed into a more open infrastructure that will
rely on an upcall to two SQL procedures that are in control
of filtering and archiving the performance information.
Platform dependent tests may require separate approval.
Stress testing the updates in a parallel (dataflow) setting
is one of the open issues, because some spurious bat leaks
where noticed by playing with the commands in the history.sql
file only.
U with_only_once.SF-1720293.stable.out
Index: with_only_once.SF-1720293.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker/Tests/with_only_once.SF-1720293.stable.out,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- with_only_once.SF-1720293.stable.out 7 Sep 2008 14:28:15 -0000
1.2
+++ with_only_once.SF-1720293.stable.out 3 Nov 2008 15:32:05 -0000
1.3
@@ -28,12 +28,12 @@
% count_ # name
% wrd # type
% 2 # length
-[ 27 ]
+[ 26 ]
% .t # table_name
% count_ # name
% wrd # type
% 2 # length
-[ 27 ]
+[ 26 ]
# 22:41:45 >
# 22:41:45 > Done.
U cardinality_violation.SF-1240701.stable.out
Index: cardinality_violation.SF-1240701.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker/Tests/cardinality_violation.SF-1240701.stable.out,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- cardinality_violation.SF-1240701.stable.out 22 Dec 2005 13:33:28 -0000
1.2
+++ cardinality_violation.SF-1240701.stable.out 3 Nov 2008 15:32:05 -0000
1.3
@@ -1,19 +1,23 @@
stdout of test 'cardinality_violation.SF-1240701` in directory
'src/test/BugTracker` itself:
-# 12:47:42 >
-# 12:47:42 > Mtimeout -timeout 180 Mserver
"--config=/ufs/fabian/scratch/monetdb/current/program-x86_64/etc/MonetDB.conf"
--debug=10 --set
"monet_mod_path=/ufs/fabian/scratch/monetdb/current/program-x86_64/lib/MonetDB:/ufs/fabian/scratch/monetdb/current/program-x86_64/lib/bin"
--set
"gdk_dbfarm=/ufs/fabian/scratch/monetdb/current/program-x86_64/var/MonetDB/dbfarm"
--set
"sql_logdir=/ufs/fabian/scratch/monetdb/current/program-x86_64/var/MonetDB/log"
--set mapi_port=38933 --set sql_port=45579 --set xquery_port=52530 --set
monet_prompt= --trace "--dbname=mTests_src_test_BugTracker"
--dbinit="module(sql_server); sql_server_start();" ; echo ; echo Over..
-# 12:47:42 >
-
-# Monet Database Server V4.9.3
-# Copyright (c) 1993-2005, 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.
+# 10:04:53 >
+# 10:04:53 > mserver5 "--config=/ufs/mk/monet5//Linux/etc/monetdb5.conf"
--debug=10 --set gdk_nr_threads=0 --set
"monet_mod_path=/ufs/mk/monet5//Linux/lib/MonetDB5:/ufs/mk/monet5//Linux/lib/MonetDB5/lib:/ufs/mk/monet5//Linux/lib/MonetDB5/bin"
--set "gdk_dbfarm=/ufs/mk/monet5//Linux/var/MonetDB5/dbfarm" --set
"sql_logdir=/ufs/mk/monet5//Linux/var/MonetDB5/sql_logs" --set mapi_open=true
--set xrpc_open=true --set mapi_port=34031 --set xrpc_port=43786 --set
monet_prompt= --trace "--dbname=mTests_src_test_BugTracker" --set
mal_listing=0 "--dbinit= include sql;" ; echo ; echo Over..
+# 10:04:53 >
-printf("\nReady.\n");
+# MonetDB server v5.7.0, based on kernel v1.25.0
+# Serving database 'mTests_src_test_BugTracker', 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://eir.ins.cwi.nl:34031/
+# MonetDB/SQL module v2.25.0 loaded
Ready.
-quit();
+#function user.main():void;
+# clients.quit();
+#end main;
Over..
U rank_over.SF-1691098.stable.out
Index: rank_over.SF-1691098.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker/Tests/rank_over.SF-1691098.stable.out,v
retrieving revision 1.5
retrieving revision 1.6
diff -u -d -r1.5 -r1.6
--- rank_over.SF-1691098.stable.out 18 Feb 2008 10:52:10 -0000 1.5
+++ rank_over.SF-1691098.stable.out 3 Nov 2008 15:32:05 -0000 1.6
@@ -1,21 +1,23 @@
stdout of test 'rank_over.SF-1691098` in directory 'src/test/BugTracker`
itself:
-# 22:16:53 >
-# 22:16:53 > 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=38697 --set
xrpc_port=43628 --set monet_prompt= --trace
"--dbname=mTests_src_test_BugTracker" "--dbinit= module(sql_server);" ; echo ;
echo Over..
-# 22:16:53 >
-
-# MonetDB Server v4.23.0
-# based on GDK v1.23.0
-# Copyright (c) 1993-2008, CWI. All rights reserved.
-# Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs; dynamically
linked.
-# Visit http://monetdb.cwi.nl/ for further information.
-# MonetDB/SQL module v2.23.0 loaded
+# 10:05:10 >
+# 10:05:10 > mserver5 "--config=/ufs/mk/monet5//Linux/etc/monetdb5.conf"
--debug=10 --set gdk_nr_threads=0 --set
"monet_mod_path=/ufs/mk/monet5//Linux/lib/MonetDB5:/ufs/mk/monet5//Linux/lib/MonetDB5/lib:/ufs/mk/monet5//Linux/lib/MonetDB5/bin"
--set "gdk_dbfarm=/ufs/mk/monet5//Linux/var/MonetDB5/dbfarm" --set
"sql_logdir=/ufs/mk/monet5//Linux/var/MonetDB5/sql_logs" --set mapi_open=true
--set xrpc_open=true --set mapi_port=34031 --set xrpc_port=43786 --set
monet_prompt= --trace "--dbname=mTests_src_test_BugTracker" --set
mal_listing=0 "--dbinit= include sql;" ; echo ; echo Over..
+# 10:05:10 >
-printf("\nReady.\n");
+# MonetDB server v5.7.0, based on kernel v1.25.0
+# Serving database 'mTests_src_test_BugTracker', 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://eir.ins.cwi.nl:34031/
+# MonetDB/SQL module v2.25.0 loaded
Ready.
-quit();
+#function user.main():void;
+# clients.quit();
+#end main;
Over..
@@ -53,7 +55,6 @@
[ 24 ]
[ 25 ]
[ 26 ]
-[ 27 ]
# 11:52:56 >
# 11:52:56 > Done.
U cardinality_violation.SF-1240701.stable.err.Five
Index: cardinality_violation.SF-1240701.stable.err.Five
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker/Tests/cardinality_violation.SF-1240701.stable.err.Five,v
retrieving revision 1.21
retrieving revision 1.22
diff -u -d -r1.21 -r1.22
--- cardinality_violation.SF-1240701.stable.err.Five 22 Jul 2008 17:18:43
-0000 1.21
+++ cardinality_violation.SF-1240701.stable.err.Five 3 Nov 2008 15:32:05
-0000 1.22
@@ -12,12 +12,11 @@
# 23:15:14 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=corona --port=36535
# 23:15:14 >
-MAPI = [EMAIL PROTECTED]:30674
+MAPI = [EMAIL PROTECTED]:34031
QUERY = select * from env() as env where name = ( select 'prefix' from env()
as env );
ERROR = !SQLException:zero_or_one:cardinality violation (46>1)
-MAPI = [EMAIL PROTECTED]:30674
+MAPI = [EMAIL PROTECTED]:34031
QUERY = select * from columns where name = (select columns.name from _tables,
columns where _tables.id = columns.table_id);
-ERROR = !SQLException:zero_or_one:cardinality violation (171>1)
# 23:24:25 >
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
