Update of /cvsroot/monetdb/sql/src/test/Triggers
In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv1604/src/test/Triggers
Added Files:
Tag: SQL_2-24
trigger_insert.sql
Log Message:
fix bug in handling references (old/new values) in triggers
--- NEW FILE: trigger_insert.sql ---
create table t1 (id int, name varchar(1024));
create table t2 (id int);
create trigger test1
after insert on t1 referencing new row as ins
for each statement insert into t2 values( ins.id );
insert into t1 values (1, 'testing');
select * from t1;
select * from t2;
drop trigger test1;
--Cleanup
drop table t1;
drop table t2;
-------------------------------------------------------------------------
Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW!
Studies have shown that voting for your favorite open source project,
along with a healthy diet, reduces your potential for chronic lameness
and boredom. Vote Now at http://www.sourceforge.net/community/cca08
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
