Lines Matching refs:a
4 # a legal notice, here is a blessing:
31 a INTEGER PRIMARY KEY ON CONFLICT REPLACE,
35 INSERT INTO t1(a,b,c) VALUES(1,2,3), (2,3,4);
36 SELECT a,b,c FROM t1 ORDER BY a;
39 # Insert a row that conflicts on column B. The insert should be ignored.
42 INSERT INTO t1(a,b,c) VALUES(3,2,5);
43 SELECT a,b,c FROM t1 ORDER BY a;
47 # and and then there should be a constraint error.
50 catchsql {INSERT INTO t1(a,b,c) VALUES(4,5,6), (5,6,4);}
53 SELECT a,b,c FROM t1 ORDER BY a;
56 # Replete the tests above, but this time on a table non-INTEGER primary key.
61 a INT PRIMARY KEY ON CONFLICT REPLACE,
65 INSERT INTO t1(a,b,c) VALUES(1,2,3), (2,3,4);
66 SELECT a,b,c FROM t1 ORDER BY a;
69 # Insert a row that conflicts on column B. The insert should be ignored.
72 INSERT INTO t1(a,b,c) VALUES(3,2,5);
73 SELECT a,b,c FROM t1 ORDER BY a;
77 # and and then there should be a constraint error.
80 catchsql {INSERT INTO t1(a,b,c) VALUES(4,5,6), (5,6,4);}
83 SELECT a,b,c FROM t1 ORDER BY a;
86 # Replete again on a WITHOUT ROWID table.
91 a INT PRIMARY KEY ON CONFLICT REPLACE,
95 INSERT INTO t1(a,b,c) VALUES(1,2,3), (2,3,4);
96 SELECT a,b,c FROM t1 ORDER BY a;
99 # Insert a row that conflicts on column B. The insert should be ignored.
102 INSERT INTO t1(a,b,c) VALUES(3,2,5);
103 SELECT a,b,c FROM t1 ORDER BY a;
107 # and and then there should be a constraint error.
110 catchsql {INSERT INTO t1(a,b,c) VALUES(4,5,6), (5,6,4);}
113 SELECT a,b,c FROM t1 ORDER BY a;
116 # Arrange the table rows in a different order and repeat.
123 a INT PRIMARY KEY ON CONFLICT REPLACE
125 INSERT INTO t1(a,b,c) VALUES(1,2,3), (2,3,4);
126 SELECT a,b,c FROM t1 ORDER BY a;
129 # Insert a row that conflicts on column B. The insert should be ignored.
132 INSERT INTO t1(a,b,c) VALUES(3,2,5);
133 SELECT a,b,c FROM t1 ORDER BY a;
137 # and and then there should be a constraint error.
140 catchsql {INSERT INTO t1(a,b,c) VALUES(4,5,6), (5,6,4);}
143 SELECT a,b,c FROM t1 ORDER BY a;
146 # Arrange the table rows in a different order and repeat.
152 a INT PRIMARY KEY ON CONFLICT REPLACE,
155 INSERT INTO t1(a,b,c) VALUES(1,2,3), (2,3,4);
156 SELECT a,b,c FROM t1 ORDER BY a;
159 # Insert a row that conflicts on column B. The insert should be ignored.
162 INSERT INTO t1(a,b,c) VALUES(3,2,5);
163 SELECT a,b,c FROM t1 ORDER BY a;
167 # and and then there should be a constraint error.
170 catchsql {INSERT INTO t1(a,b,c) VALUES(4,5,6), (5,6,4);}
173 SELECT a,b,c FROM t1 ORDER BY a;
176 # Arrange the table rows in a different order and repeat.
182 a INT PRIMARY KEY ON CONFLICT REPLACE,
185 INSERT INTO t1(a,b,c) VALUES(1,2,3), (2,3,4);
186 SELECT a,b,c FROM t1 ORDER BY a;
189 # Insert a row that conflicts on column B. The insert should be ignored.
192 INSERT INTO t1(a,b,c) VALUES(3,2,5);
193 SELECT a,b,c FROM t1 ORDER BY a;
197 # and and then there should be a constraint error.
200 catchsql {INSERT INTO t1(a,b,c) VALUES(4,5,6), (5,6,4);}
203 SELECT a,b,c FROM t1 ORDER BY a;
211 a UNIQUE ON CONFLICT REPLACE,
215 INSERT INTO t1(a,b,c) VALUES(1,2,3), (2,3,4);
216 SELECT a,b,c FROM t1 ORDER BY a;
219 # Insert a row that conflicts on column B. The insert should be ignored.
222 INSERT INTO t1(a,b,c) VALUES(3,2,5);
223 SELECT a,b,c FROM t1 ORDER BY a;
227 # and and then there should be a constraint error.
230 catchsql {INSERT INTO t1(a,b,c) VALUES(4,5,6), (5,6,4);}
233 SELECT a,b,c FROM t1 ORDER BY a;
241 a UNIQUE ON CONFLICT REPLACE,
245 INSERT INTO t1(a,b,c) VALUES(1,2,3), (2,3,4);
246 SELECT a,b,c FROM t1 ORDER BY a;
249 # Insert a row that conflicts on column B. The insert should be ignored.
252 INSERT INTO t1(a,b,c) VALUES(3,2,5);
253 SELECT a,b,c FROM t1 ORDER BY a;
257 # and and then there should be a constraint error.
260 catchsql {INSERT INTO t1(a,b,c) VALUES(4,5,6), (5,6,4);}
263 SELECT a,b,c FROM t1 ORDER BY a;
271 a UNIQUE ON CONFLICT REPLACE,
275 INSERT INTO t1(a,b,c) VALUES(1,2,3), (2,3,4);
276 SELECT a,b,c FROM t1 ORDER BY a;
279 # Insert a row that conflicts on column B. The insert should be ignored.
282 INSERT INTO t1(a,b,c) VALUES(3,2,5);
283 SELECT a,b,c FROM t1 ORDER BY a;
287 # and and then there should be a constraint error.
290 catchsql {INSERT INTO t1(a,b,c) VALUES(4,5,6), (5,6,4);}
293 SELECT a,b,c FROM t1 ORDER BY a;
301 a UNIQUE ON CONFLICT REPLACE,
305 INSERT INTO t1(a,b,c) VALUES(1,2,3), (2,3,4);
306 SELECT a,b,c FROM t1 ORDER BY a;
309 # Insert a row that conflicts on column B. The insert should be ignored.
312 INSERT INTO t1(a,b,c) VALUES(3,2,5);
313 SELECT a,b,c FROM t1 ORDER BY a;
317 # and and then there should be a constraint error.
320 catchsql {INSERT INTO t1(a,b,c) VALUES(4,5,6), (5,6,4);}
323 SELECT a,b,c FROM t1 ORDER BY a;
331 a UNIQUE ON CONFLICT REPLACE,
335 INSERT INTO t1(a,b,c) VALUES(1,2,3), (2,3,4);
336 SELECT a,b,c FROM t1 ORDER BY a;
339 # Insert a row that conflicts on column B. The insert should be ignored.
342 INSERT INTO t1(a,b,c) VALUES(3,2,5);
343 SELECT a,b,c FROM t1 ORDER BY a;
347 # and and then there should be a constraint error.
350 catchsql {INSERT INTO t1(a,b,c) VALUES(4,5,6), (5,6,4);}
353 SELECT a,b,c FROM t1 ORDER BY a;
359 CREATE TABLE t2(a INTEGER PRIMARY KEY, b TEXT);
394 CREATE TABLE t2 (a PRIMARY KEY, b UNIQUE, c UNIQUE) WITHOUT ROWID;
414 CREATE TABLE t1(a, b);
416 CREATE INDEX i1 ON t1(a);