Lines Matching refs:t1
25 CREATE TABLE t1 (
32 SELECT * FROM t1;
37 DELETE FROM t1;
38 INSERT INTO t1(a,b,c,d,e) VALUES(1,2,3,4,5);
39 SELECT * FROM t1 order by a;
44 DELETE FROM t1;
45 INSERT INTO t1(b,c,d,e) VALUES(2,3,4,5);
46 SELECT * FROM t1 order by a;
48 } {1 {t1.a may not be NULL}}
51 DELETE FROM t1;
52 INSERT OR IGNORE INTO t1(b,c,d,e) VALUES(2,3,4,5);
53 SELECT * FROM t1 order by a;
58 DELETE FROM t1;
59 INSERT OR REPLACE INTO t1(b,c,d,e) VALUES(2,3,4,5);
60 SELECT * FROM t1 order by a;
62 } {1 {t1.a may not be NULL}}
65 DELETE FROM t1;
66 INSERT OR ABORT INTO t1(b,c,d,e) VALUES(2,3,4,5);
67 SELECT * FROM t1 order by a;
69 } {1 {t1.a may not be NULL}}
72 DELETE FROM t1;
73 INSERT INTO t1(a,c,d,e) VALUES(1,3,4,5);
74 SELECT * FROM t1 order by a;
79 DELETE FROM t1;
80 INSERT OR IGNORE INTO t1(a,c,d,e) VALUES(1,3,4,5);
81 SELECT * FROM t1 order by a;
86 DELETE FROM t1;
87 INSERT OR REPLACE INTO t1(a,c,d,e) VALUES(1,3,4,5);
88 SELECT * FROM t1 order by a;
93 DELETE FROM t1;
94 INSERT OR ABORT INTO t1(a,c,d,e) VALUES(1,3,4,5);
95 SELECT * FROM t1 order by a;
100 DELETE FROM t1;
101 INSERT INTO t1(a,b,c,d,e) VALUES(1,null,3,4,5);
102 SELECT * FROM t1 order by a;
104 } {1 {t1.b may not be NULL}}
107 DELETE FROM t1;
108 INSERT OR IGNORE INTO t1(a,b,c,d,e) VALUES(1,null,3,4,5);
109 SELECT * FROM t1 order by a;
114 DELETE FROM t1;
115 INSERT OR REPLACE INTO t1(a,b,c,d,e) VALUES(1,null,3,4,5);
116 SELECT * FROM t1 order by a;
121 DELETE FROM t1;
122 INSERT INTO t1(a,b,c,d,e) VALUES(1,2,null,4,5);
123 SELECT * FROM t1 order by a;
128 DELETE FROM t1;
129 INSERT OR IGNORE INTO t1(a,b,c,d,e) VALUES(1,2,null,4,5);
130 SELECT * FROM t1 order by a;
135 DELETE FROM t1;
136 INSERT OR REPLACE INTO t1(a,b,c,d,e) VALUES(1,2,null,4,5);
137 SELECT * FROM t1 order by a;
142 DELETE FROM t1;
143 INSERT OR ABORT INTO t1(a,b,c,d,e) VALUES(1,2,null,4,5);
144 SELECT * FROM t1 order by a;
146 } {1 {t1.c may not be NULL}}
149 DELETE FROM t1;
150 INSERT OR ABORT INTO t1(a,b,c,d,e) VALUES(1,2,3,null,5);
151 SELECT * FROM t1 order by a;
153 } {1 {t1.d may not be NULL}}
156 DELETE FROM t1;
157 INSERT OR ABORT INTO t1(a,b,c,e) VALUES(1,2,3,5);
158 SELECT * FROM t1 order by a;
163 DELETE FROM t1;
164 INSERT INTO t1(a,b,c,d) VALUES(1,2,3,4);
165 SELECT * FROM t1 order by a;
170 DELETE FROM t1;
171 INSERT INTO t1(a,b,c,d,e) VALUES(1,2,3,4,null);
172 SELECT * FROM t1 order by a;
174 } {1 {t1.e may not be NULL}}
177 DELETE FROM t1;
178 INSERT OR REPLACE INTO t1(e,d,c,b,a) VALUES(1,2,3,null,5);
179 SELECT * FROM t1 order by a;
185 DELETE FROM t1;
186 INSERT INTO t1 VALUES(1,2,3,4,5);
187 UPDATE t1 SET a=null;
188 SELECT * FROM t1 ORDER BY a;
190 } {1 {t1.a may not be NULL}}
193 DELETE FROM t1;
194 INSERT INTO t1 VALUES(1,2,3,4,5);
195 UPDATE OR REPLACE t1 SET a=null;
196 SELECT * FROM t1 ORDER BY a;
198 } {1 {t1.a may not be NULL}}
201 DELETE FROM t1;
202 INSERT INTO t1 VALUES(1,2,3,4,5);
203 UPDATE OR IGNORE t1 SET a=null;
204 SELECT * FROM t1 ORDER BY a;
209 DELETE FROM t1;
210 INSERT INTO t1 VALUES(1,2,3,4,5);
211 UPDATE OR ABORT t1 SET a=null;
212 SELECT * FROM t1 ORDER BY a;
214 } {1 {t1.a may not be NULL}}
217 DELETE FROM t1;
218 INSERT INTO t1 VALUES(1,2,3,4,5);
219 UPDATE t1 SET b=null;
220 SELECT * FROM t1 ORDER BY a;
222 } {1 {t1.b may not be NULL}}
225 DELETE FROM t1;
226 INSERT INTO t1 VALUES(1,2,3,4,5);
227 UPDATE OR REPLACE t1 SET b=null, d=e, e=d;
228 SELECT * FROM t1 ORDER BY a;
233 DELETE FROM t1;
234 INSERT INTO t1 VALUES(1,2,3,4,5);
235 UPDATE OR IGNORE t1 SET b=null, d=e, e=d;
236 SELECT * FROM t1 ORDER BY a;
241 DELETE FROM t1;
242 INSERT INTO t1 VALUES(1,2,3,4,5);
243 UPDATE t1 SET c=null, d=e, e=d;
244 SELECT * FROM t1 ORDER BY a;
249 DELETE FROM t1;
250 INSERT INTO t1 VALUES(1,2,3,4,5);
251 UPDATE t1 SET d=null, a=b, b=a;
252 SELECT * FROM t1 ORDER BY a;
257 DELETE FROM t1;
258 INSERT INTO t1 VALUES(1,2,3,4,5);
259 UPDATE t1 SET e=null, a=b, b=a;
260 SELECT * FROM t1 ORDER BY a;
262 } {1 {t1.e may not be NULL}}
266 CREATE INDEX t1a ON t1(a);
267 CREATE INDEX t1b ON t1(b);
268 CREATE INDEX t1c ON t1(c);
269 CREATE INDEX t1d ON t1(d);
270 CREATE INDEX t1e ON t1(e);
271 CREATE INDEX t1abc ON t1(a,b,c);
276 DELETE FROM t1;
277 INSERT INTO t1(a,b,c,d,e) VALUES(1,2,3,4,5);
278 SELECT * FROM t1 order by a;
283 DELETE FROM t1;
284 INSERT INTO t1(b,c,d,e) VALUES(2,3,4,5);
285 SELECT * FROM t1 order by a;
287 } {1 {t1.a may not be NULL}}
290 DELETE FROM t1;
291 INSERT OR IGNORE INTO t1(b,c,d,e) VALUES(2,3,4,5);
292 SELECT * FROM t1 order by a;
297 DELETE FROM t1;
298 INSERT OR REPLACE INTO t1(b,c,d,e) VALUES(2,3,4,5);
299 SELECT * FROM t1 order by a;
301 } {1 {t1.a may not be NULL}}
304 DELETE FROM t1;
305 INSERT OR ABORT INTO t1(b,c,d,e) VALUES(2,3,4,5);
306 SELECT * FROM t1 order by a;
308 } {1 {t1.a may not be NULL}}
311 DELETE FROM t1;
312 INSERT INTO t1(a,c,d,e) VALUES(1,3,4,5);
313 SELECT * FROM t1 order by a;
318 DELETE FROM t1;
319 INSERT OR IGNORE INTO t1(a,c,d,e) VALUES(1,3,4,5);
320 SELECT * FROM t1 order by a;
325 DELETE FROM t1;
326 INSERT OR REPLACE INTO t1(a,c,d,e) VALUES(1,3,4,5);
327 SELECT * FROM t1 order by a;
332 DELETE FROM t1;
333 INSERT OR ABORT INTO t1(a,c,d,e) VALUES(1,3,4,5);
334 SELECT * FROM t1 order by a;
339 DELETE FROM t1;
340 INSERT INTO t1(a,b,c,d,e) VALUES(1,null,3,4,5);
341 SELECT * FROM t1 order by a;
343 } {1 {t1.b may not be NULL}}
346 DELETE FROM t1;
347 INSERT OR IGNORE INTO t1(a,b,c,d,e) VALUES(1,null,3,4,5);
348 SELECT * FROM t1 order by a;
353 DELETE FROM t1;
354 INSERT OR REPLACE INTO t1(a,b,c,d,e) VALUES(1,null,3,4,5);
355 SELECT * FROM t1 order by a;
360 DELETE FROM t1;
361 INSERT INTO t1(a,b,c,d,e) VALUES(1,2,null,4,5);
362 SELECT * FROM t1 order by a;
367 DELETE FROM t1;
368 INSERT OR IGNORE INTO t1(a,b,c,d,e) VALUES(1,2,null,4,5);
369 SELECT * FROM t1 order by a;
374 DELETE FROM t1;
375 INSERT OR REPLACE INTO t1(a,b,c,d,e) VALUES(1,2,null,4,5);
376 SELECT * FROM t1 order by a;
381 DELETE FROM t1;
382 INSERT OR ABORT INTO t1(a,b,c,d,e) VALUES(1,2,null,4,5);
383 SELECT * FROM t1 order by a;
385 } {1 {t1.c may not be NULL}}
388 DELETE FROM t1;
389 INSERT OR ABORT INTO t1(a,b,c,d,e) VALUES(1,2,3,null,5);
390 SELECT * FROM t1 order by a;
392 } {1 {t1.d may not be NULL}}
395 DELETE FROM t1;
396 INSERT OR ABORT INTO t1(a,b,c,e) VALUES(1,2,3,5);
397 SELECT * FROM t1 order by a;
402 DELETE FROM t1;
403 INSERT INTO t1(a,b,c,d) VALUES(1,2,3,4);
404 SELECT * FROM t1 order by a;
409 DELETE FROM t1;
410 INSERT INTO t1(a,b,c,d,e) VALUES(1,2,3,4,null);
411 SELECT * FROM t1 order by a;
413 } {1 {t1.e may not be NULL}}
416 DELETE FROM t1;
417 INSERT OR REPLACE INTO t1(e,d,c,b,a) VALUES(1,2,3,null,5);
418 SELECT * FROM t1 order by a;
424 DELETE FROM t1;
425 INSERT INTO t1 VALUES(1,2,3,4,5);
426 UPDATE t1 SET a=null;
427 SELECT * FROM t1 ORDER BY a;
429 } {1 {t1.a may not be NULL}}
432 DELETE FROM t1;
433 INSERT INTO t1 VALUES(1,2,3,4,5);
434 UPDATE OR REPLACE t1 SET a=null;
435 SELECT * FROM t1 ORDER BY a;
437 } {1 {t1.a may not be NULL}}
440 DELETE FROM t1;
441 INSERT INTO t1 VALUES(1,2,3,4,5);
442 UPDATE OR IGNORE t1 SET a=null;
443 SELECT * FROM t1 ORDER BY a;
448 DELETE FROM t1;
449 INSERT INTO t1 VALUES(1,2,3,4,5);
450 UPDATE OR ABORT t1 SET a=null;
451 SELECT * FROM t1 ORDER BY a;
453 } {1 {t1.a may not be NULL}}
456 DELETE FROM t1;
457 INSERT INTO t1 VALUES(1,2,3,4,5);
458 UPDATE t1 SET b=null;
459 SELECT * FROM t1 ORDER BY a;
461 } {1 {t1.b may not be NULL}}
464 DELETE FROM t1;
465 INSERT INTO t1 VALUES(1,2,3,4,5);
466 UPDATE OR REPLACE t1 SET b=null, d=e, e=d;
467 SELECT * FROM t1 ORDER BY a;
472 DELETE FROM t1;
473 INSERT INTO t1 VALUES(1,2,3,4,5);
474 UPDATE OR IGNORE t1 SET b=null, d=e, e=d;
475 SELECT * FROM t1 ORDER BY a;
480 DELETE FROM t1;
481 INSERT INTO t1 VALUES(1,2,3,4,5);
482 UPDATE t1 SET c=null, d=e, e=d;
483 SELECT * FROM t1 ORDER BY a;
488 DELETE FROM t1;
489 INSERT INTO t1 VALUES(1,2,3,4,5);
490 UPDATE t1 SET d=null, a=b, b=a;
491 SELECT * FROM t1 ORDER BY a;
496 DELETE FROM t1;
497 INSERT INTO t1 VALUES(1,2,3,4,5);
498 UPDATE t1 SET e=null, a=b, b=a;
499 SELECT * FROM t1 ORDER BY a;
501 } {1 {t1.e may not be NULL}}