[ 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 vzzzbx
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: Closed
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: Wouter Alink (vzzzbx)
Date: 2009-11-06 20:00

Message:
I messed up versions, indeed on Nov2009 it is not reproducible.
However, the website should have been documenting the Aug2009 release (as
it is the latest released build).

Closing bug as it will be obsolete soon.


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

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