Lines Matching refs:UPDATE
19 # trigger2-1.1.*: ON UPDATE trigger execution model.
25 # trigger program can correctly execute INSERT, UPDATE, DELETE * SELECT
29 # This tests that conditional triggers (ie. UPDATE OF triggers and triggers
32 # trigger2-3.1: UPDATE OF triggers
48 # trigger2-6.2[a-f]: UPDATE statements
85 CREATE TRIGGER before_update_row BEFORE UPDATE ON tbl FOR EACH ROW
93 CREATE TRIGGER after_update_row AFTER UPDATE ON tbl FOR EACH ROW
101 CREATE TRIGGER conditional_update_row AFTER UPDATE ON tbl FOR EACH ROW
113 UPDATE tbl SET a = a * 10, b = b * 10;
203 {UPDATE tbl SET b = old.b;}
207 UPDATE tbl SET c = old.c;
213 set statement {UPDATE tbl SET c = 10 WHERE a = 1;}
324 # trigger2-3.1: UPDATE OF triggers
331 CREATE TRIGGER tbl_after_update_cd BEFORE UPDATE OF c, d ON tbl
333 UPDATE log SET a = a + 1;
338 UPDATE tbl SET b = 1, c = 10; -- 2
339 UPDATE tbl SET b = 10; -- 0
340 UPDATE tbl SET d = 4 WHERE a = 0; --1
341 UPDATE tbl SET a = 4, b = 10; --0
362 execsql "CREATE TRIGGER $trig BEGIN UPDATE log set a = a + 1; END;"
370 UPDATE log SET a = 0;
374 UPDATE log SET a = 0;
378 UPDATE log SET a = 0;
444 UPDATE tbl set b = 10 WHERE a = 1;
512 # Handling of ON CONFLICT by UPDATE statements inside triggers
516 CREATE TRIGGER au_tbl AFTER UPDATE ON tbl BEGIN
517 UPDATE OR IGNORE tbl SET a = new.a, c = 10;
523 UPDATE tbl SET a = 1 WHERE a = 4;
529 UPDATE OR ABORT tbl SET a = 4 WHERE a = 1;
539 UPDATE OR FAIL tbl SET a = 4 WHERE a = 1;
549 UPDATE OR REPLACE tbl SET a = 1 WHERE a = 4;
561 UPDATE OR ROLLBACK tbl SET a = 4 WHERE a = 1;
587 CREATE TRIGGER before_update INSTEAD OF UPDATE ON abcd BEGIN
591 CREATE TRIGGER after_update INSTEAD OF UPDATE ON abcd BEGIN
618 UPDATE abcd SET a = 100, b = 5*5 WHERE a = 1;
634 UPDATE abcd SET a = 100, b = 5*5 WHERE a = 1;
651 UPDATE abcd SET a = 100, b = 5*5 WHERE a = 1;
708 CREATE TRIGGER r3 INSTEAD OF UPDATE ON v1 BEGIN
712 UPDATE v1 SET x=x+100, y=y+200, z=z+300;