Lines Matching refs:t1
23 CREATE TABLE t1 (
30 SELECT * FROM t1;
35 DELETE FROM t1;
36 INSERT INTO t1(a,b,c,d,e) VALUES(1,2,3,4,5);
37 SELECT * FROM t1 order by a;
42 DELETE FROM t1;
43 INSERT INTO t1(b,c,d,e) VALUES(2,3,4,5);
44 SELECT * FROM t1 order by a;
46 } {1 {t1.a may not be NULL}}
49 DELETE FROM t1;
50 INSERT OR IGNORE INTO t1(b,c,d,e) VALUES(2,3,4,5);
51 SELECT * FROM t1 order by a;
56 DELETE FROM t1;
57 INSERT OR REPLACE INTO t1(b,c,d,e) VALUES(2,3,4,5);
58 SELECT * FROM t1 order by a;
60 } {1 {t1.a may not be NULL}}
63 DELETE FROM t1;
64 INSERT OR ABORT INTO t1(b,c,d,e) VALUES(2,3,4,5);
65 SELECT * FROM t1 order by a;
67 } {1 {t1.a may not be NULL}}
70 DELETE FROM t1;
71 INSERT INTO t1(a,c,d,e) VALUES(1,3,4,5);
72 SELECT * FROM t1 order by a;
77 DELETE FROM t1;
78 INSERT OR IGNORE INTO t1(a,c,d,e) VALUES(1,3,4,5);
79 SELECT * FROM t1 order by a;
84 DELETE FROM t1;
85 INSERT OR REPLACE INTO t1(a,c,d,e) VALUES(1,3,4,5);
86 SELECT * FROM t1 order by a;
91 DELETE FROM t1;
92 INSERT OR ABORT INTO t1(a,c,d,e) VALUES(1,3,4,5);
93 SELECT * FROM t1 order by a;
98 DELETE FROM t1;
99 INSERT INTO t1(a,b,c,d,e) VALUES(1,null,3,4,5);
100 SELECT * FROM t1 order by a;
102 } {1 {t1.b may not be NULL}}
105 DELETE FROM t1;
106 INSERT OR IGNORE INTO t1(a,b,c,d,e) VALUES(1,null,3,4,5);
107 SELECT * FROM t1 order by a;
112 DELETE FROM t1;
113 INSERT OR REPLACE INTO t1(a,b,c,d,e) VALUES(1,null,3,4,5);
114 SELECT * FROM t1 order by a;
119 DELETE FROM t1;
120 INSERT INTO t1(a,b,c,d,e) VALUES(1,2,null,4,5);
121 SELECT * FROM t1 order by a;
126 DELETE FROM t1;
127 INSERT OR IGNORE INTO t1(a,b,c,d,e) VALUES(1,2,null,4,5);
128 SELECT * FROM t1 order by a;
133 DELETE FROM t1;
134 INSERT OR REPLACE INTO t1(a,b,c,d,e) VALUES(1,2,null,4,5);
135 SELECT * FROM t1 order by a;
140 DELETE FROM t1;
141 INSERT OR ABORT INTO t1(a,b,c,d,e) VALUES(1,2,null,4,5);
142 SELECT * FROM t1 order by a;
144 } {1 {t1.c may not be NULL}}
147 DELETE FROM t1;
148 INSERT OR ABORT INTO t1(a,b,c,d,e) VALUES(1,2,3,null,5);
149 SELECT * FROM t1 order by a;
151 } {1 {t1.d may not be NULL}}
154 DELETE FROM t1;
155 INSERT OR ABORT INTO t1(a,b,c,e) VALUES(1,2,3,5);
156 SELECT * FROM t1 order by a;
161 DELETE FROM t1;
162 INSERT INTO t1(a,b,c,d) VALUES(1,2,3,4);
163 SELECT * FROM t1 order by a;
168 DELETE FROM t1;
169 INSERT INTO t1(a,b,c,d,e) VALUES(1,2,3,4,null);
170 SELECT * FROM t1 order by a;
172 } {1 {t1.e may not be NULL}}
175 DELETE FROM t1;
176 INSERT OR REPLACE INTO t1(e,d,c,b,a) VALUES(1,2,3,null,5);
177 SELECT * FROM t1 order by a;
183 DELETE FROM t1;
184 INSERT INTO t1 VALUES(1,2,3,4,5);
185 UPDATE t1 SET a=null;
186 SELECT * FROM t1 ORDER BY a;
188 } {1 {t1.a may not be NULL}}
191 DELETE FROM t1;
192 INSERT INTO t1 VALUES(1,2,3,4,5);
193 UPDATE OR REPLACE t1 SET a=null;
194 SELECT * FROM t1 ORDER BY a;
196 } {1 {t1.a may not be NULL}}
199 DELETE FROM t1;
200 INSERT INTO t1 VALUES(1,2,3,4,5);
201 UPDATE OR IGNORE t1 SET a=null;
202 SELECT * FROM t1 ORDER BY a;
207 DELETE FROM t1;
208 INSERT INTO t1 VALUES(1,2,3,4,5);
209 UPDATE OR ABORT t1 SET a=null;
210 SELECT * FROM t1 ORDER BY a;
212 } {1 {t1.a may not be NULL}}
215 DELETE FROM t1;
216 INSERT INTO t1 VALUES(1,2,3,4,5);
217 UPDATE t1 SET b=null;
218 SELECT * FROM t1 ORDER BY a;
220 } {1 {t1.b may not be NULL}}
223 DELETE FROM t1;
224 INSERT INTO t1 VALUES(1,2,3,4,5);
225 UPDATE OR REPLACE t1 SET b=null, d=e, e=d;
226 SELECT * FROM t1 ORDER BY a;
231 DELETE FROM t1;
232 INSERT INTO t1 VALUES(1,2,3,4,5);
233 UPDATE OR IGNORE t1 SET b=null, d=e, e=d;
234 SELECT * FROM t1 ORDER BY a;
239 DELETE FROM t1;
240 INSERT INTO t1 VALUES(1,2,3,4,5);
241 UPDATE t1 SET c=null, d=e, e=d;
242 SELECT * FROM t1 ORDER BY a;
247 DELETE FROM t1;
248 INSERT INTO t1 VALUES(1,2,3,4,5);
249 UPDATE t1 SET d=null, a=b, b=a;
250 SELECT * FROM t1 ORDER BY a;
255 DELETE FROM t1;
256 INSERT INTO t1 VALUES(1,2,3,4,5);
257 UPDATE t1 SET e=null, a=b, b=a;
258 SELECT * FROM t1 ORDER BY a;
260 } {1 {t1.e may not be NULL}}
264 CREATE INDEX t1a ON t1(a);
265 CREATE INDEX t1b ON t1(b);
266 CREATE INDEX t1c ON t1(c);
267 CREATE INDEX t1d ON t1(d);
268 CREATE INDEX t1e ON t1(e);
269 CREATE INDEX t1abc ON t1(a,b,c);
274 DELETE FROM t1;
275 INSERT INTO t1(a,b,c,d,e) VALUES(1,2,3,4,5);
276 SELECT * FROM t1 order by a;
281 DELETE FROM t1;
282 INSERT INTO t1(b,c,d,e) VALUES(2,3,4,5);
283 SELECT * FROM t1 order by a;
285 } {1 {t1.a may not be NULL}}
288 DELETE FROM t1;
289 INSERT OR IGNORE INTO t1(b,c,d,e) VALUES(2,3,4,5);
290 SELECT * FROM t1 order by a;
295 DELETE FROM t1;
296 INSERT OR REPLACE INTO t1(b,c,d,e) VALUES(2,3,4,5);
297 SELECT * FROM t1 order by a;
299 } {1 {t1.a may not be NULL}}
302 DELETE FROM t1;
303 INSERT OR ABORT INTO t1(b,c,d,e) VALUES(2,3,4,5);
304 SELECT * FROM t1 order by a;
306 } {1 {t1.a may not be NULL}}
309 DELETE FROM t1;
310 INSERT INTO t1(a,c,d,e) VALUES(1,3,4,5);
311 SELECT * FROM t1 order by a;
316 DELETE FROM t1;
317 INSERT OR IGNORE INTO t1(a,c,d,e) VALUES(1,3,4,5);
318 SELECT * FROM t1 order by a;
323 DELETE FROM t1;
324 INSERT OR REPLACE INTO t1(a,c,d,e) VALUES(1,3,4,5);
325 SELECT * FROM t1 order by a;
330 DELETE FROM t1;
331 INSERT OR ABORT INTO t1(a,c,d,e) VALUES(1,3,4,5);
332 SELECT * FROM t1 order by a;
337 DELETE FROM t1;
338 INSERT INTO t1(a,b,c,d,e) VALUES(1,null,3,4,5);
339 SELECT * FROM t1 order by a;
341 } {1 {t1.b may not be NULL}}
344 DELETE FROM t1;
345 INSERT OR IGNORE INTO t1(a,b,c,d,e) VALUES(1,null,3,4,5);
346 SELECT * FROM t1 order by a;
351 DELETE FROM t1;
352 INSERT OR REPLACE INTO t1(a,b,c,d,e) VALUES(1,null,3,4,5);
353 SELECT * FROM t1 order by a;
358 DELETE FROM t1;
359 INSERT INTO t1(a,b,c,d,e) VALUES(1,2,null,4,5);
360 SELECT * FROM t1 order by a;
365 DELETE FROM t1;
366 INSERT OR IGNORE INTO t1(a,b,c,d,e) VALUES(1,2,null,4,5);
367 SELECT * FROM t1 order by a;
372 DELETE FROM t1;
373 INSERT OR REPLACE INTO t1(a,b,c,d,e) VALUES(1,2,null,4,5);
374 SELECT * FROM t1 order by a;
379 DELETE FROM t1;
380 INSERT OR ABORT INTO t1(a,b,c,d,e) VALUES(1,2,null,4,5);
381 SELECT * FROM t1 order by a;
383 } {1 {t1.c may not be NULL}}
386 DELETE FROM t1;
387 INSERT OR ABORT INTO t1(a,b,c,d,e) VALUES(1,2,3,null,5);
388 SELECT * FROM t1 order by a;
390 } {1 {t1.d may not be NULL}}
393 DELETE FROM t1;
394 INSERT OR ABORT INTO t1(a,b,c,e) VALUES(1,2,3,5);
395 SELECT * FROM t1 order by a;
400 DELETE FROM t1;
401 INSERT INTO t1(a,b,c,d) VALUES(1,2,3,4);
402 SELECT * FROM t1 order by a;
407 DELETE FROM t1;
408 INSERT INTO t1(a,b,c,d,e) VALUES(1,2,3,4,null);
409 SELECT * FROM t1 order by a;
411 } {1 {t1.e may not be NULL}}
414 DELETE FROM t1;
415 INSERT OR REPLACE INTO t1(e,d,c,b,a) VALUES(1,2,3,null,5);
416 SELECT * FROM t1 order by a;
422 DELETE FROM t1;
423 INSERT INTO t1 VALUES(1,2,3,4,5);
424 UPDATE t1 SET a=null;
425 SELECT * FROM t1 ORDER BY a;
427 } {1 {t1.a may not be NULL}}
430 DELETE FROM t1;
431 INSERT INTO t1 VALUES(1,2,3,4,5);
432 UPDATE OR REPLACE t1 SET a=null;
433 SELECT * FROM t1 ORDER BY a;
435 } {1 {t1.a may not be NULL}}
438 DELETE FROM t1;
439 INSERT INTO t1 VALUES(1,2,3,4,5);
440 UPDATE OR IGNORE t1 SET a=null;
441 SELECT * FROM t1 ORDER BY a;
446 DELETE FROM t1;
447 INSERT INTO t1 VALUES(1,2,3,4,5);
448 UPDATE OR ABORT t1 SET a=null;
449 SELECT * FROM t1 ORDER BY a;
451 } {1 {t1.a may not be NULL}}
454 DELETE FROM t1;
455 INSERT INTO t1 VALUES(1,2,3,4,5);
456 UPDATE t1 SET b=null;
457 SELECT * FROM t1 ORDER BY a;
459 } {1 {t1.b may not be NULL}}
462 DELETE FROM t1;
463 INSERT INTO t1 VALUES(1,2,3,4,5);
464 UPDATE OR REPLACE t1 SET b=null, d=e, e=d;
465 SELECT * FROM t1 ORDER BY a;
470 DELETE FROM t1;
471 INSERT INTO t1 VALUES(1,2,3,4,5);
472 UPDATE OR IGNORE t1 SET b=null, d=e, e=d;
473 SELECT * FROM t1 ORDER BY a;
478 DELETE FROM t1;
479 INSERT INTO t1 VALUES(1,2,3,4,5);
480 UPDATE t1 SET c=null, d=e, e=d;
481 SELECT * FROM t1 ORDER BY a;
486 DELETE FROM t1;
487 INSERT INTO t1 VALUES(1,2,3,4,5);
488 UPDATE t1 SET d=null, a=b, b=a;
489 SELECT * FROM t1 ORDER BY a;
494 DELETE FROM t1;
495 INSERT INTO t1 VALUES(1,2,3,4,5);
496 UPDATE t1 SET e=null, a=b, b=a;
497 SELECT * FROM t1 ORDER BY a;
499 } {1 {t1.e may not be NULL}}