Home
last modified time | relevance | path

Searched refs:CONFLICT (Results 1 – 25 of 48) sorted by relevance

12

/sqlite-3.40.0/test/
H A Dupsert5.test307 ON CONFLICT(c) DO NOTHING
308 ON CONFLICT(d) DO NOTHING
316 ON CONFLICT(c) DO NOTHING
317 ON CONFLICT(d) DO NOTHING
325 ON CONFLICT(c) DO NOTHING
346 ON CONFLICT DO NOTHING;
355 ON CONFLICT DO NOTHING;
364 ON CONFLICT DO NOTHING;
373 ON CONFLICT DO NOTHING;
382 ON CONFLICT DO NOTHING;
[all …]
H A Dupsert4.test59 INSERT INTO t1 VALUES(2, NULL, 'zero') ON CONFLICT (a)
68 INSERT INTO t1 VALUES(2, NULL, 'zero') ON CONFLICT (a)
74 INSERT INTO t1 VALUES(1, NULL, NULL) ON CONFLICT (a)
111 1 "ON CONFLICT (b COLLATE nocase, c, d) DO NOTHING" 0
112 2 "ON CONFLICT (b, c, d) DO NOTHING" 0
113 3 "ON CONFLICT (b, c COLLATE nocase, d) DO NOTHING" 2
114 4 "ON CONFLICT (a) DO NOTHING" 1
218 ON CONFLICT (('x' || x) COLLATE nocase) DO NOTHING;
308 INSERT INTO t1 VALUES('c', 3, 3, 1) ON CONFLICT(z)
379 ON CONFLICT(x, [a b]) WHERE y=1
[all …]
H A Dupsert1.test88 ON CONFLICT(b) WHERE b>10 DO NOTHING;
99 ON CONFLICT(a) DO UPDATE SET b=b+1;
145 ON CONFLICT(e) DO UPDATE SET c=excluded.c;
152 ON CONFLICT(a) DO UPDATE SET c=excluded.c;
159 ON CONFLICT(b) DO UPDATE SET c=excluded.c;
170 ON CONFLICT(e) DO UPDATE SET c=excluded.c;
177 ON CONFLICT(a) DO UPDATE SET c=excluded.c;
184 ON CONFLICT(b) DO UPDATE SET c=excluded.c;
195 ON CONFLICT(e) DO UPDATE SET c=excluded.c;
202 ON CONFLICT(a) DO UPDATE SET c=excluded.c;
[all …]
H A Dconflict3.test32 b UNIQUE ON CONFLICT IGNORE,
33 c UNIQUE ON CONFLICT FAIL
62 b UNIQUE ON CONFLICT IGNORE,
63 c UNIQUE ON CONFLICT FAIL
93 c UNIQUE ON CONFLICT FAIL
122 c UNIQUE ON CONFLICT FAIL,
153 c UNIQUE ON CONFLICT FAIL
181 c UNIQUE ON CONFLICT FAIL,
213 c UNIQUE ON CONFLICT FAIL
243 c UNIQUE ON CONFLICT FAIL
[all …]
H A Dupsert2.test22 ON CONFLICT(a) DO UPDATE SET b=excluded.b, c=c+1 WHERE t1.b<excluded.b;
30 ON CONFLICT(a) DO UPDATE SET b=excluded.b, c=c+1 WHERE t1.b<excluded.b;
66 # On an ON CONFLICT DO UPDATE, the before-insert, before-update, and
94 ON CONFLICT(a) DO UPDATE SET c=t1.c+1;
98 # On an ON CONFLICT DO NOTHING, only the before-insert trigger fires.
102 INSERT INTO t1(a,b) VALUES(1,2) ON CONFLICT DO NOTHING;
112 ON CONFLICT(a) DO UPDATE SET c=c+1 WHERE c<0;
145 ON CONFLICT(a) DO UPDATE SET c=t1.c+1;
149 # On an ON CONFLICT DO NOTHING, only the before-insert trigger fires.
153 INSERT INTO t1(a,b) VALUES(1,2) ON CONFLICT DO NOTHING;
[all …]
H A Dupsert3.test25 ON CONFLICT(k) DO NOTHING;
26 } {1 {ON CONFLICT clause does not match any PRIMARY KEY or UNIQUE constraint}}
29 ON CONFLICT(v) DO NOTHING;
30 } {1 {ON CONFLICT clause does not match any PRIMARY KEY or UNIQUE constraint}}
34 ON CONFLICT(k,v) DO NOTHING;
39 ON CONFLICT(v,k) DO NOTHING;
47 ON CONFLICT(b,a) DO UPDATE SET c=excluded.c+1;
52 ON CONFLICT(b,a) DO UPDATE SET c=excluded.c+1 WHERE base.c<excluded.c;
H A Dinsert4.test421 CREATE TABLE t1(a INTEGER PRIMARY KEY ON CONFLICT IGNORE, b);
422 CREATE TABLE t2(x INTEGER PRIMARY KEY ON CONFLICT IGNORE, y);
433 CREATE TABLE t1(a INTEGER PRIMARY KEY ON CONFLICT IGNORE, b);
445 CREATE TABLE t1(a INTEGER PRIMARY KEY ON CONFLICT FAIL, b);
446 CREATE TABLE t2(x INTEGER PRIMARY KEY ON CONFLICT FAIL, y);
465 CREATE TABLE t1(a INTEGER PRIMARY KEY ON CONFLICT ABORT, b);
466 CREATE TABLE t2(x INTEGER PRIMARY KEY ON CONFLICT ABORT, y);
533 CREATE TABLE t1(a INTEGER PRIMARY KEY ON CONFLICT ABORT, b);
534 CREATE TABLE t2(x INTEGER PRIMARY KEY ON CONFLICT ABORT, y);
544 CREATE TABLE t1(a INTEGER PRIMARY KEY ON CONFLICT FAIL, b);
[all …]
H A Dwithout_rowid5.test194 # NOT NULL ON CONFLICT clauses work on WITHOUT ROWID tables now.
200 a INT NOT NULL ON CONFLICT ROLLBACK,
217 a INT NOT NULL ON CONFLICT ABORT,
235 a INT NOT NULL ON CONFLICT FAIL,
250 a INT NOT NULL ON CONFLICT IGNORE,
263 a INT NOT NULL ON CONFLICT REPLACE DEFAULT 3,
H A Dauth3.test127 key TEXT NOT NULL ON CONFLICT FAIL UNIQUE ON CONFLICT REPLACE,
128 value TEXT NOT NULL ON CONFLICT FAIL);
H A Dconflict.test192 if {$conf1!=""} {set conf1 "ON CONFLICT $conf1"}
246 if {$conf1!=""} {set conf1 "ON CONFLICT $conf1"}
319 if {$conf1!=""} {set conf1 "ON CONFLICT $conf1"}
462 a INTEGER UNIQUE ON CONFLICT IGNORE,
463 b INTEGER UNIQUE ON CONFLICT FAIL,
464 c INTEGER UNIQUE ON CONFLICT REPLACE,
465 d INTEGER UNIQUE ON CONFLICT ABORT,
466 e INTEGER UNIQUE ON CONFLICT ROLLBACK
839 # that it adds ON CONFLICT REPLACE. Verify that the indexes end up
848 UNIQUE(x,x) ON CONFLICT REPLACE
H A Dtkt-4a03edc4c8.test23 a INTEGER PRIMARY KEY ON CONFLICT REPLACE,
24 b UNIQUE ON CONFLICT FAIL
H A Dconflict2.test192 if {$conf1!=""} {set conf1 "ON CONFLICT $conf1"}
246 if {$conf1!=""} {set conf1 "ON CONFLICT $conf1"}
325 if {$conf1!=""} {set conf1 "ON CONFLICT $conf1"}
463 a INTEGER PRIMARY KEY ON CONFLICT IGNORE,
464 b INTEGER UNIQUE ON CONFLICT FAIL,
465 c INTEGER UNIQUE ON CONFLICT REPLACE,
466 d INTEGER UNIQUE ON CONFLICT ABORT,
467 e INTEGER UNIQUE ON CONFLICT ROLLBACK
H A De_createtable.test1528 CREATE TABLE t1_ab(a PRIMARY KEY ON CONFLICT ABORT, b);
1530 CREATE TABLE t1_ig(a PRIMARY KEY ON CONFLICT IGNORE, b);
1531 CREATE TABLE t1_fa(a PRIMARY KEY ON CONFLICT FAIL, b);
1532 CREATE TABLE t1_re(a PRIMARY KEY ON CONFLICT REPLACE, b);
1543 CREATE TABLE t2_ab(a, b NOT NULL ON CONFLICT ABORT);
1544 CREATE TABLE t2_ro(a, b NOT NULL ON CONFLICT ROLLBACK);
1545 CREATE TABLE t2_ig(a, b NOT NULL ON CONFLICT IGNORE);
1546 CREATE TABLE t2_fa(a, b NOT NULL ON CONFLICT FAIL);
1547 CREATE TABLE t2_re(a, b NOT NULL ON CONFLICT REPLACE);
1561 CREATE TABLE t3_fa(a, b, UNIQUE(a, b) ON CONFLICT FAIL);
[all …]
H A Dtrigger2.test43 # 6. ON CONFLICT clause handling
483 # Handling of ON CONFLICT by INSERT statements inside triggers
536 # Handling of ON CONFLICT by UPDATE statements inside triggers
786 ON CONFLICT(b,a) DO NOTHING
787 ON CONFLICT DO UPDATE SET b=?1;
H A Dmemdb.test178 if {$conf!=""} {set conf "ON CONFLICT $conf"}
245 if {$conf1!=""} {set conf1 "ON CONFLICT $conf1"}
246 if {$conf2!=""} {set conf2 "ON CONFLICT $conf2"}
H A Dindex.test660 # implemented by a single indice, the correct ON CONFLICT policy applies.
665 CREATE TABLE t8(a UNIQUE PRIMARY KEY ON CONFLICT ROLLBACK);
697 a PRIMARY KEY ON CONFLICT FAIL,
698 UNIQUE(a) ON CONFLICT IGNORE
701 } {1 {conflicting ON CONFLICT clauses specified}}
H A Dupsertfault.test30 INSERT INTO t1 VALUES(3, 2, 2, NULL) ON CONFLICT(b, c) DO
H A Daltercol.test405 ON CONFLICT (_x_) WHERE _x_>10 DO UPDATE SET _x_ = _x_+1;
413 ON CONFLICT (_x_) WHERE _x_>10 DO NOTHING;
594 ON CONFLICT (x) DO UPDATE SET z=zz+1;
601 ON CONFLICT (tttttt) DO UPDATE SET t=i+1;
697 ON CONFLICT(d) DO UPDATE SET f = excluded.f;
H A Dnulls1.test100 ON CONFLICT (b DESC NULLS LAST) DO UPDATE SET a = a+1 } LAST
104 ON CONFLICT (b DESC NULLS FIRST) DO UPDATE SET a = a+1;
H A Dnotnull.test30 c NOT NULL ON CONFLICT REPLACE DEFAULT 6,
31 d NOT NULL ON CONFLICT IGNORE DEFAULT 7,
32 e NOT NULL ON CONFLICT ABORT DEFAULT 8
/sqlite-3.40.0/tool/
H A Dmkkeywordhash.c87 # define CONFLICT 0 macro
89 # define CONFLICT 0x00000080 macro
173 { "ABORT", "TK_ABORT", CONFLICT|TRIGGER, 0 },
197 { "CONFLICT", "TK_CONFLICT", CONFLICT, 0 },
224 { "FAIL", "TK_FAIL", CONFLICT|TRIGGER, 1 },
238 { "IGNORE", "TK_IGNORE", CONFLICT|TRIGGER, 1 },
288 { "REPLACE", "TK_REPLACE", CONFLICT, 10 },
/sqlite-3.40.0/ext/session/
H A Dsessionstat1.test257 {INSERT sqlite_stat1 CONFLICT {t t1 t i1 t {3 1}} {t t1 t i1 t {2 1}}}
258 {INSERT sqlite_stat1 CONFLICT {t t1 t i2 t {3 1}} {t t1 t i2 t {2 1}}}
294 {INSERT sqlite_stat1 CONFLICT {t t3 b {} t 3} {t t3 b {} t 2}}
H A Dsession1.test244 {INSERT t1 CONFLICT {i 6 t six} {i 6 t VI}}
359 UPDATE t1 SET a = 10 WHERE a = 7; -- CONFLICT conflict
361 {INSERT t1 CONFLICT {i 10 i 8 i 9} {i 10 t x t x}}
395 {INSERT {'foolish name'} CONFLICT {t one t two i 2} {t one t two t i}}
454 {INSERT t1 CONFLICT {t A t B} {t a t b}}
H A Dsessionat.test145 {INSERT t4 CONFLICT {i 4 i 11} {i 4 i 5}}
153 {INSERT t4 CONFLICT {i 1 i 11} {i 1 i 2}}
H A Dsession2.test528 # 1. Have a changeset insert a row that causes a CONFLICT callback,
535 # CONSTRAINT, not a CONFLICT. There is at most one CONFLICT callback for
540 if {$type == "CONFLICT"} { return REPLACE }

12