Update of /cvsroot/monetdb/sql/src/test/Tests
In directory
sfp-cvsdas-1.v30.ch3.sourceforge.com:/tmp/cvs-serv29337/src/test/Tests
Added Files:
trace.sql
Log Message:
propagated changes of Thursday Nov 19 2009 - Saturday Nov 28 2009
from the Nov2009 branch to the development trunk
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2009/11/19 - vzzzbx: src/test/Tests/trace.sql,1.1.2.1
Adding test for tracelog() function (currently failing see bug 2900358)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2009/11/25 - mlkersten: src/test/Tests/trace.sql,1.1.2.2
Add definition of the tracelog function.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
--- NEW FILE: trace.sql ---
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
