Lines Matching refs:CONFLICT
33 INSERT INTO t1 VALUES(1, NULL, 'xyz') ON CONFLICT DO NOTHING;
40 INSERT INTO t1 VALUES(4, NULL, 'two') ON CONFLICT DO NOTHING;
47 INSERT INTO t1 VALUES(4, NULL, 'two') ON CONFLICT (c) DO UPDATE SET b = 1;
54 INSERT INTO t1 VALUES(2, NULL, 'zero') ON CONFLICT (a) DO UPDATE SET b=2;
59 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)
85 set rtbl(2) {1 {ON CONFLICT clause does not match any PRIMARY KEY or UNIQUE constraint}}
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
115 5 "ON CONFLICT DO NOTHING" 0
116 6 "ON CONFLICT (b, c, d) WHERE a!=0 DO NOTHING" 0
117 7 "ON CONFLICT (d, c, c) WHERE a!=0 DO NOTHING" 2
118 8 "ON CONFLICT (b COLLATE nocase, c COLLATE nocase, d) DO NOTHING" 2
119 9 "ON CONFLICT (b, c, d) WHERE b==45 DO NOTHING" 0
153 1 "ON CONFLICT DO NOTHING" 0
154 2 "ON CONFLICT ('x' || x) DO NOTHING" 0
155 3 "ON CONFLICT (('x' || x) COLLATE nocase) DO NOTHING" 0
156 4 "ON CONFLICT (('x' || x) COLLATE binary) DO NOTHING" 2
157 5 "ON CONFLICT (x || 'x') DO NOTHING" 2
158 6 "ON CONFLICT ((('x' || x))) DO NOTHING" 0
187 1 "ON CONFLICT DO NOTHING" 0
188 2 "ON CONFLICT(x) WHERE y>0 DO NOTHING" 0
189 3 "ON CONFLICT(x) DO NOTHING" 2
190 4 "ON CONFLICT(x) WHERE y>=0 DO NOTHING" 2
191 5 "ON CONFLICT(y) WHERE x='xyz' COLLATE nocase DO NOTHING" 1
203 1 "ON CONFLICT DO NOTHING" 0
204 2 "ON CONFLICT(y) WHERE x='xyz' COLLATE nocase DO NOTHING" 0
205 3 "ON CONFLICT(y) WHERE x='xyz' COLLATE binary DO NOTHING" 2
206 4 "ON CONFLICT(x) WHERE y>0 DO NOTHING" 1
218 ON CONFLICT (('x' || x) COLLATE nocase) DO NOTHING;
219 } {1 {ON CONFLICT clause does not match any PRIMARY KEY or UNIQUE constraint}}
222 # Test that ON CONFLICT constraint processing occurs before any REPLACE
241 INSERT OR REPLACE INTO t1 VALUES(1, 2, 'two') ON CONFLICT(b) DO NOTHING;
260 INSERT OR REPLACE INTO t1 VALUES(3, 1, 1) ON CONFLICT(b) DO NOTHING;
266 INSERT OR REPLACE INTO t1 VALUES(3, 2, 2) ON CONFLICT(c) DO NOTHING;
272 INSERT OR REPLACE INTO t1 VALUES(3, 1, 1) ON CONFLICT(b)
279 INSERT OR REPLACE INTO t1 VALUES(3, 2, 2) ON CONFLICT(c)
308 INSERT INTO t1 VALUES('c', 3, 3, 1) ON CONFLICT(z)
314 INSERT INTO t1 VALUES('c', 2, 2, 3) ON CONFLICT(y, x)
320 INSERT INTO t1 VALUES('c', 2, 2, 3) ON CONFLICT(y, x)
326 INSERT INTO t1 AS tbl VALUES('c', 2, 2, 3) ON CONFLICT(y, x)
354 INSERT INTO excluded VALUES('hello', 1, 1, NULL) ON CONFLICT(x, "a b")
360 INSERT INTO excluded AS x1 VALUES('hello', 1, 1, NULL) ON CONFLICT(x, [a b])
366 INSERT INTO excluded AS x1 VALUES('hello', 1, 1, NULL) ON CONFLICT(x, [a b])
372 INSERT INTO excluded AS x1 VALUES('hello', 1, 1, NULL) ON CONFLICT(x, [a b])
379 ON CONFLICT(x, [a b]) WHERE y=1
390 INSERT INTO hist VALUES(new.x, 1) ON CONFLICT(x) DO