Update of /cvsroot/monetdb/sql/src/test/DropCascade/Tests
In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv12136
Modified Files:
Tag: SQL_2-18
drop_columns_cascade.sql drop_table_cascade.sql
Log Message:
Change the tests to remove the recursive triggers.
The new out and err outputs are approved.
Index: drop_table_cascade.sql
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/DropCascade/Tests/drop_table_cascade.sql,v
retrieving revision 1.2
retrieving revision 1.2.2.1
diff -u -d -r1.2 -r1.2.2.1
--- drop_table_cascade.sql 16 Apr 2007 16:14:40 -0000 1.2
+++ drop_table_cascade.sql 8 Jun 2007 12:32:24 -0000 1.2.2.1
@@ -2,7 +2,7 @@
create table t2 (id int, age int, PRIMARY KEY (ID), FOREIGN KEY(id) REFERENCES
t1(id));
-create trigger test1 after insert on t1
+create trigger test1 after insert on t2
insert into t1 values(0, 'after', 23);
create view v1 as select * from t1;
Index: drop_columns_cascade.sql
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/DropCascade/Tests/drop_columns_cascade.sql,v
retrieving revision 1.2
retrieving revision 1.2.2.1
diff -u -d -r1.2 -r1.2.2.1
--- drop_columns_cascade.sql 16 Apr 2007 16:14:36 -0000 1.2
+++ drop_columns_cascade.sql 8 Jun 2007 12:32:24 -0000 1.2.2.1
@@ -4,9 +4,10 @@
create view v1 as select * from t1;
-create trigger test1 after insert on t1
+create trigger test1 after insert on t2
insert into t1 values(0, 'after', 23);
+
CREATE FUNCTION f1(num int)
RETURNS int
BEGIN
-------------------------------------------------------------------------
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
