Lines Matching refs:t1
27 CREATE TABLE t1 (
34 SELECT * FROM t1;
39 DELETE FROM t1;
40 INSERT INTO t1(a,b,c,d,e) VALUES(1,2,3,4,5);
41 SELECT * FROM t1 order by a;
46 DELETE FROM t1;
47 INSERT INTO t1(b,c,d,e) VALUES(2,3,4,5);
48 SELECT * FROM t1 order by a;
50 } {1 {NOT NULL constraint failed: t1.a}}
54 DELETE FROM t1;
55 INSERT OR IGNORE INTO t1(b,c,d,e) VALUES(2,3,4,5);
56 SELECT * FROM t1 order by a;
61 DELETE FROM t1;
62 INSERT OR REPLACE INTO t1(b,c,d,e) VALUES(2,3,4,5);
63 SELECT * FROM t1 order by a;
65 } {1 {NOT NULL constraint failed: t1.a}}
69 DELETE FROM t1;
70 INSERT OR ABORT INTO t1(b,c,d,e) VALUES(2,3,4,5);
71 SELECT * FROM t1 order by a;
73 } {1 {NOT NULL constraint failed: t1.a}}
77 DELETE FROM t1;
78 INSERT 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 IGNORE 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 REPLACE INTO t1(a,c,d,e) VALUES(1,3,4,5);
93 SELECT * FROM t1 order by a;
98 DELETE FROM t1;
99 INSERT OR ABORT INTO t1(a,c,d,e) VALUES(1,3,4,5);
100 SELECT * FROM t1 order by a;
105 DELETE FROM t1;
106 INSERT INTO t1(a,b,c,d,e) VALUES(1,null,3,4,5);
107 SELECT * FROM t1 order by a;
109 } {1 {NOT NULL constraint failed: t1.b}}
113 DELETE FROM t1;
114 INSERT OR IGNORE INTO t1(a,b,c,d,e) VALUES(1,null,3,4,5);
115 SELECT * FROM t1 order by a;
120 DELETE FROM t1;
121 INSERT OR REPLACE INTO t1(a,b,c,d,e) VALUES(1,null,3,4,5);
122 SELECT * FROM t1 order by a;
127 DELETE FROM t1;
128 INSERT INTO t1(a,b,c,d,e) VALUES(1,2,null,4,5);
129 SELECT * FROM t1 order by a;
134 DELETE FROM t1;
135 INSERT OR IGNORE INTO t1(a,b,c,d,e) VALUES(1,2,null,4,5);
136 SELECT * FROM t1 order by a;
141 DELETE FROM t1;
142 INSERT OR REPLACE INTO t1(a,b,c,d,e) VALUES(1,2,null,4,5);
143 SELECT * FROM t1 order by a;
148 DELETE FROM t1;
149 INSERT OR ABORT INTO t1(a,b,c,d,e) VALUES(1,2,null,4,5);
150 SELECT * FROM t1 order by a;
152 } {1 {NOT NULL constraint failed: t1.c}}
156 DELETE FROM t1;
157 INSERT OR ABORT INTO t1(a,b,c,d,e) VALUES(1,2,3,null,5);
158 SELECT * FROM t1 order by a;
160 } {1 {NOT NULL constraint failed: t1.d}}
164 DELETE FROM t1;
165 INSERT OR ABORT INTO t1(a,b,c,e) VALUES(1,2,3,5);
166 SELECT * FROM t1 order by a;
171 DELETE FROM t1;
172 INSERT INTO t1(a,b,c,d) VALUES(1,2,3,4);
173 SELECT * FROM t1 order by a;
178 DELETE FROM t1;
179 INSERT INTO t1(a,b,c,d,e) VALUES(1,2,3,4,null);
180 SELECT * FROM t1 order by a;
182 } {1 {NOT NULL constraint failed: t1.e}}
186 DELETE FROM t1;
187 INSERT OR REPLACE INTO t1(e,d,c,b,a) VALUES(1,2,3,null,5);
188 SELECT * FROM t1 order by a;
194 DELETE FROM t1;
195 INSERT INTO t1 VALUES(1,2,3,4,5);
196 UPDATE t1 SET a=null;
197 SELECT * FROM t1 ORDER BY a;
199 } {1 {NOT NULL constraint failed: t1.a}}
203 DELETE FROM t1;
204 INSERT INTO t1 VALUES(1,2,3,4,5);
205 UPDATE OR REPLACE t1 SET a=null;
206 SELECT * FROM t1 ORDER BY a;
208 } {1 {NOT NULL constraint failed: t1.a}}
212 DELETE FROM t1;
213 INSERT INTO t1 VALUES(1,2,3,4,5);
214 UPDATE OR IGNORE t1 SET a=null;
215 SELECT * FROM t1 ORDER BY a;
220 DELETE FROM t1;
221 INSERT INTO t1 VALUES(1,2,3,4,5);
222 UPDATE OR ABORT t1 SET a=null;
223 SELECT * FROM t1 ORDER BY a;
225 } {1 {NOT NULL constraint failed: t1.a}}
229 DELETE FROM t1;
230 INSERT INTO t1 VALUES(1,2,3,4,5);
231 UPDATE t1 SET b=null;
232 SELECT * FROM t1 ORDER BY a;
234 } {1 {NOT NULL constraint failed: t1.b}}
238 DELETE FROM t1;
239 INSERT INTO t1 VALUES(1,2,3,4,5);
240 UPDATE OR REPLACE t1 SET b=null, d=e, e=d;
241 SELECT * FROM t1 ORDER BY a;
246 DELETE FROM t1;
247 INSERT INTO t1 VALUES(1,2,3,4,5);
248 UPDATE OR IGNORE t1 SET b=null, d=e, e=d;
249 SELECT * FROM t1 ORDER BY a;
254 DELETE FROM t1;
255 INSERT INTO t1 VALUES(1,2,3,4,5);
256 UPDATE t1 SET c=null, d=e, e=d;
257 SELECT * FROM t1 ORDER BY a;
262 DELETE FROM t1;
263 INSERT INTO t1 VALUES(1,2,3,4,5);
264 UPDATE t1 SET d=null, a=b, b=a;
265 SELECT * FROM t1 ORDER BY a;
270 DELETE FROM t1;
271 INSERT INTO t1 VALUES(1,2,3,4,5);
272 UPDATE t1 SET e=null, a=b, b=a;
273 SELECT * FROM t1 ORDER BY a;
275 } {1 {NOT NULL constraint failed: t1.e}}
280 CREATE INDEX t1a ON t1(a);
281 CREATE INDEX t1b ON t1(b);
282 CREATE INDEX t1c ON t1(c);
283 CREATE INDEX t1d ON t1(d);
284 CREATE INDEX t1e ON t1(e);
285 CREATE INDEX t1abc ON t1(a,b,c);
290 DELETE FROM t1;
291 INSERT INTO t1(a,b,c,d,e) VALUES(1,2,3,4,5);
292 SELECT * FROM t1 order by a;
297 DELETE FROM t1;
298 INSERT INTO t1(b,c,d,e) VALUES(2,3,4,5);
299 SELECT * FROM t1 order by a;
301 } {1 {NOT NULL constraint failed: t1.a}}
305 DELETE FROM t1;
306 INSERT OR IGNORE INTO t1(b,c,d,e) VALUES(2,3,4,5);
307 SELECT * FROM t1 order by a;
312 DELETE FROM t1;
313 INSERT OR REPLACE INTO t1(b,c,d,e) VALUES(2,3,4,5);
314 SELECT * FROM t1 order by a;
316 } {1 {NOT NULL constraint failed: t1.a}}
320 DELETE FROM t1;
321 INSERT OR ABORT INTO t1(b,c,d,e) VALUES(2,3,4,5);
322 SELECT * FROM t1 order by a;
324 } {1 {NOT NULL constraint failed: t1.a}}
328 DELETE FROM t1;
329 INSERT INTO t1(a,c,d,e) VALUES(1,3,4,5);
330 SELECT * FROM t1 order by a;
335 DELETE FROM t1;
336 INSERT OR IGNORE INTO t1(a,c,d,e) VALUES(1,3,4,5);
337 SELECT * FROM t1 order by a;
342 DELETE FROM t1;
343 INSERT OR REPLACE INTO t1(a,c,d,e) VALUES(1,3,4,5);
344 SELECT * FROM t1 order by a;
349 DELETE FROM t1;
350 INSERT OR ABORT INTO t1(a,c,d,e) VALUES(1,3,4,5);
351 SELECT * FROM t1 order by a;
356 DELETE FROM t1;
357 INSERT INTO t1(a,b,c,d,e) VALUES(1,null,3,4,5);
358 SELECT * FROM t1 order by a;
360 } {1 {NOT NULL constraint failed: t1.b}}
364 DELETE FROM t1;
365 INSERT OR IGNORE INTO t1(a,b,c,d,e) VALUES(1,null,3,4,5);
366 SELECT * FROM t1 order by a;
371 DELETE FROM t1;
372 INSERT OR REPLACE INTO t1(a,b,c,d,e) VALUES(1,null,3,4,5);
373 SELECT * FROM t1 order by a;
378 DELETE FROM t1;
379 INSERT INTO t1(a,b,c,d,e) VALUES(1,2,null,4,5);
380 SELECT * FROM t1 order by a;
385 DELETE FROM t1;
386 INSERT OR IGNORE INTO t1(a,b,c,d,e) VALUES(1,2,null,4,5);
387 SELECT * FROM t1 order by a;
392 DELETE FROM t1;
393 INSERT OR REPLACE INTO t1(a,b,c,d,e) VALUES(1,2,null,4,5);
394 SELECT * FROM t1 order by a;
399 DELETE FROM t1;
400 INSERT OR ABORT INTO t1(a,b,c,d,e) VALUES(1,2,null,4,5);
401 SELECT * FROM t1 order by a;
403 } {1 {NOT NULL constraint failed: t1.c}}
407 DELETE FROM t1;
408 INSERT OR ABORT INTO t1(a,b,c,d,e) VALUES(1,2,3,null,5);
409 SELECT * FROM t1 order by a;
411 } {1 {NOT NULL constraint failed: t1.d}}
415 DELETE FROM t1;
416 INSERT OR ABORT INTO t1(a,b,c,e) VALUES(1,2,3,5);
417 SELECT * FROM t1 order by a;
422 DELETE FROM t1;
423 INSERT INTO t1(a,b,c,d) VALUES(1,2,3,4);
424 SELECT * FROM t1 order by a;
429 DELETE FROM t1;
430 INSERT INTO t1(a,b,c,d,e) VALUES(1,2,3,4,null);
431 SELECT * FROM t1 order by a;
433 } {1 {NOT NULL constraint failed: t1.e}}
437 DELETE FROM t1;
438 INSERT OR REPLACE INTO t1(e,d,c,b,a) VALUES(1,2,3,null,5);
439 SELECT * FROM t1 order by a;
445 DELETE FROM t1;
446 INSERT INTO t1 VALUES(1,2,3,4,5);
447 UPDATE t1 SET a=null;
448 SELECT * FROM t1 ORDER BY a;
450 } {1 {NOT NULL constraint failed: t1.a}}
454 DELETE FROM t1;
455 INSERT INTO t1 VALUES(1,2,3,4,5);
456 UPDATE OR REPLACE t1 SET a=null;
457 SELECT * FROM t1 ORDER BY a;
459 } {1 {NOT NULL constraint failed: t1.a}}
463 DELETE FROM t1;
464 INSERT INTO t1 VALUES(1,2,3,4,5);
465 UPDATE OR IGNORE t1 SET a=null;
466 SELECT * FROM t1 ORDER BY a;
471 DELETE FROM t1;
472 INSERT INTO t1 VALUES(1,2,3,4,5);
473 UPDATE OR ABORT t1 SET a=null;
474 SELECT * FROM t1 ORDER BY a;
476 } {1 {NOT NULL constraint failed: t1.a}}
480 DELETE FROM t1;
481 INSERT INTO t1 VALUES(1,2,3,4,5);
482 UPDATE t1 SET b=null;
483 SELECT * FROM t1 ORDER BY a;
485 } {1 {NOT NULL constraint failed: t1.b}}
489 DELETE FROM t1;
490 INSERT INTO t1 VALUES(1,2,3,4,5);
491 UPDATE OR REPLACE t1 SET b=null, d=e, e=d;
492 SELECT * FROM t1 ORDER BY a;
497 DELETE FROM t1;
498 INSERT INTO t1 VALUES(1,2,3,4,5);
499 UPDATE OR IGNORE t1 SET b=null, d=e, e=d;
500 SELECT * FROM t1 ORDER BY a;
505 DELETE FROM t1;
506 INSERT INTO t1 VALUES(1,2,3,4,5);
507 UPDATE t1 SET c=null, d=e, e=d;
508 SELECT * FROM t1 ORDER BY a;
513 DELETE FROM t1;
514 INSERT INTO t1 VALUES(1,2,3,4,5);
515 UPDATE t1 SET d=null, a=b, b=a;
516 SELECT * FROM t1 ORDER BY a;
521 DELETE FROM t1;
522 INSERT INTO t1 VALUES(1,2,3,4,5);
523 UPDATE t1 SET e=null, a=b, b=a;
524 SELECT * FROM t1 ORDER BY a;
526 } {1 {NOT NULL constraint failed: t1.e}}
533 DROP TABLE IF EXISTS t1;
534 CREATE TABLE t1(a, b NOT NULL);
542 INSERT INTO t1 VALUES(1, 2);
543 INSERT INTO t1 SELECT * FROM t2;
545 } {1 {NOT NULL constraint failed: t1.b}}
548 execsql { SELECT * FROM t1 }
552 DELETE FROM t1;
554 INSERT INTO t1 VALUES(1, 2);
555 INSERT INTO t1 SELECT * FROM t2;
558 } {1 {NOT NULL constraint failed: t1.b}}
561 execsql { SELECT * FROM t1 }
580 CREATE TABLE t1(a UNIQUE);
595 do_uses_op_next_test notnull-6.1 "SELECT * FROM t1 WHERE a IS ?" 1