Lines Matching refs:x1

230     CREATE TABLE x1(a INTEGER PRIMARY KEY, b) %WO%;
231     INSERT INTO x1 VALUES
244     UPDATE x1 SET b=y FROM data1 WHERE a=x ORDER BY a LIMIT 3;
245     SELECT * FROM x1;
251     UPDATE x1 SET b=b||y FROM data1 WHERE a=x ORDER BY b LIMIT 3;
252     SELECT * FROM x1;
259     UPDATE x1 SET b=b||b ORDER BY b;
262     UPDATE x1 SET b=b||y FROM data1 WHERE a=x ORDER BY b;
268     DROP TABLE x1;
269     CREATE TABLE x1(u, v, b, PRIMARY KEY(u, v)) %WO%;
270     INSERT INTO x1 VALUES
276     UPDATE x1 SET b=y FROM data1 WHERE (u*2+v)=x ORDER BY u, v LIMIT 3;
277     SELECT * FROM x1;
284     UPDATE x1 SET b=b||y FROM data1 WHERE (u*2+v)=x ORDER BY b LIMIT 3;
285     SELECT * FROM x1;
323     CREATE TABLE x1(a INT PRIMARY KEY, b, c) WITHOUT ROWID;
326     CREATE TABLE x1(a INTEGER PRIMARY KEY, b, c);
329     CREATE TABLE x1(a INT PRIMARY KEY, b, c);
337     INSERT INTO x1 VALUES(1, 1, 1);
338     INSERT INTO x1 VALUES(2, 2, 2);
339     INSERT INTO x1 VALUES(3, 3, 3);
340     INSERT INTO x1 VALUES(4, 4, 4);
341     INSERT INTO x1 VALUES(5, 5, 5);
347     UPDATE x1 SET a=t FROM map WHERE a=o;
348     SELECT * FROM x1 ORDER BY a;
354   CREATE TABLE x1(a, b, c);
359   1 "UPDATE x1 SET a=5 FROM x1" x1
360   2 "UPDATE x1 AS grapes SET a=5 FROM x1 AS grapes" grapes
361   3 "UPDATE x1 SET a=5 FROM x2, x1" x1
362   4 "UPDATE x1 AS grapes SET a=5 FROM x2, x1 AS grapes" grapes