Lines Matching refs:t1
19 1 { CREATE TABLE t1(a INTEGER PRIMARY KEY, b, c UNIQUE, d UNIQUE, e UNIQUE) }
20 2 { CREATE TABLE t1(a INT PRIMARY KEY, b, c UNIQUE, d UNIQUE, e UNIQUE) }
21 3 { CREATE TABLE t1(a INT PRIMARY KEY, b, c UNIQUE, d UNIQUE, e UNIQUE) WITHOUT ROWID}
22 4 { CREATE TABLE t1(e UNIQUE, d UNIQUE, c UNIQUE, a INTEGER PRIMARY KEY, b) }
23 5 { CREATE TABLE t1(e UNIQUE, d UNIQUE, c UNIQUE, a INT PRIMARY KEY, b) }
24 6 { CREATE TABLE t1(e UNIQUE, d UNIQUE, c UNIQUE, a INT PRIMARY KEY, b) WITHOUT ROWID}
30 DELETE FROM t1;
31 INSERT INTO t1(a,b,c,d,e) VALUES(1,2,3,4,5);
32 INSERT INTO t1(a,b,c,d,e) VALUES(1,NULL,3,4,5)
37 SELECT a,b,c,d,e FROM t1;
40 DELETE FROM t1;
41 INSERT INTO t1(a,b,c,d,e) VALUES(1,2,3,4,5);
42 INSERT INTO t1(a,b,c,d,e) VALUES(91,NULL,3,4,5)
47 SELECT a,b,c,d,e FROM t1;
50 DELETE FROM t1;
51 INSERT INTO t1(a,b,c,d,e) VALUES(1,2,3,4,5);
52 INSERT INTO t1(a,b,c,d,e) VALUES(91,NULL,93,4,5)
57 SELECT a,b,c,d,e FROM t1;
60 DELETE FROM t1;
61 INSERT INTO t1(a,b,c,d,e) VALUES(1,2,3,4,5);
62 INSERT INTO t1(a,b,c,d,e) VALUES(91,NULL,93,94,5)
67 SELECT a,b,c,d,e FROM t1;
70 DELETE FROM t1;
71 INSERT INTO t1(a,b,c,d,e) VALUES(1,2,3,4,5);
72 INSERT INTO t1(a,b,c,d,e) VALUES(1,NULL,93,94,95)
77 SELECT a,b,c,d,e FROM t1;
80 DELETE FROM t1;
81 INSERT INTO t1(a,b,c,d,e) VALUES(1,2,3,4,5);
82 INSERT INTO t1(a,b,c,d,e) VALUES(1,NULL,3,94,95)
87 SELECT a,b,c,d,e FROM t1;
90 DELETE FROM t1;
91 INSERT INTO t1(a,b,c,d,e) VALUES(1,2,3,4,5);
92 INSERT INTO t1(a,b,c,d,e) VALUES(1,NULL,3,4,5)
97 SELECT a,b,c,d,e FROM t1;
100 DELETE FROM t1;
101 INSERT INTO t1(a,b,c,d,e) VALUES(1,2,3,4,5);
102 INSERT INTO t1(a,b,c,d,e) VALUES(1,NULL,93,94,5)
107 SELECT a,b,c,d,e FROM t1;
110 DELETE FROM t1;
111 INSERT INTO t1(a,b,c,d,e) VALUES(1,2,3,4,5);
112 INSERT INTO t1(a,b,c,d,e) VALUES(1,NULL,93,4,95)
117 SELECT a,b,c,d,e FROM t1;
120 DELETE FROM t1;
121 INSERT INTO t1(a,b,c,d,e) VALUES(1,2,3,4,5);
122 INSERT INTO t1(a,b,c,d,e) VALUES(1,NULL,93,94,95)
127 SELECT a,b,c,d,e FROM t1;
130 DELETE FROM t1;
131 INSERT INTO t1(a,b,c,d,e) VALUES(1,2,3,4,5);
132 INSERT INTO t1(a,b,c,d,e) VALUES(1,NULL,93,4,95)
137 SELECT a,b,c,d,e FROM t1;
140 DELETE FROM t1;
141 INSERT INTO t1(a,b,c,d,e) VALUES(1,2,3,4,5);
142 INSERT INTO t1(a,b,c,d,e) VALUES(1,NULL,93,94,5)
147 SELECT a,b,c,d,e FROM t1;
150 DELETE FROM t1;
151 INSERT INTO t1(a,b,c,d,e) VALUES(1,2,3,4,5);
152 INSERT INTO t1(a,b,c,d,e) VALUES(91,NULL,93,94,5)
157 SELECT a,b,c,d,e FROM t1;
160 DELETE FROM t1;
161 INSERT INTO t1(a,b,c,d,e) VALUES(1,2,3,4,5);
162 INSERT INTO t1(a,b,c,d,e) VALUES(91,NULL,93,94,5)
167 SELECT a,b,c,d,e FROM t1;
170 DELETE FROM t1;
171 INSERT INTO t1(a,b,c,d,e) VALUES(1,2,3,4,5);
172 INSERT INTO t1(a,b,c,d,e) VALUES(1,NULL,93,94,5)
177 SELECT a,b,c,d,e FROM t1;
180 DELETE FROM t1;
181 INSERT INTO t1(a,b,c,d,e) VALUES(1,2,3,4,5);
182 INSERT INTO t1(a,b,c,d,e) VALUES(1,NULL,93,94,95)
187 SELECT a,b,c,d,e FROM t1;
191 DELETE FROM t1;
192 INSERT INTO t1(a,b,c,d,e) VALUES(1,2,3,4,5);
193 INSERT INTO t1(a,b,c,d,e) VALUES(1,NULL,93,94,95)
202 SELECT a,b,c,d,e FROM t1;
205 DELETE FROM t1;
206 INSERT INTO t1(a,b,c,d,e) VALUES(1,2,3,4,5);
207 INSERT INTO t1(a,b,c,d,e) VALUES(91,NULL,93,94,5)
216 SELECT a,b,c,d,e FROM t1;
220 DELETE FROM t1;
221 INSERT INTO t1(a,b,c,d,e) VALUES(1,2,3,4,5);
222 INSERT INTO t1(a,b,c,d,e) VALUES(1,NULL,93,94,95)
226 SELECT a,b,c,d,e FROM t1;
229 DELETE FROM t1;
230 INSERT INTO t1(a,b,c,d,e) VALUES(1,2,3,4,5);
231 INSERT INTO t1(a,b,c,d,e) VALUES(91,NULL,93,94,5)
235 SELECT a,b,c,d,e FROM t1;
238 DELETE FROM t1;
239 INSERT INTO t1(a,b,c,d,e) VALUES(1,2,3,4,5);
240 INSERT INTO t1(a,b,c,d,e) VALUES(1,NULL,93,94,95)
244 SELECT a,b,c,d,e FROM t1;
247 DELETE FROM t1;
248 INSERT INTO t1(a,b,c,d,e) VALUES(1,2,3,4,5);
249 INSERT INTO t1(a,b,c,d,e) VALUES(91,NULL,3,94,95)
253 SELECT a,b,c,d,e FROM t1;
256 DELETE FROM t1;
257 INSERT INTO t1(a,b,c,d,e) VALUES(1,2,3,4,5);
258 INSERT INTO t1(a,b,c,d,e) VALUES(91,NULL,3,4,95)
262 SELECT a,b,c,d,e FROM t1;
265 DELETE FROM t1;
266 INSERT INTO t1(a,b,c,d,e) VALUES(1,2,3,4,5);
267 INSERT INTO t1(a,b,c,d,e) VALUES(1,NULL,93,4,5)
271 SELECT a,b,c,d,e FROM t1;
275 DELETE FROM t1;
276 INSERT INTO t1(a,b,c,d,e) VALUES(1,2,3,4,5);
277 INSERT INTO t1(a,b,c,d,e) VALUES(1,NULL,93,94,95)
279 SELECT a,b,c,d,e FROM t1;
282 DELETE FROM t1;
283 INSERT INTO t1(a,b,c,d,e) VALUES(1,2,3,4,5);
284 INSERT INTO t1(a,b,c,d,e) VALUES(91,NULL,93,94,5)
286 SELECT a,b,c,d,e FROM t1;
289 DELETE FROM t1;
290 INSERT INTO t1(a,b,c,d,e) VALUES(1,2,3,4,5);
291 INSERT INTO t1(a,b,c,d,e) VALUES(91,NULL,93,4,95)
293 SELECT a,b,c,d,e FROM t1;
296 DELETE FROM t1;
297 INSERT INTO t1(a,b,c,d,e) VALUES(1,2,3,4,5);
298 INSERT INTO t1(a,b,c,d,e) VALUES(91,NULL,3,94,95)
300 SELECT a,b,c,d,e FROM t1;
304 DELETE FROM t1;
305 INSERT INTO t1(a,b,c,d,e) VALUES(1,2,3,4,5);
306 INSERT INTO t1(a,b,c,d,e) VALUES(1,NULL,93,94,95)
310 SELECT a,b,c,d,e FROM t1;
313 DELETE FROM t1;
314 INSERT INTO t1(a,b,c,d,e) VALUES(1,2,3,4,5);
315 INSERT INTO t1(a,b,c,d,e) VALUES(91,NULL,93,94,5)
319 SELECT a,b,c,d,e FROM t1;
322 DELETE FROM t1;
323 INSERT INTO t1(a,b,c,d,e) VALUES(1,2,3,4,5);
324 INSERT INTO t1(a,b,c,d,e) VALUES(91,NULL,93,4,95)
328 SELECT a,b,c,d,e FROM t1;
331 DELETE FROM t1;
332 INSERT INTO t1(a,b,c,d,e) VALUES(1,2,3,4,5);
333 INSERT INTO t1(a,b,c,d,e) VALUES(91,NULL,3,94,95)
337 SELECT a,b,c,d,e FROM t1;
341 DELETE FROM t1;
342 INSERT INTO t1(a,b,c,d,e) VALUES(1,2,3,4,5);
343 INSERT INTO t1(a,b,c,d,e) VALUES(1,NULL,93,94,95)
347 SELECT a,b,c,d,e FROM t1;
350 DELETE FROM t1;
351 INSERT INTO t1(a,b,c,d,e) VALUES(1,2,3,4,5);
352 INSERT INTO t1(a,b,c,d,e) VALUES(91,NULL,93,94,5)
356 SELECT a,b,c,d,e FROM t1;
359 DELETE FROM t1;
360 INSERT INTO t1(a,b,c,d,e) VALUES(1,2,3,4,5);
361 INSERT INTO t1(a,b,c,d,e) VALUES(1,NULL,93,94,95)
365 SELECT a,b,c,d,e FROM t1;
368 DELETE FROM t1;
369 INSERT INTO t1(a,b,c,d,e) VALUES(1,2,3,4,5);
370 INSERT INTO t1(a,b,c,d,e) VALUES(91,NULL,3,94,95)
374 SELECT a,b,c,d,e FROM t1;
377 DELETE FROM t1;
378 INSERT INTO t1(a,b,c,d,e) VALUES(1,2,3,4,5);
379 INSERT INTO t1(a,b,c,d,e) VALUES(91,NULL,3,4,95)
383 SELECT a,b,c,d,e FROM t1;
386 DELETE FROM t1;
387 INSERT INTO t1(a,b,c,d,e) VALUES(1,2,3,4,5);
388 INSERT INTO t1(a,b,c,d,e) VALUES(1,NULL,93,4,5)
392 SELECT a,b,c,d,e FROM t1;