Update of /cvsroot/monetdb/sql/src/test/Tests
In directory sfp-cvsdas-1.v30.ch3.sourceforge.com:/tmp/cvs-serv12763
Modified Files:
Tag: Nov2009
trace.sql
Log Message:
Add definition of the tracelog function.
Index: trace.sql
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/Tests/Attic/trace.sql,v
retrieving revision 1.1.2.1
retrieving revision 1.1.2.2
diff -u -d -r1.1.2.1 -r1.1.2.2
--- trace.sql 19 Nov 2009 10:30:32 -0000 1.1.2.1
+++ trace.sql 25 Nov 2009 09:40:04 -0000 1.1.2.2
@@ -1,4 +1,20 @@
set trace = 'none'; -- non-documented feature to not get any trace output
+create function tracelog()
+ returns table (
+ event integer, -- event counter
+ clk varchar(20), -- wallclock, no mtime in kernel
+ pc varchar(50), -- module.function[nr]
+ thread int, -- thread identifier
+ ticks integer, -- time in microseconds
+ reads integer, -- number of blocks read
+ writes integer, -- number of blocks written
+ rbytes integer, -- amount of bytes touched
+ wbytes integer, -- amount of bytes written
+ type string, -- return types
+ stmt string -- actual statement executed
+ )
+ external name sql.dump_trace;
+
TRACE SELECT count(*) FROM types;
SELECT COUNT(*) FROM tracelog();
------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
