Update of /cvsroot/monetdb/sql/src/test/Tests
In directory sc8-pr-cvs16:/tmp/cvs-serv7012/Tests
Modified Files:
All
Added Files:
procedure_syntax.sql.src procedure_syntax.stable.err
procedure_syntax.stable.out
Log Message:
Test for the new implementation.
All the features supported for functions are now supported for procedures.
However, procedure and functions differ in two aspects (well, maybe one):
Procedure do not have return type and no return statements in their
runtime_body.
A new field to the struct sql_func was added to simply the distinguish between t
hem and also to help in the dependencies check.
Index: All
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/Tests/All,v
retrieving revision 1.37
retrieving revision 1.38
diff -u -d -r1.37 -r1.38
--- All 28 Apr 2007 11:24:32 -0000 1.37
+++ All 3 May 2007 23:42:28 -0000 1.38
@@ -81,3 +81,4 @@
round
rank
function_syntax
+procedure_syntax
--- NEW FILE: procedure_syntax.sql.src ---
$RELSRCDIR/../procedure_syntax.sql
--- NEW FILE: procedure_syntax.stable.err ---
stderr of test 'procedure_syntax` in directory 'src/test` itself:
# 01:17:48 >
# 01:17:48 > Mtimeout -timeout 180 mserver5
"--config=/ufs/goncalve/scratch/MonetDB/MonetDB5/etc/monetdb5.conf" --debug=10
--set
"monet_mod_path=/ufs/goncalve/scratch/MonetDB/MonetDB5/lib/MonetDB5:/ufs/goncalve/scratch/MonetDB/MonetDB5/lib/MonetDB5/lib:/ufs/goncalve/scratch/MonetDB/MonetDB5/lib/MonetDB5/bin"
--set "gdk_dbfarm=/ufs/goncalve/scratch/MonetDB/MonetDB5/var/MonetDB5/dbfarm"
--set "sql_logdir=/ufs/goncalve/scratch/MonetDB/MonetDB5/var/MonetDB5/sql_logs"
--set
"xquery_logdir=/ufs/goncalve/scratch/MonetDB/MonetDB5/var/MonetDB5/xquery_logs"
--set mapi_port=34904 --set xrpc_port=47266 --set monet_prompt= --trace
"--dbname=mTests_src_test" --dbinit=' include sql;' ; echo ; echo Over..
# 01:17:48 >
#warning: please don't forget to set your vault key!
#(see /ufs/goncalve/scratch/MonetDB/MonetDB5/etc/monetdb5.conf)
# 01:17:48 >
# 01:17:48 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=34904
# 01:17:48 >
MAPI = [EMAIL PROTECTED]:34904
QUERY = DROP PROCEDURE p1;
ERROR = !DROP PROCEDURE: there are more than one procedure called 'p1', please
use the full signature
MAPI = [EMAIL PROTECTED]:34904
QUERY = DROP PROCEDURE p2 (int, varchar(1024));
ERROR = !DROP PROCEDURE: no such procedure 'p2' (int(32), varchar(1024))
MAPI = [EMAIL PROTECTED]:34904
QUERY = DROP FUNCTION p1;
ERROR = !DROP FUNCTION: no such function 'p1'
MAPI = [EMAIL PROTECTED]:34904
QUERY = DROP FUNCTION p1 ();
ERROR = !DROP FUNCTION: no such function 'p1' ()
MAPI = [EMAIL PROTECTED]:34904
QUERY = DROP ALL FUNCTION p1;
ERROR = !DROP ALL FUNCTION: no such function 'p1'
# 01:17:48 >
# 01:17:48 > Done.
# 01:17:48 >
--- NEW FILE: procedure_syntax.stable.out ---
stdout of test 'procedure_syntax` in directory 'src/test` itself:
# 01:17:48 >
# 01:17:48 > Mtimeout -timeout 180 mserver5
"--config=/ufs/goncalve/scratch/MonetDB/MonetDB5/etc/monetdb5.conf" --debug=10
--set
"monet_mod_path=/ufs/goncalve/scratch/MonetDB/MonetDB5/lib/MonetDB5:/ufs/goncalve/scratch/MonetDB/MonetDB5/lib/MonetDB5/lib:/ufs/goncalve/scratch/MonetDB/MonetDB5/lib/MonetDB5/bin"
--set "gdk_dbfarm=/ufs/goncalve/scratch/MonetDB/MonetDB5/var/MonetDB5/dbfarm"
--set "sql_logdir=/ufs/goncalve/scratch/MonetDB/MonetDB5/var/MonetDB5/sql_logs"
--set
"xquery_logdir=/ufs/goncalve/scratch/MonetDB/MonetDB5/var/MonetDB5/xquery_logs"
--set mapi_port=34904 --set xrpc_port=47266 --set monet_prompt= --trace
"--dbname=mTests_src_test" --dbinit=' include sql;' ; echo ; echo Over..
# 01:17:48 >
!WARNING: GDKlockHome: ignoring empty or invalid .gdk_lock.
!WARNING: BBPdir: initializing BBP.
# MonetDB Server v5.0.0_beta2_1
# Copyright (c) 1993-2007 CWI, all rights reserved
# Compiled for x86_64-redhat-linux-gnu/64bit with 64bit OIDs dynamically linked
# dbname:mTests_src_test
# Visit http://monetdb.cwi.nl/ for further information
Ready.
Over..
# 01:17:48 >
# 01:17:48 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=34904
# 01:17:48 >
% sys.functions # table_name
% name # name
% varchar # type
% 2 # length
[ "p1" ]
[ "p1" ]
[ "p2" ]
[ "p3" ]
% sys.functions # table_name
% name # name
% varchar # type
% 2 # length
[ "p1" ]
[ "p1" ]
[ "p2" ]
[ "p3" ]
% sys.functions # table_name
% name # name
% varchar # type
% 2 # length
[ "p1" ]
[ "p2" ]
[ "p3" ]
% sys.functions # table_name
% name # name
% varchar # type
% 2 # length
[ "p1" ]
[ "p2" ]
[ "p3" ]
% sys.functions # table_name
% name # name
% varchar # type
% 2 # length
[ "p1" ]
[ "p3" ]
% sys.functions # table_name
% name # name
% varchar # type
% 2 # length
[ "p1" ]
% sys.functions # table_name
% name # name
% varchar # type
% 0 # length
% sys.functions # table_name
% name # name
% varchar # type
% 2 # length
[ "p1" ]
# 01:17:48 >
# 01:17:48 > Done.
# 01:17:48 >
-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
