Lines Matching refs:update
45 # LSCC set properly after update
48 update t0 set x=3 where x=1;
53 # LSCC unchanged within an update statement
56 update t0 set x=x+last_statement_change_count() where x=3;
61 # LSCC set properly after update on table where no rows changed
64 update t0 set x=77 where x=88;
87 update t0 set x=x;
88 update t2 set v2=last_statement_change_count();
102 # LSCC changed properly by update within context of after insert trigger
110 # 3.x - tests with after update trigger
112 # LSCC changed properly after update into table containing after trigger
117 create trigger r1 after update on t1 for each row begin
120 update t2 set v2=last_statement_change_count();
122 update t1 set k=k;
127 # LSCC unchanged upon entry into after update trigger
134 # LSCC changed properly by delete within context of after update trigger
152 update t2 set v2=last_statement_change_count();
196 update t0 set x=x*10 where x=1;
200 update t0 set x=x*10 where x=0;
208 update t0 set x=x*100 where x=0;