Update of /cvsroot/monetdb/sql/src/test/Dependencies/Tests
In directory sc8-pr-cvs16:/tmp/cvs-serv23306/Tests
Modified Files:
Dependencies.stable.err
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: Dependencies.stable.err
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/Dependencies/Tests/Dependencies.stable.err,v
retrieving revision 1.4
retrieving revision 1.5
diff -u -d -r1.4 -r1.5
--- Dependencies.stable.err 2 Feb 2007 19:49:56 -0000 1.4
+++ Dependencies.stable.err 8 May 2007 11:20:12 -0000 1.5
@@ -67,52 +67,55 @@
# 23:01:45 > Mtimeout -timeout 60 ./Dependencies.SQL Dependencies
# 23:01:45 >
-MAPI = [EMAIL PROTECTED]:36415
+MAPI = [EMAIL PROTECTED]:33628
QUERY = DROP USER monetdb;
ERROR = !DROP USER: 'monetdb' owns a schema
-MAPI = [EMAIL PROTECTED]:36415
+MAPI = [EMAIL PROTECTED]:33628
QUERY = DROP SCHEMA test;
ERROR = !DROP SCHEMA: unable to drop schema 'test' (there are database objects
which depend on it
-MAPI = [EMAIL PROTECTED]:36415
+MAPI = [EMAIL PROTECTED]:33628
QUERY = CREATE SCHEMA "test_2" AUTHORIZATION "public";
ERROR = !CREATE SCHEMA: insufficient privileges for user 'monet_test'
-MAPI = [EMAIL PROTECTED]:36415
+MAPI = [EMAIL PROTECTED]:33628
QUERY = DROP USER monetdb;
ERROR = !DROP USER: 'monetdb' owns a schema
-MAPI = [EMAIL PROTECTED]:36415
+MAPI = [EMAIL PROTECTED]:33628
QUERY = CREATE INDEX id_age_index ON v1(id,age);
ERROR = !CREATE INDEX: cannot create index on view 'v1'
-MAPI = [EMAIL PROTECTED]:36415
+MAPI = [EMAIL PROTECTED]:33628
QUERY = ALTER TABLE t1 DROP COLUMN id;
ERROR = !unable to drop column id (there are database objects which depend on
it)
-MAPI = [EMAIL PROTECTED]:36415
+MAPI = [EMAIL PROTECTED]:33628
QUERY = ALTER TABLE v1 DROP COLUMN age;
ERROR = !cannot drop column age (v1 is a view)
-MAPI = [EMAIL PROTECTED]:36415
+MAPI = [EMAIL PROTECTED]:33628
QUERY = ALTER TABLE t2 ADD FOREIGN KEY(age_v1) REFERENCES v1(age);
ERROR = !CONSTRAINT FOREIGN KEY: could not find referenced PRIMARY KEY in
table 'v1'
-MAPI = [EMAIL PROTECTED]:36415
+MAPI = [EMAIL PROTECTED]:33628
QUERY = DROP TABLE t1;
ERROR = !DROP TABLE: FOREIGN KEY t2.t2_id_t1_fkey depends on t1
-MAPI = [EMAIL PROTECTED]:36415
+MAPI = [EMAIL PROTECTED]:33628
QUERY = DROP VIEW v1;
ERROR = !unable to drop view v1 (there are database objects which depend on it)
-MAPI = [EMAIL PROTECTED]:36415
+MAPI = [EMAIL PROTECTED]:33628
QUERY = DROP TABLE t2;
ERROR = !DROP TABLE: unable to drop table t2 (there are database objects which
depend on it)
-MAPI = [EMAIL PROTECTED]:36415
+MAPI = [EMAIL PROTECTED]:33628
QUERY = DROP FUNCTION f1;
-ERROR = !DROP FUNCTION: there are functions dependent on function f1;
-MAPI = [EMAIL PROTECTED]:36415
+ERROR = !DROP FUNCTION: there are database objects dependent on function f1;
+MAPI = [EMAIL PROTECTED]:33628
QUERY = DROP INDEX id_age_index;
ERROR = !DROP INDEX: no such index 'id_age_index'
-MAPI = [EMAIL PROTECTED]:36415
+MAPI = [EMAIL PROTECTED]:33628
QUERY = DROP VIEW v1;
ERROR = !unable to drop view v1 (there are database objects which depend on it)
-MAPI = [EMAIL PROTECTED]:36415
+MAPI = [EMAIL PROTECTED]:33628
QUERY = DROP TABLE t1;
ERROR = !DROP TABLE: unable to drop table t1 (there are database objects which
depend on it)
-MAPI = [EMAIL PROTECTED]:36415
+MAPI = [EMAIL PROTECTED]:33628
+QUERY = DROP function f1;
+ERROR = !DROP FUNCTION: there are database objects dependent on function f1;
+MAPI = [EMAIL PROTECTED]:33628
QUERY = DROP SCHEMA test_2;
ERROR = !DROP SCHEMA: name test_2 does not exist
-------------------------------------------------------------------------
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
