Lines Matching refs:update

40 # LIRID unchanged after an update on a table
43         update t1 set k=4 where k=2;
74             update t2 set k=k+10, val2=100+last_insert_rowid();
75             update t2 set val3=1000+last_insert_rowid();
96 # LIRID unchanged by update within context of after insert trigger
104 # 3.x - tests with after update trigger
106 # LIRID not changed after an update onto a table containing an after trigger
111         create trigger r1 after update on t1 for each row begin
113             update t2 set k=k+10, val2=100+last_insert_rowid();
114             update t2 set val3=1000+last_insert_rowid();
116         update t1 set k=14 where k=3;
121 # LIRID unchanged upon entry into after update trigger
128 # LIRID changed properly by insert within context of after update trigger
135 # LIRID unchanged by update within context of after update trigger
152             update t2 set k=k+10, val2=100+last_insert_rowid();
153             update t2 set val3=1000+last_insert_rowid();
174 # LIRID unchanged by update within context of instead of trigger
191             update t2 set k=k+10, val2=100+last_insert_rowid();
192             update t2 set val3=1000+last_insert_rowid();
213 # LIRID unchanged by update within context of delete trigger
221 # 6.x - tests with instead of update trigger
223 # LIRID not changed after an update on a view containing an instead of trigger
228         create trigger r1 instead of update on v for each row begin
230             update t2 set k=k+10, val2=100+last_insert_rowid();
231             update t2 set val3=1000+last_insert_rowid();
233         update v set k=16 where k=14;
252 # LIRID unchanged by update within context of instead of trigger
273             update rid set rin=last_insert_rowid() where k=1;
276             update rid set rout=last_insert_rowid() where k=1;
279             update rid set rin=last_insert_rowid() where k=2;
281             update rid set rout=last_insert_rowid() where k=2;