Home
last modified time | relevance | path

Searched refs:old (Results 1 – 25 of 89) sorted by relevance

1234

/sqlite-3.40.0/test/
H A DtriggerD.test45 INSERT INTO log VALUES('r3.old', old.rowid, old.oid, old._rowid_, old.x);
49 INSERT INTO log VALUES('r4.old', old.rowid, old.oid, old._rowid_, old.x);
53 INSERT INTO log VALUES('r5', old.rowid, old.oid, old._rowid_, old.x);
56 INSERT INTO log VALUES('r6', old.rowid, old.oid, old._rowid_, old.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}
95 INSERT INTO log VALUES('r3.old', old.rowid, old.oid, old._rowid_, old.x);
99 INSERT INTO log VALUES('r4.old', old.rowid, old.oid, old._rowid_, old.x);
103 INSERT INTO log VALUES('r5', old.rowid, old.oid, old._rowid_, old.x);
106 INSERT INTO log VALUES('r6', old.rowid, old.oid, old._rowid_, old.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}
H A DtriggerC.test66 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);
430 old.c || ' ' || typeof(old.c)
437 old.c || ' ' || typeof(old.c)
444 old.c || ' ' || typeof(old.c)
456 old.c || ' ' || typeof(old.c)
571 INSERT INTO t5g VALUES(old.a, old.b, (SELECT count(*) FROM t5));
[all …]
H A Dwithout_rowid4.test105 old.a, old.b,
114 old.a, old.b,
121 WHEN old.a = 1
124 old.a, old.b,
155 old.a, old.b,
164 old.a, old.b,
232 {UPDATE tbl SET b = old.b;}
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);
629 old.a, old.b, old.c, old.d, 0, 0, 0, 0);
[all …]
H A Dtrigger2.test101 old.a, old.b,
110 old.a, old.b,
117 WHEN old.a = 1
120 old.a, old.b,
151 old.a, old.b,
160 old.a, old.b,
228 {UPDATE tbl SET b = old.b;}
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);
625 old.a, old.b, old.c, old.d, 0, 0, 0, 0);
[all …]
H A DtriggerA.test91 INSERT INTO result2(a,b) VALUES(old.y, old.x);
101 INSERT INTO result4(a,b,c,d) VALUES(old.y, old.x, new.y, new.x);
113 INSERT INTO result2(a,b) VALUES(old.y, old.x);
123 INSERT INTO result4(a,b,c,d) VALUES(old.y, old.x, new.y, new.x);
135 INSERT INTO result1(a) VALUES(old.c1);
145 INSERT INTO result2(a,b) VALUES(old.c1, new.c1);
157 INSERT INTO result1(a) VALUES(old.c1);
167 INSERT INTO result2(a,b) VALUES(old.c1, new.c1);
179 INSERT INTO result2(a,b) VALUES(old.x, old.b);
189 INSERT INTO result4(a,b,c,d) VALUES(old.x, old.b, new.x, new.b);
H A DtriggerF.test27 INSERT INTO log VALUES(old.a || old.b || (SELECT count(*) FROM t1));
33 INSERT INTO log VALUES(old.a || old.b || (SELECT count(*) FROM t1));
39 INSERT INTO log VALUES(old.a || old.b || (SELECT count(*) FROM t1));
42 INSERT INTO log VALUES(old.a || old.b || (SELECT count(*) FROM t1));
H A Dtrigger9.test56 INSERT INTO t2 VALUES(old.rowid);
71 INSERT INTO t2 VALUES(old.x);
86 INSERT INTO t2 VALUES(old.rowid);
101 INSERT INTO t2 VALUES(old.rowid);
116 INSERT INTO t2 VALUES(old.x);
131 INSERT INTO t2 VALUES(old.x);
155 INSERT INTO t2 VALUES(old.a);
172 INSERT INTO t2 VALUES(old.a);
186 INSERT INTO t2 VALUES(old.a);
201 INSERT INTO t2 VALUES(old.a);
[all …]
H A Dupsert2.test84 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));
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 Dalter2.test190 # Test that triggers work when a short row is copied to the old.*
199 INSERT INTO blog VALUES(old.b, new.b);
236 INSERT INTO clog VALUES(old.c, new.c);
387 old.b||' '||typeof(old.b)||' '||old.c||' '||typeof(old.c)||' '||
417 old.b||' '||typeof(old.b)||' '||old.c||' '||typeof(old.c)
H A Dtriggerupfrom.test74 UPDATE t1 SET b=coalesce(old.b,old.c) FROM main.link WHERE a=t AND old.a=f;
135 '('||old.a||','||old.__hidden__b||')->('||new.a||','||new.__hidden__b||')'
H A DtriggerB.test82 INSERT INTO changes VALUES(old.a, old.c);
88 } {1 {no such column: old.c}}
123 WHEN old.c$i!=new.c$i BEGIN
124 INSERT INTO t3_changes VALUES($i, old.c$i, new.c$i);
H A Dtrigger5.test34 || coalesce(old.a,'NULL') || ',' || quote(old.b) || ',' || old.c || ');';
H A Dupfromfault.test39 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 Dimposter1.test57 old.rowid, quote(old.a), quote(old.b), quote(old.c),
58 quote(old.d)));
H A Dreturning1.test147 UPDATE t1 SET b=b+1 RETURNING old.b;
148 } {1 {no such column: old.b}}
181 INSERT INTO t1 VALUES(3) RETURNING a, (SELECT c FROM t2 WHERE old.a=t2.b) AS x;
182 } {1 {no such column: old.a}}
240 INSERT INTO log(op,x,y) VALUES('D1',old.a,old.b);
249 INSERT INTO log(op,x,y) VALUES('D3',old.e,old.f);
H A Dregexp2.test68 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.*';
105 # Test that trigger parameters (i.e. new.* and old.*) refs are not
113 DELETE FROM t6 WHERE t6.x REGEXP old.a;
H A Dschema4.test46 INSERT INTO log VALUES('after delete', old.a, old.b);
120 INSERT INTO log VALUES('after delete', old.a, old.b);
H A De_changes.test313 INSERT INTO log VALUES(old.b || ' -> ' || new.b || ' c = ' || changes() );
353 UPDATE t2 SET b=new.b WHERE a=old.a;
358 UPDATE t3 SET b=new.b WHERE a=old.a;
363 DELETE FROM t2 WHERE a=old.a AND b=old.b;
368 DELETE FROM t3 WHERE a=old.a AND b=old.b;
H A Dupfrom2.test48 INSERT INTO log VALUES(old.z || '->' || new.z);
51 INSERT INTO log VALUES(old.y || '->' || new.y);
143 INSERT INTO log VALUES(old.z || '->' || new.z);
146 INSERT INTO log VALUES(old.y || '->' || new.y);
303 INSERT INTO log VALUES(old.z || '->' || new.z);
H A Dwherelimit2.test41 INSERT INTO log VALUES('delete', old.a);
45 INSERT INTO log VALUES('update', old.a);
283 SELECT log(old."a b", old."c d");
H A Dwherelfault.test39 INSERT INTO log VALUES('delete', old.a);
43 INSERT INTO log VALUES('update', old.a);
/sqlite-3.40.0/ext/fts5/test/
H A Dfts5conflict.test46 VALUES('delete', old.a, old.b, old.c);
50 VALUES('delete', old.a, old.b, old.c);
H A Dfts5content.test116 VALUES('delete', old.a, old.b, old.c);
120 VALUES('delete', old.a, old.b, old.c);
/sqlite-3.40.0/ext/rbu/
H A Drburename.test27 proc my_rename {old new} {
28 lappend ::my_rename_calls [list [file tail $old] [file tail $new]]
29 file rename $old $new
43 proc my_rename {old new} {
/sqlite-3.40.0/ext/rtree/
H A DrtreeF.test23 # DELETE FROM t3 WHERE a=old.y;
40 DELETE FROM t3 WHERE a=old.y;

1234