Lines Matching refs:a1
43 CREATE TABLE a1(a, b);
56 1 "INSERT INTO a1 DEFAULT VALUES" {}
57 2 "INSERT INTO main.a1 DEFAULT VALUES" {}
58 3 "INSERT OR ROLLBACK INTO main.a1 DEFAULT VALUES" {}
59 4 "INSERT OR ROLLBACK INTO a1 DEFAULT VALUES" {}
60 5 "INSERT OR ABORT INTO main.a1 DEFAULT VALUES" {}
61 6 "INSERT OR ABORT INTO a1 DEFAULT VALUES" {}
62 7 "INSERT OR REPLACE INTO main.a1 DEFAULT VALUES" {}
63 8 "INSERT OR REPLACE INTO a1 DEFAULT VALUES" {}
64 9 "INSERT OR FAIL INTO main.a1 DEFAULT VALUES" {}
65 10 "INSERT OR FAIL INTO a1 DEFAULT VALUES" {}
66 11 "INSERT OR FAIL INTO main.a1 DEFAULT VALUES" {}
67 12 "INSERT OR IGNORE INTO a1 DEFAULT VALUES" {}
68 13 "REPLACE INTO a1 DEFAULT VALUES" {}
69 14 "REPLACE INTO main.a1 DEFAULT VALUES" {}
70 15 "INSERT INTO a1 VALUES(1, 2)" {}
71 16 "INSERT INTO main.a1 VALUES(1, 2)" {}
72 17 "INSERT OR ROLLBACK INTO main.a1 VALUES(1, 2)" {}
73 18 "INSERT OR ROLLBACK INTO a1 VALUES(1, 2)" {}
74 19 "INSERT OR ABORT INTO main.a1 VALUES(1, 2)" {}
75 20 "INSERT OR ABORT INTO a1 VALUES(1, 2)" {}
76 21 "INSERT OR REPLACE INTO main.a1 VALUES(1, 2)" {}
77 22 "INSERT OR REPLACE INTO a1 VALUES(1, 2)" {}
78 23 "INSERT OR FAIL INTO main.a1 VALUES(1, 2)" {}
79 24 "INSERT OR FAIL INTO a1 VALUES(1, 2)" {}
80 25 "INSERT OR FAIL INTO main.a1 VALUES(1, 2)" {}
81 26 "INSERT OR IGNORE INTO a1 VALUES(1, 2)" {}
82 27 "REPLACE INTO a1 VALUES(1, 2)" {}
83 28 "REPLACE INTO main.a1 VALUES(1, 2)" {}
84 29 "INSERT INTO a1 (b, a) VALUES(1, 2)" {}
85 30 "INSERT INTO main.a1 (b, a) VALUES(1, 2)" {}
86 31 "INSERT OR ROLLBACK INTO main.a1 (b, a) VALUES(1, 2)" {}
87 32 "INSERT OR ROLLBACK INTO a1 (b, a) VALUES(1, 2)" {}
88 33 "INSERT OR ABORT INTO main.a1 (b, a) VALUES(1, 2)" {}
89 34 "INSERT OR ABORT INTO a1 (b, a) VALUES(1, 2)" {}
90 35 "INSERT OR REPLACE INTO main.a1 (b, a) VALUES(1, 2)" {}
91 36 "INSERT OR REPLACE INTO a1 (b, a) VALUES(1, 2)" {}
92 37 "INSERT OR FAIL INTO main.a1 (b, a) VALUES(1, 2)" {}
93 38 "INSERT OR FAIL INTO a1 (b, a) VALUES(1, 2)" {}
94 39 "INSERT OR FAIL INTO main.a1 (b, a) VALUES(1, 2)" {}
95 40 "INSERT OR IGNORE INTO a1 (b, a) VALUES(1, 2)" {}
96 41 "REPLACE INTO a1 (b, a) VALUES(1, 2)" {}
97 42 "REPLACE INTO main.a1 (b, a) VALUES(1, 2)" {}
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" {}
126 71 "INSERT INTO a1 (b, a) VALUES(1, 2),(3,4)" {}
127 72 "INSERT INTO main.a1 (b, a) VALUES(1, 2),(3,4)" {}
128 73 "INSERT OR ROLLBACK INTO main.a1 (b, a) VALUES(1, 2),(3,4)" {}
129 74 "INSERT OR ROLLBACK INTO a1 (b, a) VALUES(1, 2),(3,4)" {}
130 75 "INSERT OR ABORT INTO main.a1 (b, a) VALUES(1, 2),(3,4)" {}
131 76 "INSERT OR ABORT INTO a1 (b, a) VALUES(1, 2),(3,4)" {}
132 77 "INSERT OR REPLACE INTO main.a1 (b, a) VALUES(1, 2),(3,4)" {}
133 78 "INSERT OR REPLACE INTO a1 (b, a) VALUES(1, 2),(3,4)" {}
134 79 "INSERT OR FAIL INTO main.a1 (b, a) VALUES(1, 2),(3,4)" {}
135 80 "INSERT OR FAIL INTO a1 (b, a) VALUES(1, 2),(3,4)" {}
136 81 "INSERT OR FAIL INTO main.a1 (b, a) VALUES(1, 2),(3,4)" {}
137 82 "INSERT OR IGNORE INTO a1 (b, a) VALUES(1, 2),(3,4)" {}
138 83 "REPLACE INTO a1 (b, a) VALUES(1, 2),(3,4)" {}
139 84 "REPLACE INTO main.a1 (b, a) VALUES(1, 2),(3,4)" {}
235 0 "SELECT count(*) FROM a1" {0}
238 1b "INSERT INTO a1 SELECT 1, 2" {}
239 1c "SELECT count(*) FROM a1" {1}
241 2a "SELECT count(*) FROM (SELECT b, a FROM a1)" {1}
242 2b "INSERT INTO a1 SELECT b, a FROM a1" {}
243 2c "SELECT count(*) FROM a1" {2}
245 3a "SELECT count(*) FROM (SELECT b, a FROM a1)" {2}
246 3b "INSERT INTO a1 SELECT b, a FROM a1" {}
247 3c "SELECT count(*) FROM a1" {4}
249 4a "SELECT count(*) FROM (SELECT b, a FROM a1)" {4}
250 4b "INSERT INTO a1 SELECT b, a FROM a1" {}
251 4c "SELECT count(*) FROM a1" {8}
253 4a "SELECT count(*) FROM (SELECT min(b), min(a) FROM a1)" {1}
254 4b "INSERT INTO a1 SELECT min(b), min(a) FROM a1" {}
255 4c "SELECT count(*) FROM a1" {9}
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}
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}
299 INSERT INTO a1 VALUES('x', 'y');
302 1 "INSERT INTO a1 SELECT a,b FROM a1 UNION SELECT b,a FROM a1 ORDER BY 1" {}
303 2 "INSERT INTO a1(b, a) SELECT * FROM a1 LIMIT 1" {}
304 3 "INSERT INTO a1 SELECT 'a'||a, 'b'||b FROM a1 LIMIT 2 OFFSET 1" {}
305 4 "INSERT INTO a1 SELECT * FROM a1 ORDER BY b, a" {}
306 S "SELECT * FROM a1" {
344 5.1 "INSERT INTO a1 DEFAULT VALUES" {}
345 5.2 "SELECT * FROM a1" {{} {}}
347 6.1 "INSERT INTO a1 DEFAULT VALUES" {}
348 6.2 "SELECT * FROM a1" {{} {} {} {}}
407 CREATE TRIGGER AFTER UPDATE ON a1 BEGIN
423 CREATE TRIGGER AFTER UPDATE ON a1 BEGIN