Lines Matching refs:new
139 CREATE TRIGGER ttt AFTER INSERT ON t4 WHEN new.y<0 BEGIN
160 {CREATE TRIGGER ttt AFTER INSERT ON t4 WHEN new.abc<0 BEGIN
349 proc do_rename_column_test {tn old new lSchema} {
369 do_execsql_test $tn.$i.2 "ALTER TABLE t1 RENAME $old TO $new"
373 } [string map [list $old $new] $lSorted]
377 foreach {tn old new lSchema} {
397 INSERT INTO t2 VALUES(new.a, new.b, new._x_);
404 INSERT INTO t1 VALUES(new.a, new.b, new._x_)
412 INSERT INTO t1 VALUES(new.a, new.b, new._x_)
417 do_rename_column_test 9.$tn $old $new $lSchema
427 foreach {tn old new lSchema} {
449 do_rename_column_test 10.$tn $old $new $lSchema
587 UPDATE data SET x=x+1 WHERE zzz=new.i;
593 INSERT INTO data(x, y) VALUES(new.i, new.t, 1)
600 INSERT INTO x1(i, t) VALUES(new.i+1, new.t||'1')
607 INSERT INTO nosuchtable VALUES(new.i, new.t);
696 INSERT INTO t2 VALUES(new.a, new.b, new.c)
736 INSERT INTO u8 VALUES(new.x, new.y, new.z);
746 INSERT INTO u8 VALUES(new.x, new.y, new.z);
760 INSERT INTO log VALUES(new.a);
814 CREATE TRIGGER tr1 AFTER INSERT ON t1 WHEN new.c IS NOT NULL BEGIN
825 } {{CREATE TRIGGER tr1 AFTER INSERT ON t1 WHEN new.d IS NOT NULL BEGIN
900 INSERT INTO t3(x,y) VALUES(new.a, new.b);
901 INSERT INTO t4(p) VALUES(new.c); -- no such table "t4"