Update of /cvsroot/monetdb/sql/src/test/Tests
In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv27853
Modified Files:
Tag: SQL_2-18
function_syntax.stable.err procedure_syntax.stable.err
Log Message:
Correct the dependencies check for the functions with the same name.
DROP ALL f1;
This query will drop all the functions with the name f1 and also the
dependencies between them.
However, if there is dependencies to other objects the query is aborted.
Note: The same was implemented for procedures.
Approve the new err output
Index: function_syntax.stable.err
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/Tests/function_syntax.stable.err,v
retrieving revision 1.1
retrieving revision 1.1.2.1
diff -u -d -r1.1 -r1.1.2.1
--- function_syntax.stable.err 28 Apr 2007 11:24:34 -0000 1.1
+++ function_syntax.stable.err 8 Jun 2007 12:04:33 -0000 1.1.2.1
@@ -12,15 +12,15 @@
# 13:04:59 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=36428
# 13:04:59 >
-MAPI = [EMAIL PROTECTED]:36428
+MAPI = [EMAIL PROTECTED]:32397
QUERY = DROP FUNCTION f1;
ERROR = !DROP FUNCTION: there are more than one function called 'f1', please
use the full signature
-MAPI = [EMAIL PROTECTED]:36428
+MAPI = [EMAIL PROTECTED]:32397
QUERY = DROP FUNCTION f2 (int, varchar(1024));
ERROR = !DROP FUNCTION: no such function 'f2' (int(32), varchar(1024))
-MAPI = [EMAIL PROTECTED]:36428
-QUERY = DROP ALL FUNCTION f1;
-ERROR = !DROP FUNCTION: there are functions dependent on function f1;
+MAPI = [EMAIL PROTECTED]:32397
+QUERY = DROP ALL FUNCTION f1 CASCADE;
+ERROR = !DROP ALL FUNCTION: no such function 'f1'
# 13:04:59 >
# 13:04:59 > Done.
Index: procedure_syntax.stable.err
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/Tests/procedure_syntax.stable.err,v
retrieving revision 1.2
retrieving revision 1.2.2.1
diff -u -d -r1.2 -r1.2.2.1
--- procedure_syntax.stable.err 4 May 2007 14:26:04 -0000 1.2
+++ procedure_syntax.stable.err 8 Jun 2007 12:04:34 -0000 1.2.2.1
@@ -12,25 +12,25 @@
# 01:17:48 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=34904
# 01:17:48 >
-MAPI = [EMAIL PROTECTED]:39759
+MAPI = [EMAIL PROTECTED]:34616
QUERY = DROP PROCEDURE p1;
ERROR = !DROP PROCEDURE: there are more than one procedure called 'p1', please
use the full signature
-MAPI = [EMAIL PROTECTED]:39759
+MAPI = [EMAIL PROTECTED]:34616
QUERY = DROP PROCEDURE p2 (int, varchar(1024));
ERROR = !DROP PROCEDURE: no such procedure 'p2' (int(32), varchar(1024))
-MAPI = [EMAIL PROTECTED]:39759
+MAPI = [EMAIL PROTECTED]:34616
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
+MAPI = [EMAIL PROTECTED]:34616
+QUERY = DROP ALL PROCEDURE p1 CASCADE;
+ERROR = !DROP ALL PROCEDURE: no such procedure 'p1'
+MAPI = [EMAIL PROTECTED]:34616
QUERY = DROP FUNCTION p1;
ERROR = !DROP FUNCTION: no such function 'p1'
-MAPI = [EMAIL PROTECTED]:39759
+MAPI = [EMAIL PROTECTED]:34616
QUERY = DROP FUNCTION p1 ();
ERROR = !DROP FUNCTION: no such function 'p1' ()
-MAPI = [EMAIL PROTECTED]:39759
+MAPI = [EMAIL PROTECTED]:34616
QUERY = DROP ALL FUNCTION p1;
ERROR = !DROP ALL FUNCTION: no such function 'p1'
-------------------------------------------------------------------------
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
