Lines Matching refs:log

58     CREATE TABLE log(t, a1, b1, c1, a2, b2, c2);
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);
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);
83     SELECT * FROM log;
91     DELETE FROM log;
93     SELECT * FROM log;
101     DELETE FROM log;
103     SELECT * FROM log;
407   catchsql { DROP TABLE log }
410     CREATE TABLE log(t);
413       INSERT INTO log VALUES(new.rowid || ' ' || typeof(new.rowid) || ' ' ||
420       INSERT INTO log VALUES(new.rowid || ' ' || typeof(new.rowid) || ' ' ||
427       INSERT INTO log VALUES(old.rowid || ' ' || typeof(old.rowid) || ' ' ||
434       INSERT INTO log VALUES(old.rowid || ' ' || typeof(old.rowid) || ' ' ||
441       INSERT INTO log VALUES(old.rowid || ' ' || typeof(old.rowid) || ' ' ||
446       INSERT INTO log VALUES(new.rowid || ' ' || typeof(new.rowid) || ' ' ||
453       INSERT INTO log VALUES(old.rowid || ' ' || typeof(old.rowid) || ' ' ||
458       INSERT INTO log VALUES(new.rowid || ' ' || typeof(new.rowid) || ' ' ||
466 foreach {n insert log} {
549       DELETE FROM log;
551       SELECT * FROM log ORDER BY rowid;
553   } [join $log " "]
864   catchsql { DROP TABLE log }
865   execsql  { CREATE TABLE log(a, b) }
875     execsql { DELETE FROM log }
879         INSERT INTO log VALUES(new.a, new.b);
882       SELECT * FROM log;
887     execsql { DELETE FROM log }
890         INSERT INTO log VALUES(new.a, new.b);
893       SELECT * FROM log;
899     execsql { DELETE FROM log }
902       SELECT * FROM log;
909     DELETE FROM log;
913       INSERT INTO log VALUES(new.a, new.b);
916     SELECT a, b, a IS NULL, b IS NULL FROM log;