Lines Matching refs:update

47 # LSCC set properly after update
50         update t0 set x=3 where x=1;
55 # LSCC unchanged within an update statement
58         update t0 set x=x+last_statement_change_count() where x=3;
63 # LSCC set properly after update on table where no rows changed
66         update t0 set x=77 where x=88;
89             update t0 set x=x;
90             update t2 set v2=last_statement_change_count();
104 # LSCC changed properly by update within context of after insert trigger
112 # 3.x - tests with after update trigger
114 # LSCC changed properly after update into table containing after trigger
119         create trigger r1 after update on t1 for each row begin
122             update t2 set v2=last_statement_change_count();
124         update t1 set k=k;
129 # LSCC unchanged upon entry into after update trigger
136 # LSCC changed properly by delete within context of after update trigger
154             update t2 set v2=last_statement_change_count();
198             update t0 set x=x*10 where x=1;
202             update t0 set x=x*10 where x=0;
210             update t0 set x=x*100 where x=0;