[ monetdb-Bugs-2893416 ] SQL: trace documentation incomplete

[SourceForge.net]

Bugs item #2893416, was opened at 2009-11-06 17:49
Message generated for change (Comment added) made by mlkersten
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2893416&group_id=56967

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: Documentation
Group: SQL "stable"
Status: Open
>Resolution: Invalid
Priority: 5
Private: No
Submitted By: Wouter Alink (vzzzbx)
>Assigned to: Martin Kersten (mlkersten)
Summary: SQL: trace documentation incomplete

Initial Comment:
from:

http://www.monetdb.nl/projects/monetdb/SQL/Documentation/TRACE-Statement.html

I would assume the following should not fail  (on either Aug2009 or Nov2009 version):

$ mclient -lsql -daap
sql>set trace='show,pc,ticks';
!Variable trace unknown
0 tuples
sql>

Also, tracelog() is an undefined function. I assume some library needs to be loaded, but I cannot figure out which one.


----------------------------------------------------------------------

>Comment By: Martin Kersten (mlkersten)
Date: 2009-11-06 18:46

Message:
Not confirm on Nov 2009 release.
The function can be cut/paste from the documentation page into the sql
client

# MonetDB server v5.16.0, based on kernel v1.34.0
# Serving database 'demo', using 4 threads
# Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs dynamically
linked
# Detected 7.753 GiB (8324386816 bytes) main-memory.
# Copyright (c) 1993-July 2008 CWI.
# Copyright (c) August 2008-2009 MonetDB B.V., all rights reserved
# Visit http://monetdb.cwi.nl/ for further information
#warning: please don't forget to set your vault key!
#(see /ufs/mk/candidate//Linux/etc/monetdb5.conf)
# Listening for connection requests on mapi:monetdb://127.0.0.1:50000/
# MonetDB/SQL module v2.34.0 loaded
>select trace;
&1 0 1 1 1
% . # table_name
% single_value # name
% varchar # type
% 15 # length
[ "show,ticks,stmt" ]
>set trace='show,ticks';
>select trace;
&1 0 1 1 1
% . # table_name
% single_value # name
% varchar # type
% 10 # length
[ "show,ticks" ]
>



----------------------------------------------------------------------

You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2893416&group_id=56967

------------------------------------------------------------------------------
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-bugs mailing list
Monetdb-bugs@...
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs