Bugs item #2900358, was opened at 2009-11-19 11:29
Message generated for change (Comment added) made by mlkersten
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2900358&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: SQL/Core
Group: SQL "stable"
>Status: Closed
>Resolution: Wont Fix
Priority: 5
Private: No
Submitted By: Wouter Alink (vzzzbx)
Assigned to: Martin Kersten (mlkersten)
Summary: SQL: tracelog() is undefined

Initial Comment:
The function tracelog() is not defined by default. If the sql query 'create 
function ...  sql.dump_trace;' 
(provided in 
http://www.monetdb.nl/projects/monetdb/SQL/Documentation/TRACE-Statement.html) 
is first executed then it works fine. 
(I added a test SQL:src/test/Tests/trace)

$ monetdb create aap
created database in maintenance mode: aap
$ monetdb start aap
starting database 'aap'... done
$ mclient -lsql -p51234 -daap -umonetdb -Pmonetdb
Welcome to mclient, the MonetDB/SQL interactive terminal
Database: MonetDB v5.16.0, 'aap'
Type \q to quit, \? for a list of available commands
auto commit mode: on
sql>SELECT * FROM tracelog();
SELECT: no such operator 'tracelog'


$ mserver5 --version
MonetDB server v5.16.0 (64-bit), based on kernel v1.34.0 (64-bit oids)
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
Configured for prefix: /ufs/alink/opt/MonetDB-Nov2009
Libraries:
  libpcre: 7.8 2008-09-05 (compiled with 7.8)
  openssl: OpenSSL 0.9.8g 19 Oct 2007 (compiled with OpenSSL 0.9.8g 19 Oct 2007)
  libxml2: 2.7.6 (compiled with 2.7.6)
Compiled by: [email protected] (x86_64-unknown-linux-gnu)
Compilation: gcc -Wall -Wextra -g  -Werror-implicit-function-declaration 
-Werror -Wpointer-arith -Wdeclaration-after-statement -Wundef 
Wp,-D_FORTIFY_SOURCE=2
Linking    : ld -IPA -m elf_x86_64 


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

>Comment By: Martin Kersten (mlkersten)
Date: 2009-11-19 12:36

Message:
Correct. There is no hardcoded definition for this function in the SQL
catalog.
It is part of a collection of sql scripts in .../src/sql/*.sql that have
to be loaded once for a database.
That's why the definition was also repeated in the documentation

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

Comment By: Wouter Alink (vzzzbx)
Date: 2009-11-19 11:31

Message:
i think this is martin's area ;) re-assiging to martin.

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

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2900358&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
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs

Reply via email to