Home
last modified time | relevance | path

Searched refs:new (Results 1 – 25 of 258) sorted by relevance

1234567891011

/sqlite-3.40.0/test/
H A DtriggerD.test39 INSERT INTO log VALUES('r1', new.rowid, new.oid, new._rowid_, new.x);
42 INSERT INTO log VALUES('r2', new.rowid, new.oid, new._rowid_, new.x);
46 INSERT INTO log VALUES('r3.new', new.rowid, new.oid, new._rowid_, new.x);
50 INSERT INTO log VALUES('r4.new', new.rowid, new.oid, new._rowid_, new.x);
72 } {r3.old 100 200 300 400 r3.new 101 200 300 400 r4.old 100 200 300 400 r4.new 101 200 300 400}
89 INSERT INTO log VALUES('r1', new.rowid, new.oid, new._rowid_, new.x);
92 INSERT INTO log VALUES('r2', new.rowid, new.oid, new._rowid_, new.x);
96 INSERT INTO log VALUES('r3.new', new.rowid, new.oid, new._rowid_, new.x);
100 INSERT INTO log VALUES('r4.new', new.rowid, new.oid, new._rowid_, new.x);
123 } {r3.old 1 1 1 200 r3.new 1 1 1 201 r4.old 1 1 1 200 r4.new 1 1 1 201}
[all …]
H A DtriggerC.test60 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);
416 new.c || ' ' || typeof(new.c)
423 new.c || ' ' || typeof(new.c)
449 new.c || ' ' || typeof(new.c)
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);
[all …]
H A Dtrigger2.test104 new.a, new.b);
113 new.a, new.b);
123 new.a, new.b);
188 new.a, new.b);
197 new.a, new.b);
447 INSERT INTO tbl VALUES (new.a, new.b, new.c);
616 old.a, old.b, old.c, old.d, new.a, new.b, new.c, new.d);
620 old.a, old.b, old.c, old.d, new.a, new.b, new.c, new.d);
634 0, 0, 0, 0, new.a, new.b, new.c, new.d);
638 0, 0, 0, 0, new.a, new.b, new.c, new.d);
[all …]
H A Dupsert2.test75 VALUES('before-insert',format('%d,%d,%d',new.a,new.b,new.c));
79 VALUES('after-insert',printf('%d,%d,%d',new.a,new.b,new.c));
84 old.a,old.b,old.c,new.a,new.b,new.c));
89 old.a,old.b,old.c,new.a,new.b,new.c));
126 VALUES('before-insert',format('%d,%d,%d',new.a,new.b,new.c));
130 VALUES('after-insert',printf('%d,%d,%d',new.a,new.b,new.c));
135 old.a,old.b,old.c,new.a,new.b,new.c));
140 old.a,old.b,old.c,new.a,new.b,new.c));
H A Dwithout_rowid4.test108 new.a, new.b);
117 new.a, new.b);
127 new.a, new.b);
192 new.a, new.b);
201 new.a, new.b);
425 INSERT INTO tblB values(new.a, new.b);
451 INSERT INTO tbl VALUES (new.a, new.b, new.c+1);
620 old.a, old.b, old.c, old.d, new.a, new.b, new.c, new.d);
624 old.a, old.b, old.c, old.d, new.a, new.b, new.c, new.d);
638 0, 0, 0, 0, new.a, new.b, new.c, new.d);
[all …]
H A Dtkt3554.test31 UPDATE test SET t1 = new.t1
32 WHERE obj = new.obj AND new.t1 < t1 AND new.t2 >= t1;
34 UPDATE test SET t2 = new.t2
35 WHERE obj = new.obj AND new.t2 > t2 AND new.t1 <= t2;
39 WHERE obj = new.obj AND new.t1 >= t1 AND new.t2 <= t2
H A Dregexp2.test33 new.a REGEXP 'abc',
34 new.b REGEXP 'abc',
35 new.c REGEXP 'abc'
41 new.a REGEXP 'def',
42 new.b REGEXP 'def',
43 new.c REGEXP 'def'
68 UPDATE t3 SET d = new.b WHERE c = old.a;
72 UPDATE t4 SET f = new.d WHERE e = old.c AND new.d REGEXP 'a.*';
76 SELECT CASE WHEN new.f REGEXP '.*y.*' THEN error() ELSE 1 END;
105 # Test that trigger parameters (i.e. new.* and old.*) refs are not
H A Dcollate6.test47 # Test that the default collation sequence applies to new.* references
52 WHEN new.a = 'a' BEGIN
53 INSERT INTO collate6log VALUES(new.a, new.b);
76 # Test that the default collation sequence applies to new.* references
81 INSERT INTO collate6log VALUES(new.a='a', new.b='b');
111 # one attached to a 'new' reference.
118 INSERT INTO def SELECT * FROM abc WHERE a < new.a COLLATE nocase;
133 INSERT INTO def SELECT * FROM abc WHERE a < new.a COLLATE nocase;
H A Daltercol.test377 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_)
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);
[all …]
H A Dreturning1.test12 # focus of this file is the new RETURNING clause
144 UPDATE t1 SET b=b+1 RETURNING new.b;
145 } {1 {no such column: new.b}}
178 INSERT INTO t1 VALUES(3) RETURNING a, (SELECT c FROM t2 WHERE new.a=t2.b) AS x;
179 } {1 {no such column: new.a}}
208 INSERT INTO log VALUES('insert', new.rowid, new.a, new.b);
211 INSERT INTO log VALUES('update', new.rowid, new.a, new.b);
237 INSERT INTO log(op,x,y) VALUES('I1',new.a,new.b);
243 INSERT INTO log(op,x,y) VALUES('U1',new.a,new.b);
246 INSERT INTO log(op,x,y) VALUES('I2',new.c,new.d);
[all …]
H A Dtrigger3.test31 WHEN (new.a = 4) THEN RAISE(IGNORE) END;
35 WHEN (new.a = 1) THEN RAISE(ABORT, 'Trigger abort')
36 WHEN (new.a = 2) THEN RAISE(FAIL, 'Trigger fail')
37 WHEN (new.a = 3) THEN RAISE(ROLLBACK, 'Trigger rollback') END;
150 INSERT INTO tbl2 VALUES (new.a, new.b, new.c);
168 SELECT CASE WHEN (new.a = 1) THEN RAISE(ROLLBACK, 'View rollback')
169 WHEN (new.a = 2) THEN RAISE(IGNORE)
170 WHEN (new.a = 3) THEN RAISE(ABORT, 'View abort') END;
H A Dupfrom2.test48 INSERT INTO log VALUES(old.z || '->' || new.z);
51 INSERT INTO log VALUES(old.y || '->' || new.y);
110 UPDATE t1 SET y=new.y, z=new.z WHERE x=new.x;
143 INSERT INTO log VALUES(old.z || '->' || new.z);
146 INSERT INTO log VALUES(old.y || '->' || new.y);
197 UPDATE o1 SET y=new.y, z=new.z WHERE w=new.w AND x=new.x;
300 INSERT INTO data VALUES(new.x, new.y, new.z);
303 INSERT INTO log VALUES(old.z || '->' || new.z);
395 INSERT INTO t3(x,y) VALUES(new.b,new.c);
H A Dtkt3201.test80 CREATE TRIGGER r4_1 AFTER INSERT ON t4 WHEN new.x=1 BEGIN
81 INSERT INTO t4_log(x) VALUES(new.x);
83 CREATE TRIGGER r4_2 AFTER INSERT ON t4 WHEN new.x=2 BEGIN
84 INSERT INTO t4_log(x) VALUES(new.x);
86 CREATE TRIGGER r4_3 AFTER INSERT ON t4 WHEN new.x=3 BEGIN
87 INSERT INTO t4_log(x) VALUES(new.x);
89 CREATE TRIGGER r4_4 AFTER INSERT ON t4 WHEN new.x=4 BEGIN
90 INSERT INTO t4_log(x) VALUES(new.x);
H A Dupfromfault.test36 INSERT INTO real VALUES(new.x, new.y, new.z);
39 INSERT INTO log VALUES(old.z || '->' || new.z);
40 UPDATE real SET y=new.y, z=new.z WHERE x=old.x;
61 INSERT INTO log VALUES(old.z || '->' || new.z);
64 INSERT INTO log VALUES(old.y || '->' || new.y);
H A Dfts4upfrom.test36 INSERT INTO real(rowid, a, b, c) VALUES(new.rowid, new.a, new.b, new.c);
39 UPDATE real SET rowid=new.rowid, a=new.a, b=new.b, c=new.c
H A Dtriggerupfrom.test24 UPDATE t1 SET c = v FROM map WHERE k=new.a AND a=new.a;
50 UPDATE t1 SET b = y FROM aux.t3 WHERE k=new.a;
56 UPDATE t1 SET b = y FROM aux.t3 WHERE a=new.a;
111 UPDATE t1 SET b=y FROM mmm WHERE x=new.a AND a=new.a;
135 '('||old.a||','||old.__hidden__b||')->('||new.a||','||new.__hidden__b||')'
H A Dalterqf.test67 SELECT max("str", new."a") FROM t1
75 SELECT max('str', new."a") FROM t1
101 UPDATE x1 SET two=new.three || "new" WHERE one=new.one||"";
115 UPDATE x1 SET "four"=new.three || 'new' WHERE one=new.one||'';
H A DtriggerG.test36 INSERT INTO t3 SELECT new.c+1 WHERE new.c<5;
37 INSERT INTO t2 SELECT new.c*100+a FROM t1 WHERE a IN (1, 2, 3, 4);
54 INSERT INTO t3 SELECT new.c+1 WHERE new.c<5;
55 INSERT INTO t2 SELECT new.c*10000+xx.a*100+yy.a
H A Dalterlegacy.test147 INSERT INTO t2 VALUES(new.x, new.y);
175 INSERT INTO t2 VALUES(new.x, new.y);
188 INSERT INTO t10 VALUES(new.a, new.b, new.c);
304 INSERT INTO t2 VALUES(new.a);
317 CREATE TRIGGER tr AFTER INSERT ON t1 WHEN new.a IS NULL BEGIN SELECT 1, 2, 3; END;
330 {CREATE TRIGGER tr AFTER INSERT ON "t3" WHEN new.a IS NULL BEGIN SELECT 1, 2, 3; END}
367 SELECT trigger(new.a, new.b, new.c);
403 INSERT INTO t1(a) VALUES(new.w);
H A Daltertab2.test28 INSERT INTO ff VALUES(new.a, new.b);
149 CREATE TRIGGER r1 AFTER INSERT ON t1 WHEN new.a NOT NULL BEGIN
158 {CREATE TRIGGER r1 AFTER INSERT ON "t1x" WHEN new.a NOT NULL BEGIN
167 {CREATE TRIGGER r1 AFTER INSERT ON "t1x" WHEN new.aaa NOT NULL BEGIN
176 {CREATE TRIGGER r1 AFTER INSERT ON "t1x" WHEN new.aaa NOT NULL BEGIN
185 CREATE TRIGGER r2 AFTER INSERT ON t2 WHEN new.a NOT NULL BEGIN
206 {CREATE TRIGGER r2 AFTER INSERT ON "t2x" WHEN new.a NOT NULL BEGIN
223 {CREATE TRIGGER r2 AFTER INSERT ON "t2x" WHEN new.aaaa NOT NULL BEGIN
245 CREATE TRIGGER r3 AFTER INSERT ON t3 WHEN new.a NOT NULL BEGIN
255 {CREATE TRIGGER r3 AFTER INSERT ON "t3x" WHEN new.a NOT NULL BEGIN
[all …]
H A Dschema4.test40 INSERT INTO log VALUES('after insert', new.a, new.b);
43 INSERT INTO log VALUES('after update', new.a, new.b);
117 INSERT INTO log VALUES('after insert', new.a, new.b);
144 INSERT INTO log VALUES('after update', new.a, new.b);
H A De_dropview.test97 CREATE VIEW "new view" AS SELECT * FROM t1 AS x, t1 AS y;
98 SELECT * FROM "new view";
101 SELECT * FROM sqlite_master WHERE name = 'new view';
103 view {new view} {new view} 0
104 {CREATE VIEW "new view" AS SELECT * FROM t1 AS x, t1 AS y}
107 DROP VIEW "new view";
108 SELECT * FROM sqlite_master WHERE name = 'new view';
111 SELECT * FROM "new view"
112 } {1 {no such table: new view}}
/sqlite-3.40.0/ext/fts5/test/
H A Dfts5connect.test39 # statement against the new schema.
98 INSERT INTO ft2(rowid, a, b) VALUES(new.rowid, new.a, new.b);
108 UPDATE ft2 SET a=new.a, b=new.b WHERE rowid=new.rowid;
149 INSERT INTO ft3(rowid, a, b) VALUES(new.rowid, new.a, new.b);
159 UPDATE ft3 SET a=new.a, b=new.b WHERE rowid=new.rowid;
200 INSERT INTO ft4(rowid, a, b) VALUES(new.rowid, new.a, new.b);
210 UPDATE ft4 SET a=new.a, b=new.b WHERE rowid=new.rowid;
H A Dfts5conflict.test42 INSERT INTO fts_idx(rowid, b, c) VALUES (new.a, new.b, new.c);
51 INSERT INTO fts_idx(rowid, b, c) VALUES (new.a, new.b, new.c);
/sqlite-3.40.0/ext/rtree/
H A Drtreeconnect.test35 INSERT INTO r1 VALUES(new.id, new.x1, new.x2, new.y1, new.y2);
36 INSERT INTO log VALUES('r1: ' || new.id);

1234567891011