Lines Matching refs:RETURNING
12 # focus of this file is the new RETURNING clause
21 INSERT INTO t1(b) VALUES(10),('happy'),(NULL) RETURNING a,b,c;
27 INSERT INTO t1(b,c) VALUES(5,99) RETURNING b,c,a,rowid;
33 INSERT INTO t1 DEFAULT VALUES RETURNING *;
43 INSERT INTO t1 SELECT * FROM t2 RETURNING *;
50 UPDATE t1 SET c='bellum' WHERE c='pax' RETURNING rowid, b, '|';
57 DELETE FROM t1 WHERE c='bellum' RETURNING rowid, *, '|';
71 RETURNING *;
83 RETURNING *, '|';
87 # Test RETURNING on a table with virtual columns.
96 UPDATE t2 SET b='123' WHERE b='abc' RETURNING (SELECT b FROM t1);
104 UPDATE t2 SET b='123' WHERE b='abc' RETURNING (SELECT b FROM t1);
110 UPDATE t2 SET b='123' WHERE b='abc' RETURNING b;
115 UPDATE t2 SET b='123' WHERE b='abc' RETURNING (SELECT b FROM t1);
125 UPDATE t1 SET id=id+y FROM t2 WHERE t1.id=t2.x RETURNING t2.*;
126 } {1 {RETURNING may not use "TABLE.*" wildcards}}
128 UPDATE t1 SET id=id+y FROM t2 WHERE t1.id=t2.x RETURNING *, '|';
133 # Do not silently ignore nonsense table names in the RETURNING clause.
144 UPDATE t1 SET b=b+1 RETURNING new.b;
147 UPDATE t1 SET b=b+1 RETURNING old.b;
150 UPDATE t1 SET b=b+1 RETURNING another.b;
153 UPDATE t1 SET b=b+y FROM t2 WHERE t2.x=t1.a RETURNING t2.x;
156 UPDATE t1 SET b=b+y FROM t2 WHERE t2.x=t1.a RETURNING t1.b;
159 # This is goofy: The RETURNING clause does not honor the alias
163 UPDATE t1 AS alias SET b=123 RETURNING alias.b;
166 UPDATE t1 AS alias SET b=alias.b+1000 RETURNING t1.b;
178 INSERT INTO t1 VALUES(3) RETURNING a, (SELECT c FROM t2 WHERE new.a=t2.b) AS x;
181 INSERT INTO t1 VALUES(3) RETURNING a, (SELECT c FROM t2 WHERE old.a=t2.b) AS x;
184 INSERT INTO t1 VALUES(3) RETURNING a, (SELECT c FROM t2 WHERE t1.a=t2.b) AS x;
190 UPDATE pragma_encoding SET encoding='UTF-8' RETURNING a, b, *;
216 INSERT INTO t1(a, b) VALUES(1234, 5678) RETURNING rowid;
220 UPDATE t1 SET a='z' WHERE b='y' RETURNING rowid;
254 INSERT INTO t1(a,b) VALUES(1,2),('happy','glad') RETURNING a, b, '|';
257 UPDATE t1 SET b=9 WHERE a=1 RETURNING a, b, 'x';
260 DELETE FROM t1 WHERE a<>'xray' RETURNING a, b, '@';
267 INSERT INTO t2 VALUES('bravo','charlie') RETURNING d, c, 'z';
274 INSERT INTO t3(e) VALUES(1),(2),(3) RETURNING 'I', e;
275 UPDATE t3 SET f=e+100 RETURNING 'U', e, f;
276 DELETE FROM t3 WHERE f>100 RETURNING 'D', e, f;
287 DELETE FROM t1 RETURNING *;
295 # RETURNING column names are dequoted.
302 db eval {INSERT INTO t1(x) VALUES(1) RETURNING "x";} cname {}
307 db eval {INSERT INTO t1(x) VALUES(2) RETURNING [x];} cname {}
312 db eval {INSERT INTO t1(x) VALUES(3) RETURNING x AS [xyz];} cname {}
317 db eval {INSERT INTO t1(x,y) VALUES(4,5) RETURNING "x"+"y";} cname {}
332 RETURNING (SELECT b FROM t2);
337 # Need to report foreign key constraint errors prior to RETURNING
346 INSERT INTO child(parent_id) VALUES(123) RETURNING id;
356 INSERT INTO t1(x) VALUES(5.0) RETURNING x, affinity(x);
359 UPDATE t1 SET x=x+1 RETURNING x, affinity(x);
362 DELETE FROM t1 RETURNING x, affinity(x);
366 # RETURNING with the xfer optimization
373 INSERT INTO t2 SELECT * FROM t1 RETURNING *;