Update of /cvsroot/monetdb/sql/src/test/Triggers
In directory 23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv21442/src/test/Triggers
Modified Files:
trigger_activation.sql
Log Message:
algebra now has insert,update and delete operators.
mostly code moved from sql_updates.mx into rel_bin.mx
In the process, within functions we no longer output 'rows affected'
results of insert, update and deletes.
alter table use update instead insert now (column/idx bat with default
values is generated by the storage layer).
create user, now uses the table_funcs interface
same holds for granting and revoking privileges on tables.
This was needed to remove dependency on old insert/delete code.
U trigger_activation.sql
Index: trigger_activation.sql
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/Triggers/trigger_activation.sql,v
retrieving revision 1.5
retrieving revision 1.6
diff -u -d -r1.5 -r1.6
--- trigger_activation.sql 10 May 2007 16:28:51 -0000 1.5
+++ trigger_activation.sql 21 Dec 2008 19:38:23 -0000 1.6
@@ -2,10 +2,12 @@
--the semantic should also be tested after the syntax test
create table t1 (id int, name varchar(1024));
+-- alter early as its, executed as update (one of the key columns).
+ALTER TABLE t1 add CONSTRAINT t1_constraint PRIMARY KEY(id);
+
insert into t1 values(10, 'monetdb');
insert into t1 values(20, 'monet');
-
create trigger test1
after update on t1
delete from t1 where name = 'monetdb' and id = 10;
@@ -22,8 +24,6 @@
after update on t1
insert into t1 values(30, 'update_from_test4');
-ALTER TABLE t1 add CONSTRAINT t1_constraint PRIMARY KEY(id);
-
update t1 set name = 'mo' where id = 11;
select * from t1;
------------------------------------------------------------------------------
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
