Lines Matching refs:CONFLICT

21   INSERT INTO t1(a,b) VALUES(1,2) ON CONFLICT DO NOTHING;
22   INSERT INTO t1(a,b) VALUES(1,99),(99,2) ON CONFLICT DO NOTHING;
27   INSERT INTO t1(a,b) VALUES(2,3) ON CONFLICT(a) DO NOTHING;
28   INSERT INTO t1(a,b) VALUES(2,99) ON CONFLICT(a) DO NOTHING;
33   INSERT INTO t1(a,b) VALUES(3,4) ON CONFLICT(b) DO NOTHING;
34   INSERT INTO t1(a,b) VALUES(99,4) ON CONFLICT(b) DO NOTHING;
38   INSERT INTO t1(a,b) VALUES(5,6) ON CONFLICT(x) DO NOTHING;
42   INSERT INTO t1(a,b) VALUES(5,6) ON CONFLICT(c) DO NOTHING;
44 } {1 {ON CONFLICT clause does not match any PRIMARY KEY or UNIQUE constraint}}
47   INSERT INTO t1(a,b) VALUES(5,6) ON CONFLICT(b COLLATE nocase) DO NOTHING;
49 } {1 {ON CONFLICT clause does not match any PRIMARY KEY or UNIQUE constraint}}
52   INSERT INTO t1(a,b) VALUES(5,6) ON CONFLICT(b COLLATE binary) DO NOTHING;
60   INSERT INTO t1(a,b) VALUES(7,8) ON CONFLICT(a+b) DO NOTHING;
61   INSERT INTO t1(a,b) VALUES(8,7),(9,6) ON CONFLICT(a+b) DO NOTHING;
65   INSERT INTO t1(a,b) VALUES(8,7),(9,6) ON CONFLICT(a) DO NOTHING;
69   INSERT INTO t1(a,b) VALUES(9,10) ON CONFLICT(a+(+b)) DO NOTHING;
71 } {1 {ON CONFLICT clause does not match any PRIMARY KEY or UNIQUE constraint}}
77   INSERT INTO t1(a,b) VALUES(1,2),(3,2) ON CONFLICT(b) DO NOTHING;
79 } {1 {ON CONFLICT clause does not match any PRIMARY KEY or UNIQUE constraint}}
82   INSERT INTO t1(a,b) VALUES(1,2),(3,2) ON CONFLICT(b) WHERE b!=10 DO NOTHING;
84 } {1 {ON CONFLICT clause does not match any PRIMARY KEY or UNIQUE constraint}}
88          ON CONFLICT(b) WHERE b>10 DO NOTHING;
99       ON CONFLICT(a) DO UPDATE SET b=b+1;
111     ON CONFLICT(x) DO UPDATE SET y=max(t1.y,excluded.y) AND true;
122   INSERT OR IGNORE INTO t1(a) VALUES('1') ON CONFLICT(a) DO NOTHING;
127   INSERT OR IGNORE INTO t1(a) VALUES('1'),(1) ON CONFLICT(a) DO NOTHING;
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;
209     ON CONFLICT(b) DO UPDATE SET c=excluded.c;
219   INSERT INTO t0(c0) VALUES (1) ON CONFLICT(c0) DO UPDATE SET c1=excluded.c0;
233   INSERT INTO t1 VALUES(3) ON CONFLICT(x) DO NOTHING;
241     ON CONFLICT(c2) DO UPDATE SET c1 = c0;
245 # By Jingzhou Fu. When there is both an INTEGER PRIMARY KEY ON CONFLICT REPLACE
252   CREATE TABLE t1(a INTEGER PRIMARY KEY ON CONFLICT REPLACE, b UNIQUE);
254   INSERT INTO t1 VALUES(2,22) ON CONFLICT (b) DO NOTHING;