Update of /cvsroot/monetdb/sql/src/test/Dependencies
In directory sc8-pr-cvs16:/tmp/cvs-serv23306
Modified Files:
dependency_functions.sql
Log Message:
There are also dependencies between functions and views.
A test was modified to check this situation.
sql/src/Dependencies/dependency_functions.sql
Index: dependency_functions.sql
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/Dependencies/dependency_functions.sql,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -d -r1.1 -r1.2
--- dependency_functions.sql 29 Apr 2007 09:50:23 -0000 1.1
+++ dependency_functions.sql 8 May 2007 11:20:12 -0000 1.2
@@ -47,3 +47,18 @@
DROP ALL FUNCTION f1;
SELECT f1.name, f2.name, 'DEP_FUNC' from functions as f1, functions as f2,
dependencies as dep where f1.id = dep.id AND f2.id = dep.depend_id AND
dep.depend_type = 7 order by f2.name, f1.name;
+
+create table t1(id int, name varchar(1024), age int);
+
+create function f1()
+returns int
+BEGIN
+ return 1;
+END;
+
+create view v1 as select * from t1 where id = f1();
+
+DROP function f1;
+DROP function f1 cascade;
+DROP table t1;
+
-------------------------------------------------------------------------
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
