Lines Matching refs:old

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);
73       INSERT INTO log VALUES('before', old.a,old.b,old.c, NULL,NULL,NULL);
76       INSERT INTO log VALUES('after', old.a,old.b,old.c, NULL,NULL,NULL);
280       INSERT INTO t3 VALUES(old.a, old.b);
427       INSERT INTO log VALUES(old.rowid || ' ' || typeof(old.rowid) || ' ' ||
428                              old.a     || ' ' || typeof(old.a)     || ' ' ||
429                              old.b     || ' ' || typeof(old.b)     || ' ' ||
430                              old.c     || ' ' || typeof(old.c)
434       INSERT INTO log VALUES(old.rowid || ' ' || typeof(old.rowid) || ' ' ||
435                              old.a     || ' ' || typeof(old.a)     || ' ' ||
436                              old.b     || ' ' || typeof(old.b)     || ' ' ||
437                              old.c     || ' ' || typeof(old.c)
441       INSERT INTO log VALUES(old.rowid || ' ' || typeof(old.rowid) || ' ' ||
442                              old.a     || ' ' || typeof(old.a)     || ' ' ||
443                              old.b     || ' ' || typeof(old.b)     || ' ' ||
444                              old.c     || ' ' || typeof(old.c)
453       INSERT INTO log VALUES(old.rowid || ' ' || typeof(old.rowid) || ' ' ||
454                              old.a     || ' ' || typeof(old.a)     || ' ' ||
455                              old.b     || ' ' || typeof(old.b)     || ' ' ||
456                              old.c     || ' ' || typeof(old.c)
571       INSERT INTO t5g VALUES(old.a, old.b, (SELECT count(*) FROM t5));
598       INSERT INTO t5g VALUES(old.a, old.b, (SELECT count(*) FROM t5));
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)
742       INSERT INTO t8 VALUES('after fired ' || old.rowid);
782       DELETE FROM t9 WHERE b=old.a;
806       UPDATE t10 SET updatecnt = updatecnt+1 WHERE rowid = old.rowid;
813   # 1 written to column "updatecnt" was clobbered by the old value 0).
838       UPDATE t11 SET c31 = c31+1, c32=c32+1 WHERE rowid = old.rowid;
851   # 1 written to column "updatecnt" was clobbered by the old value 0).
1012     DELETE FROM "node" WHERE pid = old."id";