Lines Matching refs:new
60 INSERT INTO log VALUES('before', NULL, NULL, NULL, new.a, new.b, new.c);
63 INSERT INTO log VALUES('after', NULL, NULL, NULL, new.a, new.b, new.c);
66 INSERT INTO log VALUES('before', old.a,old.b,old.c, new.a,new.b,new.c);
69 INSERT INTO log VALUES('after', old.a,old.b,old.c, new.a,new.b,new.c);
129 UPDATE OR IGNORE t5 SET a = new.a, c = 10;
177 CREATE TRIGGER t2_trig AFTER INSERT ON t2 WHEN (new.a>0) BEGIN
178 INSERT INTO t2 VALUES(new.a - 1);
184 SELECT CASE WHEN new.a==2 THEN RAISE(IGNORE) ELSE NULL END;
185 INSERT INTO t2 VALUES(new.a - 1);
190 CREATE TRIGGER t2_trig BEFORE INSERT ON t2 WHEN (new.a>0) BEGIN
191 INSERT INTO t2 VALUES(new.a - 1);
197 SELECT CASE WHEN new.a==2 THEN RAISE(IGNORE) ELSE NULL END;
198 INSERT INTO t2 VALUES(new.a - 1);
204 INSERT INTO t2 VALUES(new.a - 1);
209 CREATE TRIGGER t2_trig AFTER INSERT ON t2 WHEN (new.a>0) BEGIN
210 INSERT OR IGNORE INTO t2 VALUES(new.a);
215 CREATE TRIGGER t2_trig BEFORE INSERT ON t2 WHEN (new.a>0) BEGIN
216 INSERT OR IGNORE INTO t2 VALUES(new.a);
254 INSERT INTO t23 VALUES(new.x + 1);
258 SELECT CASE WHEN new.x>[expr $SQLITE_MAX_TRIGGER_DEPTH / 2]
277 DELETE FROM t3 WHERE rowid = new.rowid;
294 CREATE TRIGGER t3bi AFTER INSERT ON t3b WHEN new.x<[expr $SQLITE_MAX_TRIGGER_DEPTH * 2] BEGIN
295 INSERT INTO t3b VALUES(new.x+1);
377 # 4. Insert new record.
381 # set to -1 in the new.* record. Even if it is explicitly set to NULL
389 # 4. Insert new record.
413 INSERT INTO log VALUES(new.rowid || ' ' || typeof(new.rowid) || ' ' ||
414 new.a || ' ' || typeof(new.a) || ' ' ||
415 new.b || ' ' || typeof(new.b) || ' ' ||
416 new.c || ' ' || typeof(new.c)
420 INSERT INTO log VALUES(new.rowid || ' ' || typeof(new.rowid) || ' ' ||
421 new.a || ' ' || typeof(new.a) || ' ' ||
422 new.b || ' ' || typeof(new.b) || ' ' ||
423 new.c || ' ' || typeof(new.c)
446 INSERT INTO log VALUES(new.rowid || ' ' || typeof(new.rowid) || ' ' ||
447 new.a || ' ' || typeof(new.a) || ' ' ||
448 new.b || ' ' || typeof(new.b) || ' ' ||
449 new.c || ' ' || typeof(new.c)
458 INSERT INTO log VALUES(new.rowid || ' ' || typeof(new.rowid) || ' ' ||
459 new.a || ' ' || typeof(new.a) || ' ' ||
460 new.b || ' ' || typeof(new.b) || ' ' ||
461 new.c || ' ' || typeof(new.c)
683 INSERT INTO t8 VALUES('after fired ' || old.rowid || '->' || new.rowid);
709 CREATE TRIGGER t7t BEFORE UPDATE ON t7 WHEN (old.rowid!=1 OR new.rowid!=8)
793 # by the values in the new.* array, even if those values were not
879 INSERT INTO log VALUES(new.a, new.b);
890 INSERT INTO log VALUES(new.a, new.b);
913 INSERT INTO log VALUES(new.a, new.b);
946 UPDATE t12 SET a=new.a+1, b=new.b+1;
1066 SELECT new.x;