3 May
2010
3 May
'10
1:19 p.m.
I run following sql statements on MonetDB server v5.18.5 (32-bit), based on kernel v1.36.5 (32-bit oids) create table a (a int, b int); create table ta(a int, b int); insert into ta values(1,2); insert into ta values(3,4); insert into ta values(5,6); create trigger d_ta after delete on ta referencing old row as o for each row insert into a values(o.a, o.b); delete from ta where a=1; select * from a; drop trigger d_ta; drop table ta; drop table a; The output is: +---+-----+ | a | b | +==+==+ | 3 | 4 | | 3 | 4 | | 5 | 6 | | 5 | 6 | +---+----+ Obviously, the trigger functions wrong.