Lines Matching refs:update

42 # LIRID unchanged after an update on a table
45         update t1 set k=4 where k=2;
76             update t2 set k=k+10, val2=100+last_insert_rowid();
77             update t2 set val3=1000+last_insert_rowid();
98 # LIRID unchanged by update within context of after insert trigger
106 # 3.x - tests with after update trigger
108 # LIRID not changed after an update onto a table containing an after trigger
113         create trigger r1 after update on t1 for each row begin
115             update t2 set k=k+10, val2=100+last_insert_rowid();
116             update t2 set val3=1000+last_insert_rowid();
118         update t1 set k=14 where k=3;
123 # LIRID unchanged upon entry into after update trigger
130 # LIRID changed properly by insert within context of after update trigger
137 # LIRID unchanged by update within context of after update trigger
154             update t2 set k=k+10, val2=100+last_insert_rowid();
155             update t2 set val3=1000+last_insert_rowid();
176 # LIRID unchanged by update within context of instead of trigger
193             update t2 set k=k+10, val2=100+last_insert_rowid();
194             update t2 set val3=1000+last_insert_rowid();
215 # LIRID unchanged by update within context of delete trigger
223 # 6.x - tests with instead of update trigger
225 # LIRID not changed after an update on a view containing an instead of trigger
230         create trigger r1 instead of update on v for each row begin
232             update t2 set k=k+10, val2=100+last_insert_rowid();
233             update t2 set val3=1000+last_insert_rowid();
235         update v set k=16 where k=14;
254 # LIRID unchanged by update within context of instead of trigger
275             update rid set rin=last_insert_rowid() where k=1;
278             update rid set rout=last_insert_rowid() where k=1;
281             update rid set rin=last_insert_rowid() where k=2;
283             update rid set rout=last_insert_rowid() where k=2;