Update of /cvsroot/monetdb/sql/src/test/BugDay_2005-11-09_2.9.3/Tests
In directory
sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv17226/src/test/BugDay_2005-11-09_2.9.3/Tests
Modified Files:
history_table_escape.SF-1072089.sql
history_table_escape.SF-1072089.stable.out
Log Message:
removed 'explain' variable, ie no more set explain etc
but always use the statement modifiers debug, explain, profile
profile now only outputs the real, user and clk ticks per sec.
The old profile functionality is taken over by a new statement modifier
'record'
U history_table_escape.SF-1072089.sql
Index: history_table_escape.SF-1072089.sql
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugDay_2005-11-09_2.9.3/Tests/history_table_escape.SF-1072089.sql,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- history_table_escape.SF-1072089.sql 27 Nov 2005 22:25:15 -0000 1.2
+++ history_table_escape.SF-1072089.sql 1 Apr 2008 17:05:04 -0000 1.3
@@ -1,7 +1,6 @@
START TRANSACTION;
-SET explain='profile';
-DELETE FROM profile;
-SELECT 1;
-SELECT 'test';
-SELECT query FROM profile;
+DELETE FROM history;
+record SELECT 1;
+record SELECT 'test';
+SELECT query FROM history;
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.5
retrieving revision 1.6
diff -u -d -r1.5 -r1.6
--- history_table_escape.SF-1072089.stable.out 29 Jun 2007 11:29:19 -0000
1.5
+++ history_table_escape.SF-1072089.stable.out 1 Apr 2008 17:05:06 -0000
1.6
@@ -1,19 +1,22 @@
stdout of test 'history_table_escape.SF-1072089` in directory
'src/test/BugDay_2005-11-09_2.9.3` itself:
-# 15:49:17 >
-# 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 >
-
-# 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.
+# 12:57:44 >
+# 12:57:44 > mserver5
"--config=/ufs/niels/scratch/monetdb/Linux-x86_64/etc/monetdb5.conf" --debug=10
--set
"monet_mod_path=/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB5:/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB5/lib:/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB5/bin"
--set "gdk_dbfarm=/ufs/niels/scratch/monetdb/Linux-x86_64/var/MonetDB5/dbfarm"
--set
"sql_logdir=/ufs/niels/scratch/monetdb/Linux-x86_64/var/MonetDB5/sql_logs"
--set mapi_open=true --set xrpc_open=true --set mapi_port=31247 --set
xrpc_port=46133 --set monet_prompt= --trace
"--dbname=mTests_src_test_BugDay_2005-11-09_2.9.3" --set mal_listing=0
"--dbinit= include sql;" ; echo ; echo Over..
+# 12:57:44 >
-printf("\nReady.\n");
+# MonetDB server v5.5.0, based on kernel v1.23.0
+# Serving database 'mTests_src_test_BugDay_2005-11-09_2.9.3'
+# Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs dynamically
linked
+# Copyright (c) 1993-2008 CWI, all rights reserved
+# Visit http://monetdb.cwi.nl/ for further information
+# Listening for connection requests on mapi:monetdb://koala.ins.cwi.nl:31247/
+# MonetDB/SQL module v2.23.0 loaded
Ready.
-quit();
+#function user.main():void;
+# clients.quit();
+#end main;
Over..
@@ -32,11 +35,10 @@
% char # type
% 4 # length
[ "test" ]
-% tmp.profile # table_name
+% tmp.history # table_name
% query # name
% varchar # type
-% 20 # length
-[ "delete from profile;" ]
+% 14 # length
[ "select 1;" ]
[ "select 'test';" ]
-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
