Lines Matching +full:4 +full:c
26 c NOT NULL ON CONFLICT REPLACE DEFAULT 6,
36 INSERT INTO t1(a,b,c,d,e) VALUES(1,2,3,4,5);
39 } {0 {1 2 3 4 5}}
43 INSERT INTO t1(b,c,d,e) VALUES(2,3,4,5);
50 INSERT OR IGNORE INTO t1(b,c,d,e) VALUES(2,3,4,5);
57 INSERT OR REPLACE INTO t1(b,c,d,e) VALUES(2,3,4,5);
64 INSERT OR ABORT INTO t1(b,c,d,e) VALUES(2,3,4,5);
71 INSERT INTO t1(a,c,d,e) VALUES(1,3,4,5);
74 } {0 {1 5 3 4 5}}
78 INSERT OR IGNORE INTO t1(a,c,d,e) VALUES(1,3,4,5);
81 } {0 {1 5 3 4 5}}
85 INSERT OR REPLACE INTO t1(a,c,d,e) VALUES(1,3,4,5);
88 } {0 {1 5 3 4 5}}
92 INSERT OR ABORT INTO t1(a,c,d,e) VALUES(1,3,4,5);
95 } {0 {1 5 3 4 5}}
99 INSERT INTO t1(a,b,c,d,e) VALUES(1,null,3,4,5);
106 INSERT OR IGNORE INTO t1(a,b,c,d,e) VALUES(1,null,3,4,5);
113 INSERT OR REPLACE INTO t1(a,b,c,d,e) VALUES(1,null,3,4,5);
116 } {0 {1 5 3 4 5}}
120 INSERT INTO t1(a,b,c,d,e) VALUES(1,2,null,4,5);
123 } {0 {1 2 6 4 5}}
127 INSERT OR IGNORE INTO t1(a,b,c,d,e) VALUES(1,2,null,4,5);
134 INSERT OR REPLACE INTO t1(a,b,c,d,e) VALUES(1,2,null,4,5);
137 } {0 {1 2 6 4 5}}
141 INSERT OR ABORT INTO t1(a,b,c,d,e) VALUES(1,2,null,4,5);
144 } {1 {t1.c may not be NULL}}
148 INSERT OR ABORT INTO t1(a,b,c,d,e) VALUES(1,2,3,null,5);
155 INSERT OR ABORT INTO t1(a,b,c,e) VALUES(1,2,3,5);
162 INSERT INTO t1(a,b,c,d) VALUES(1,2,3,4);
165 } {0 {1 2 3 4 8}}
169 INSERT INTO t1(a,b,c,d,e) VALUES(1,2,3,4,null);
176 INSERT OR REPLACE INTO t1(e,d,c,b,a) VALUES(1,2,3,null,5);
184 INSERT INTO t1 VALUES(1,2,3,4,5);
192 INSERT INTO t1 VALUES(1,2,3,4,5);
200 INSERT INTO t1 VALUES(1,2,3,4,5);
204 } {0 {1 2 3 4 5}}
208 INSERT INTO t1 VALUES(1,2,3,4,5);
216 INSERT INTO t1 VALUES(1,2,3,4,5);
224 INSERT INTO t1 VALUES(1,2,3,4,5);
228 } {0 {1 5 3 5 4}}
232 INSERT INTO t1 VALUES(1,2,3,4,5);
236 } {0 {1 2 3 4 5}}
240 INSERT INTO t1 VALUES(1,2,3,4,5);
241 UPDATE t1 SET c=null, d=e, e=d;
244 } {0 {1 2 6 5 4}}
248 INSERT INTO t1 VALUES(1,2,3,4,5);
252 } {0 {1 2 3 4 5}}
256 INSERT INTO t1 VALUES(1,2,3,4,5);
266 CREATE INDEX t1c ON t1(c);
269 CREATE INDEX t1abc ON t1(a,b,c);
275 INSERT INTO t1(a,b,c,d,e) VALUES(1,2,3,4,5);
278 } {0 {1 2 3 4 5}}
282 INSERT INTO t1(b,c,d,e) VALUES(2,3,4,5);
289 INSERT OR IGNORE INTO t1(b,c,d,e) VALUES(2,3,4,5);
296 INSERT OR REPLACE INTO t1(b,c,d,e) VALUES(2,3,4,5);
303 INSERT OR ABORT INTO t1(b,c,d,e) VALUES(2,3,4,5);
310 INSERT INTO t1(a,c,d,e) VALUES(1,3,4,5);
313 } {0 {1 5 3 4 5}}
317 INSERT OR IGNORE INTO t1(a,c,d,e) VALUES(1,3,4,5);
320 } {0 {1 5 3 4 5}}
324 INSERT OR REPLACE INTO t1(a,c,d,e) VALUES(1,3,4,5);
327 } {0 {1 5 3 4 5}}
331 INSERT OR ABORT INTO t1(a,c,d,e) VALUES(1,3,4,5);
334 } {0 {1 5 3 4 5}}
338 INSERT INTO t1(a,b,c,d,e) VALUES(1,null,3,4,5);
345 INSERT OR IGNORE INTO t1(a,b,c,d,e) VALUES(1,null,3,4,5);
352 INSERT OR REPLACE INTO t1(a,b,c,d,e) VALUES(1,null,3,4,5);
355 } {0 {1 5 3 4 5}}
359 INSERT INTO t1(a,b,c,d,e) VALUES(1,2,null,4,5);
362 } {0 {1 2 6 4 5}}
366 INSERT OR IGNORE INTO t1(a,b,c,d,e) VALUES(1,2,null,4,5);
373 INSERT OR REPLACE INTO t1(a,b,c,d,e) VALUES(1,2,null,4,5);
376 } {0 {1 2 6 4 5}}
380 INSERT OR ABORT INTO t1(a,b,c,d,e) VALUES(1,2,null,4,5);
383 } {1 {t1.c may not be NULL}}
387 INSERT OR ABORT INTO t1(a,b,c,d,e) VALUES(1,2,3,null,5);
394 INSERT OR ABORT INTO t1(a,b,c,e) VALUES(1,2,3,5);
401 INSERT INTO t1(a,b,c,d) VALUES(1,2,3,4);
404 } {0 {1 2 3 4 8}}
408 INSERT INTO t1(a,b,c,d,e) VALUES(1,2,3,4,null);
415 INSERT OR REPLACE INTO t1(e,d,c,b,a) VALUES(1,2,3,null,5);
423 INSERT INTO t1 VALUES(1,2,3,4,5);
431 INSERT INTO t1 VALUES(1,2,3,4,5);
439 INSERT INTO t1 VALUES(1,2,3,4,5);
443 } {0 {1 2 3 4 5}}
447 INSERT INTO t1 VALUES(1,2,3,4,5);
455 INSERT INTO t1 VALUES(1,2,3,4,5);
463 INSERT INTO t1 VALUES(1,2,3,4,5);
467 } {0 {1 5 3 5 4}}
471 INSERT INTO t1 VALUES(1,2,3,4,5);
475 } {0 {1 2 3 4 5}}
479 INSERT INTO t1 VALUES(1,2,3,4,5);
480 UPDATE t1 SET c=null, d=e, e=d;
483 } {0 {1 2 6 5 4}}
487 INSERT INTO t1 VALUES(1,2,3,4,5);
491 } {0 {1 2 3 4 5}}
495 INSERT INTO t1 VALUES(1,2,3,4,5);