Update of /cvsroot/monetdb/sql/src/test/Tests
In directory sc8-pr-cvs16:/tmp/cvs-serv23380/Tests
Modified Files:
procedure_syntax.stable.err procedure_syntax.stable.out
Log Message:
Modify test to also cover the new changes.
Changes to support CALL inside procedures and function bodies.
It is also possible to call as a normal statement, for example:
create procedure p1(id)
begin
insert into t1 values(id);
end;
create procedure p1()
begin
declare id int;
set id = 0;
call p1(id);
end;
call p1();
The end result is the insertion of value 1 into the table t1.
Index: procedure_syntax.stable.err
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/Tests/procedure_syntax.stable.err,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -d -r1.1 -r1.2
--- procedure_syntax.stable.err 3 May 2007 23:42:29 -0000 1.1
+++ procedure_syntax.stable.err 4 May 2007 14:26:04 -0000 1.2
@@ -12,19 +12,25 @@
# 01:17:48 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=34904
# 01:17:48 >
-MAPI = [EMAIL PROTECTED]:34904
+MAPI = [EMAIL PROTECTED]:39759
QUERY = DROP PROCEDURE p1;
ERROR = !DROP PROCEDURE: there are more than one procedure called 'p1', please
use the full signature
-MAPI = [EMAIL PROTECTED]:34904
+MAPI = [EMAIL PROTECTED]:39759
QUERY = DROP PROCEDURE p2 (int, varchar(1024));
ERROR = !DROP PROCEDURE: no such procedure 'p2' (int(32), varchar(1024))
-MAPI = [EMAIL PROTECTED]:34904
+MAPI = [EMAIL PROTECTED]:39759
+QUERY = DROP table t1;
+ERROR = !DROP TABLE: unable to drop table t1 (there are database objects which
depend on it)
+MAPI = [EMAIL PROTECTED]:39759
+QUERY = DROP ALL PROCEDURE p1;
+ERROR = !DROP PROCEDURE: there are functions dependent on procedure p1;
+MAPI = [EMAIL PROTECTED]:39759
QUERY = DROP FUNCTION p1;
ERROR = !DROP FUNCTION: no such function 'p1'
-MAPI = [EMAIL PROTECTED]:34904
+MAPI = [EMAIL PROTECTED]:39759
QUERY = DROP FUNCTION p1 ();
ERROR = !DROP FUNCTION: no such function 'p1' ()
-MAPI = [EMAIL PROTECTED]:34904
+MAPI = [EMAIL PROTECTED]:39759
QUERY = DROP ALL FUNCTION p1;
ERROR = !DROP ALL FUNCTION: no such function 'p1'
Index: procedure_syntax.stable.out
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/Tests/procedure_syntax.stable.out,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -d -r1.1 -r1.2
--- procedure_syntax.stable.out 3 May 2007 23:42:29 -0000 1.1
+++ procedure_syntax.stable.out 4 May 2007 14:26:05 -0000 1.2
@@ -62,6 +62,12 @@
% varchar # type
% 2 # length
[ "p1" ]
+[ 1 ]
+% sys.t1 # table_name
+% id # name
+% int # type
+% 1 # length
+[ 1 ]
% sys.functions # table_name
% name # name
% varchar # type
-------------------------------------------------------------------------
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
