Hi all, we made an update for our database from SAPDB7.4 to MAXDB and have problems with triggers and procedures in which we use an update trigger with ignore trigger. Thomas Anhaus wrote 26.04.04 that it should still work, but our database crashes if we use the old triggers. I made a very little test to see if it works or not.
These are the statements: create table atab_1(val1 int, val2 int, val3 int) create table atab_2(t1 int, t2 int, t3 int) create table atab_3(v1 int, v2 int, v3 int) insert into atab_1 values (1,2,3) insert into atab_2 values (10,20,30) insert into atab_2 values (40,50,60) create trigger tr_upd_atab_1 for atab_1 after update execute ( update dba.atab_2 set t2 = t2 + :val2, t3 = t3 + :val3 where t1 = 10; update dba.atab_2 set t2 = t2 + :val2, t3 = t3 + :val3 where t1 = 40 ignore trigger;) create trigger tr_upd_atab_2 for atab_2 after update execute ( insert into dba.atab_3 values (:t1, :t2, :t3);) update atab_1 set val2=30 where val1=1 After execute the last statement I expected 1 row in atab_3, but found 2 !? What should we do now ? Elke -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
