Lines Matching refs:d
27 d NOT NULL ON CONFLICT IGNORE DEFAULT 7,
36 INSERT INTO t1(a,b,c,d,e) VALUES(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);
78 INSERT OR IGNORE INTO t1(a,c,d,e) VALUES(1,3,4,5);
85 INSERT OR REPLACE INTO t1(a,c,d,e) VALUES(1,3,4,5);
92 INSERT OR ABORT INTO t1(a,c,d,e) VALUES(1,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);
120 INSERT INTO t1(a,b,c,d,e) VALUES(1,2,null,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);
141 INSERT OR ABORT INTO t1(a,b,c,d,e) VALUES(1,2,null,4,5);
148 INSERT OR ABORT INTO t1(a,b,c,d,e) VALUES(1,2,3,null,5);
151 } {1 {t1.d may not be NULL}}
162 INSERT INTO t1(a,b,c,d) VALUES(1,2,3,4);
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);
225 UPDATE OR REPLACE t1 SET b=null, d=e, e=d;
233 UPDATE OR IGNORE t1 SET b=null, d=e, e=d;
241 UPDATE t1 SET c=null, d=e, e=d;
249 UPDATE t1 SET d=null, a=b, b=a;
267 CREATE INDEX t1d ON t1(d);
275 INSERT INTO t1(a,b,c,d,e) VALUES(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);
317 INSERT OR IGNORE INTO t1(a,c,d,e) VALUES(1,3,4,5);
324 INSERT OR REPLACE INTO t1(a,c,d,e) VALUES(1,3,4,5);
331 INSERT OR ABORT INTO t1(a,c,d,e) VALUES(1,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);
359 INSERT INTO t1(a,b,c,d,e) VALUES(1,2,null,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);
380 INSERT OR ABORT INTO t1(a,b,c,d,e) VALUES(1,2,null,4,5);
387 INSERT OR ABORT INTO t1(a,b,c,d,e) VALUES(1,2,3,null,5);
390 } {1 {t1.d may not be NULL}}
401 INSERT INTO t1(a,b,c,d) VALUES(1,2,3,4);
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);
464 UPDATE OR REPLACE t1 SET b=null, d=e, e=d;
472 UPDATE OR IGNORE t1 SET b=null, d=e, e=d;
480 UPDATE t1 SET c=null, d=e, e=d;
488 UPDATE t1 SET d=null, a=b, b=a;