Lines Matching refs:a2
44 CREATE TABLE a2(a, b, c DEFAULT 'xyz');
98 43 "INSERT INTO a1 SELECT c, b FROM a2" {}
99 44 "INSERT INTO main.a1 SELECT c, b FROM a2" {}
100 45 "INSERT OR ROLLBACK INTO main.a1 SELECT c, b FROM a2" {}
101 46 "INSERT OR ROLLBACK INTO a1 SELECT c, b FROM a2" {}
102 47 "INSERT OR ABORT INTO main.a1 SELECT c, b FROM a2" {}
103 48 "INSERT OR ABORT INTO a1 SELECT c, b FROM a2" {}
104 49 "INSERT OR REPLACE INTO main.a1 SELECT c, b FROM a2" {}
105 50 "INSERT OR REPLACE INTO a1 SELECT c, b FROM a2" {}
106 51 "INSERT OR FAIL INTO main.a1 SELECT c, b FROM a2" {}
107 52 "INSERT OR FAIL INTO a1 SELECT c, b FROM a2" {}
108 53 "INSERT OR FAIL INTO main.a1 SELECT c, b FROM a2" {}
109 54 "INSERT OR IGNORE INTO a1 SELECT c, b FROM a2" {}
110 55 "REPLACE INTO a1 SELECT c, b FROM a2" {}
111 56 "REPLACE INTO main.a1 SELECT c, b FROM a2" {}
112 57 "INSERT INTO a1 (b, a) SELECT c, b FROM a2" {}
113 58 "INSERT INTO main.a1 (b, a) SELECT c, b FROM a2" {}
114 59 "INSERT OR ROLLBACK INTO main.a1 (b, a) SELECT c, b FROM a2" {}
115 60 "INSERT OR ROLLBACK INTO a1 (b, a) SELECT c, b FROM a2" {}
116 61 "INSERT OR ABORT INTO main.a1 (b, a) SELECT c, b FROM a2" {}
117 62 "INSERT OR ABORT INTO a1 (b, a) SELECT c, b FROM a2" {}
118 63 "INSERT OR REPLACE INTO main.a1 (b, a) SELECT c, b FROM a2" {}
119 64 "INSERT OR REPLACE INTO a1 (b, a) SELECT c, b FROM a2" {}
120 65 "INSERT OR FAIL INTO main.a1 (b, a) SELECT c, b FROM a2" {}
121 66 "INSERT OR FAIL INTO a1 (b, a) SELECT c, b FROM a2" {}
122 67 "INSERT OR FAIL INTO main.a1 (b, a) SELECT c, b FROM a2" {}
123 68 "INSERT OR IGNORE INTO a1 (b, a) SELECT c, b FROM a2" {}
124 69 "REPLACE INTO a1 (b, a) SELECT c, b FROM a2" {}
125 70 "REPLACE INTO main.a1 (b, a) SELECT c, b FROM a2" {}
148 0 "SELECT count(*) FROM a2" {0}
150 1a "INSERT INTO a2 VALUES(1, 2, 3)" {}
151 1b "SELECT count(*) FROM a2" {1}
153 2a "INSERT INTO a2(a, b) VALUES(1, 2)" {}
154 2b "SELECT count(*) FROM a2" {2}
156 3a "INSERT INTO a2(a) VALUES(3),(4)" {}
157 3b "SELECT count(*) FROM a2" {4}
165 # correct number of columns (for table a2, 3 columns) works. So these
171 1 "INSERT INTO a2 VALUES(1)" {a2 3 1}
172 2 "INSERT INTO a2 VALUES(1,2)" {a2 3 2}
173 3 "INSERT INTO a2 VALUES(1,2,3,4)" {a2 3 4}
174 4 "INSERT INTO a2 VALUES(1,2,3,4,5)" {a2 3 5}
184 1a "INSERT INTO a2 VALUES(1, 2, 3)" {}
185 1b "SELECT * FROM a2 WHERE oid=last_insert_rowid()" {1 2 3}
187 2a "INSERT INTO a2 VALUES('abc', NULL, 3*3+1)" {}
188 2b "SELECT * FROM a2 WHERE oid=last_insert_rowid()" {abc {} 10}
190 3a "INSERT INTO a2 VALUES((SELECT count(*) FROM a2), 'x', 'y')" {}
191 3b "SELECT * FROM a2 WHERE oid=last_insert_rowid()" {2 x y}
201 1 "INSERT INTO a2(a, b, c) VALUES(1)" {1 3}
202 2 "INSERT INTO a2(a, b, c) VALUES(1,2)" {2 3}
203 3 "INSERT INTO a2(a, b, c) VALUES(1,2,3,4)" {4 3}
204 4 "INSERT INTO a2(a, b, c) VALUES(1,2,3,4,5)" {5 3}
206 5 "INSERT INTO a2(c, a) VALUES(1)" {1 2}
207 6 "INSERT INTO a2(c, a) VALUES(1,2,3)" {3 2}
208 7 "INSERT INTO a2(c, a) VALUES(1,2,3,4)" {4 2}
209 8 "INSERT INTO a2(c, a) VALUES(1,2,3,4,5)" {5 2}
223 1a "INSERT INTO a2(b, c) VALUES('b', 'c')" {}
224 1b "SELECT * FROM a2" {{} b c}
226 2a "INSERT INTO a2(a, b) VALUES('a', 'b')" {}
227 2b "SELECT * FROM a2" {{} b c a b xyz}
266 1 "INSERT INTO a3(x, y) SELECT a, b, c FROM a2" {3 2}
267 2 "INSERT INTO a3(x, y) SELECT * FROM a2" {3 2}
268 3 "INSERT INTO a3(x, y) SELECT * FROM a2 CROSS JOIN a1" {5 2}
269 4 "INSERT INTO a3(x, y) SELECT * FROM a2 NATURAL JOIN a1" {3 2}
270 5 "INSERT INTO a3(x, y) SELECT a2.a FROM a2,a1" {1 2}
272 6 "INSERT INTO a3(z) SELECT a, b, c FROM a2" {3 1}
273 7 "INSERT INTO a3(z) SELECT * FROM a2" {3 1}
274 8 "INSERT INTO a3(z) SELECT * FROM a2 CROSS JOIN a1" {5 1}
275 9 "INSERT INTO a3(z) SELECT * FROM a2 NATURAL JOIN a1" {3 1}
276 10 "INSERT INTO a3(z) SELECT a1.* FROM a2,a1" {2 1}
286 1 "INSERT INTO a1 SELECT a, b, c FROM a2" {a1 2 3}
287 2 "INSERT INTO a1 SELECT * FROM a2" {a1 2 3}
288 3 "INSERT INTO a1 SELECT * FROM a2 CROSS JOIN a1" {a1 2 5}
289 4 "INSERT INTO a1 SELECT * FROM a2 NATURAL JOIN a1" {a1 2 3}
290 5 "INSERT INTO a1 SELECT a2.a FROM a2,a1" {a1 2 1}
338 3.1 "INSERT INTO a2 DEFAULT VALUES" {}
339 3.2 "SELECT * FROM a2" {{} {} xyz}
341 4.1 "INSERT INTO a2 DEFAULT VALUES" {}
342 4.2 "SELECT * FROM a2" {{} {} xyz {} {} xyz}