Update of /cvsroot/monetdb/sql/src/test/BugDay_2005-11-09_2.9.3/Tests
In directory
23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv14693/src/test/BugDay_2005-11-09_2.9.3/Tests
Modified Files:
history_table_escape.SF-1072089.stable.err
history_table_escape.SF-1072089.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 history_table_escape.SF-1072089.stable.err
Index: history_table_escape.SF-1072089.stable.err
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugDay_2005-11-09_2.9.3/Tests/history_table_escape.SF-1072089.stable.err,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- history_table_escape.SF-1072089.stable.err 26 Jan 2008 13:39:11 -0000
1.2
+++ history_table_escape.SF-1072089.stable.err 3 Nov 2008 15:32:05 -0000
1.3
@@ -5,10 +5,18 @@
# 15:49:17 > 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=30547 --set sql_port=44105 --set xquery_port=50414 --set
monet_prompt= --trace "--dbname=mTests_src_test_BugDay_2005-11-09_2.9.3"
--dbinit="module(sql_server); sql_server_start();" ; echo ; echo Over..
# 15:49:17 >
-
-# 15:49:19 >
-# 15:49:19 > Mtimeout -timeout 60 MapiClient -lsql -u monetdb -P monetdb
--host=localhost --port=44105 < history_table_escape.SF-1072089.sql
-# 15:49:19 >
+MAPI = [EMAIL PROTECTED]:36778
+QUERY = DELETE FROM history;
+ERROR = !DELETE FROM: no such table 'history'
+MAPI = [EMAIL PROTECTED]:36778
+QUERY = record SELECT 1;
+ERROR = !current transaction is aborted (please ROLLBACK)
+MAPI = [EMAIL PROTECTED]:36778
+QUERY = record SELECT 'test';
+ERROR = !current transaction is aborted (please ROLLBACK)
+MAPI = [EMAIL PROTECTED]:36778
+QUERY = SELECT query FROM history;
+ERROR = !current transaction is aborted (please ROLLBACK)
# 15:49:19 >
U history_table_escape.SF-1072089.stable.out
Index: history_table_escape.SF-1072089.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugDay_2005-11-09_2.9.3/Tests/history_table_escape.SF-1072089.stable.out,v
retrieving revision 1.6
retrieving revision 1.7
diff -u -d -r1.6 -r1.7
--- history_table_escape.SF-1072089.stable.out 1 Apr 2008 17:05:06 -0000
1.6
+++ history_table_escape.SF-1072089.stable.out 3 Nov 2008 15:32:05 -0000
1.7
@@ -20,29 +20,12 @@
Over..
-# 15:49:19 >
-# 15:49:19 > Mtimeout -timeout 60 MapiClient -lsql -u monetdb -P monetdb
--host=localhost --port=44105 < history_table_escape.SF-1072089.sql
-# 15:49:19 >
+# 10:04:46 >
+# 10:04:46 > mclient -lsql -umonetdb -Pmonetdb --host=eir --port=34031
+# 10:04:46 >
-[ 0 ]
-% . # table_name
-% single_value # name
-% tinyint # type
-% 1 # length
-[ 1 ]
-% . # table_name
-% single_value # name
-% char # type
-% 4 # length
-[ "test" ]
-% tmp.history # table_name
-% query # name
-% varchar # type
-% 14 # length
-[ "select 1;" ]
-[ "select 'test';" ]
-# 15:50:27 >
-# 15:50:27 > Done.
-# 15:50:27 >
+# 10:04:46 >
+# 10:04:46 > Done.
+# 10:04:46 >
-------------------------------------------------------------------------
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
