Update of /cvsroot/monetdb/sql/src/test/Tests
In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv7368/src/test/Tests
Added Files:
marcin3.stable.err.Algebra session_vars.stable.out.Algebra
Log Message:
adding special output for algebra version
changed sql.trace() into sql.logfile(filename:string), which can be called
from sql too.
fixed handling of dependency problem on views (one remains)
--- NEW FILE: marcin3.stable.err.Algebra ---
stderr of test 'marcin3` in directory 'src/test` itself:
# 20:07:34 >
# 20:07:34 > Mtimeout -timeout 180 Mserver
"--config=/ufs/niels/data/Linux-i686/etc/monet.conf" --debug=0 --set
"monet_mod_path=/ufs/niels/data/Linux-i686/lib/MonetDB" --dbfarm
"/ufs/niels/data/Linux-i686/var/dbfarm" --set monet_prompt= --trace
"--dbname=mTests_src_test" --set sql_port=50445
"/ufs/niels/data/Linux-i686/share/MonetDB/sqlserver.mil" ; echo ; echo Over..
# 20:07:34 >
# server listening on port 50445
# 20:07:35 >
# 20:07:35 > Mtimeout -timeout 60 Msql -u monetdb -P monetdb --host=stem
--port=50445 < marcin3.sql
# 20:07:35 >
MAPI = [EMAIL PROTECTED]:36121
QUERY = select id, sum(val) AS valsum from nutki group by id having val>1;
ERROR = !SELECT: cannot compare sets with values, probably an aggregate
function missing
MAPI = [EMAIL PROTECTED]:36121
QUERY = select id, sum(val) AS valsum from nutki group by id having val>2;
ERROR = !SELECT: cannot compare sets with values, probably an aggregate
function missing
MAPI = [EMAIL PROTECTED]:36121
QUERY = select id, sum(val) AS valsum from nutki group by id having valsum>3;
ERROR = !SELECT: identifier 'valsum' unknown
# 21:15:41 >
# 21:15:41 > Done.
# 21:15:41 >
--- NEW FILE: session_vars.stable.out.Algebra ---
stdout of test 'session_vars` in directory 'src/test` itself:
# 15:18:12 >
# 15:18:12 > mserver5
"--config=/ufs/niels/scratch/monetdb/Linux-x86_64/etc/monetdb5.conf" --debug=10
--set
"monet_mod_path=/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB5:/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB5/lib:/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB5/bin"
--set "gdk_dbfarm=/ufs/niels/scratch/monetdb/Linux-x86_64/var/MonetDB5/dbfarm"
--set
"sql_logdir=/ufs/niels/scratch/monetdb/Linux-x86_64/var/MonetDB5/sql_logs"
--set mapi_open=true --set xrpc_open=true --set mapi_port=36121 --set
xrpc_port=46332 --set monet_prompt= --trace "--dbname=mTests_src_test" --set
sql_debug=16384 --set mal_listing=0 "--dbinit= include sql;" ; echo ; echo
Over..
# 15:18:12 >
# MonetDB server v5.3.0, based on kernel v1.21.0
# Serving database 'mTests_src_test'
# Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs dynamically linked
# Copyright (c) 1993-2007 CWI, all rights reserved
# Visit http://monetdb.cwi.nl/ for further information
# Listening for connection requests on mapi:monetdb://koala.ins.cwi.nl:36121/
# MonetDB/SQL module v2.21.0 loaded
Ready.
# semantic relational algebra
# semantic relational algebra
# semantic relational algebra
# semantic relational algebra
# semantic relational algebra
# falling back to direct mode
# semantic relational algebra
# falling back to direct mode
# semantic relational algebra
# falling back to direct mode
# semantic relational algebra
# falling back to direct mode
# semantic relational algebra
# falling back to direct mode
# semantic relational algebra
# falling back to direct mode
# semantic relational algebra
# semantic relational algebra
# semantic relational algebra
# semantic relational algebra
# semantic relational algebra
# semantic relational algebra
# semantic relational algebra
# semantic relational algebra
# falling back to direct mode
# semantic relational algebra
# falling back to direct mode
# semantic relational algebra
# falling back to direct mode
# semantic relational algebra
# semantic relational algebra
# semantic relational algebra
#function user.main():void;
# clients.quit();
#end main;
Over..
# 11:50:12 >
# 11:50:12 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=35781 < session_vars.sql
# 11:50:12 >
% . # table_name
% single_value # name
% int # type
% 5 # length
[ 16384 ]
% . # table_name
% single_value # name
% varchar # type
% 3 # length
[ "sys" ]
% . # table_name
% single_value # name
% varchar # type
% 7 # length
[ "monetdb" ]
% . # table_name
% single_value # name
% varchar # type
% 7 # length
[ "monetdb" ]
% . # table_name
% single_value # name
% int # type
% 1 # length
[ 1 ]
% . # table_name
% single_value # name
% varchar # type
% 4 # length
[ "help" ]
% . # table_name
% single_value # name
% boolean # type
% 5 # length
[ true ]
% . # table_name
% single_value # name
% int # type
% 5 # length
[ 16384 ]
% . # table_name
% single_value # name
% varchar # type
% 3 # length
[ "sys" ]
% . # table_name
% single_value # name
% varchar # type
% 7 # length
[ "monetdb" ]
% . # table_name
% single_value # name
% varchar # type
% 7 # length
[ "monetdb" ]
% . # table_name
% single_value # name
% int # type
% 1 # length
[ 1 ]
% . # table_name
% single_value # name
% varchar # type
% 1 # length
[ "1" ]
% . # table_name
% single_value # name
% boolean # type
% 5 # length
[ NULL ]
# 12:30:00 >
# 12:30:00 > Done.
# 12:30:00 >
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
