Lines Matching refs:t1
19 CREATE TABLE t1(a INTEGER PRIMARY KEY, b TEXT, c DEFAULT 0);
20 CREATE UNIQUE INDEX t1x1 ON t1(b);
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;
23 SELECT * FROM t1;
26 DELETE FROM t1;
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;
29 SELECT * FROM t1;
32 DELETE FROM t1;
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;
35 SELECT * FROM t1;
38 INSERT INTO t1(a,b) VALUES(5,6) ON CONFLICT(x) DO NOTHING;
39 SELECT * FROM t1;
42 INSERT INTO t1(a,b) VALUES(5,6) ON CONFLICT(c) DO NOTHING;
43 SELECT * FROM t1;
47 INSERT INTO t1(a,b) VALUES(5,6) ON CONFLICT(b COLLATE nocase) DO NOTHING;
48 SELECT * FROM t1;
51 DELETE FROM t1;
52 INSERT INTO t1(a,b) VALUES(5,6) ON CONFLICT(b COLLATE binary) DO NOTHING;
53 SELECT * FROM t1;
57 DROP TABLE t1;
58 CREATE TABLE t1(a INTEGER PRIMARY KEY, b INT, c DEFAULT 0);
59 CREATE UNIQUE INDEX t1x1 ON t1(a+b);
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;
62 SELECT * FROM t1;
65 INSERT INTO t1(a,b) VALUES(8,7),(9,6) ON CONFLICT(a) DO NOTHING;
68 DELETE FROM t1;
69 INSERT INTO t1(a,b) VALUES(9,10) ON CONFLICT(a+(+b)) DO NOTHING;
70 SELECT * FROM t1;
75 DELETE FROM t1;
76 CREATE UNIQUE INDEX t1x1 ON t1(b) WHERE b>10;
77 INSERT INTO t1(a,b) VALUES(1,2),(3,2) ON CONFLICT(b) DO NOTHING;
78 SELECT * FROM t1;
81 DELETE FROM t1;
82 INSERT INTO t1(a,b) VALUES(1,2),(3,2) ON CONFLICT(b) WHERE b!=10 DO NOTHING;
83 SELECT * FROM t1;
86 DELETE FROM t1;
87 INSERT INTO t1(a,b) VALUES(1,2),(3,2),(4,20),(5,20)
89 SELECT *, 'x' FROM t1 ORDER BY b, a;
108 DROP TABLE t1;
109 CREATE TABLE t1(x INTEGER PRIMARY KEY, y INT UNIQUE);
110 INSERT INTO t1(x,y) SELECT 1,2 WHERE true
111 ON CONFLICT(x) DO UPDATE SET y=max(t1.y,excluded.y) AND true;
112 SELECT * FROM t1;
120 DROP TABLE t1;
121 CREATE TABLE t1(b UNIQUE, a INT PRIMARY KEY) WITHOUT ROWID;
122 INSERT OR IGNORE INTO t1(a) VALUES('1') ON CONFLICT(a) DO NOTHING;
126 DELETE FROM t1;
127 INSERT OR IGNORE INTO t1(a) VALUES('1'),(1) ON CONFLICT(a) DO NOTHING;
139 DROP TABLE t1;
140 CREATE TABLE t1(a INTEGER PRIMARY KEY, b INT, c INT, d INT, e INT);
141 CREATE UNIQUE INDEX t1b ON t1(b);
142 CREATE UNIQUE INDEX t1e ON t1(e);
143 INSERT INTO t1(a,b,c,d,e) VALUES(1,2,3,4,5);
144 INSERT INTO t1(a,b,c,d,e) VALUES(1,2,33,44,5)
146 SELECT * FROM t1;
149 DELETE FROM t1;
150 INSERT INTO t1(a,b,c,d,e) VALUES(1,2,3,4,5);
151 INSERT INTO t1(a,b,c,d,e) VALUES(1,2,33,44,5)
153 SELECT * FROM t1;
156 DELETE FROM t1;
157 INSERT INTO t1(a,b,c,d,e) VALUES(1,2,3,4,5);
158 INSERT INTO t1(a,b,c,d,e) VALUES(1,2,33,44,5)
160 SELECT * FROM t1;
163 DROP TABLE t1;
164 CREATE TABLE t1(a INT, b INT, c INT, d INT, e INT);
165 CREATE UNIQUE INDEX t1a ON t1(a);
166 CREATE UNIQUE INDEX t1b ON t1(b);
167 CREATE UNIQUE INDEX t1e ON t1(e);
168 INSERT INTO t1(a,b,c,d,e) VALUES(1,2,3,4,5);
169 INSERT INTO t1(a,b,c,d,e) VALUES(1,2,33,44,5)
171 SELECT * FROM t1;
174 DELETE FROM t1;
175 INSERT INTO t1(a,b,c,d,e) VALUES(1,2,3,4,5);
176 INSERT INTO t1(a,b,c,d,e) VALUES(1,2,33,44,5)
178 SELECT * FROM t1;
181 DELETE FROM t1;
182 INSERT INTO t1(a,b,c,d,e) VALUES(1,2,3,4,5);
183 INSERT INTO t1(a,b,c,d,e) VALUES(1,2,33,44,5)
185 SELECT * FROM t1;
188 DROP TABLE t1;
189 CREATE TABLE t1(a INT PRIMARY KEY, b INT, c INT, d INT, e INT) WITHOUT ROWID;
190 CREATE UNIQUE INDEX t1a ON t1(a);
191 CREATE UNIQUE INDEX t1b ON t1(b);
192 CREATE UNIQUE INDEX t1e ON t1(e);
193 INSERT INTO t1(a,b,c,d,e) VALUES(1,2,3,4,5);
194 INSERT INTO t1(a,b,c,d,e) VALUES(1,2,33,44,5)
196 SELECT * FROM t1;
199 DELETE FROM t1;
200 INSERT INTO t1(a,b,c,d,e) VALUES(1,2,3,4,5);
201 INSERT INTO t1(a,b,c,d,e) VALUES(1,2,33,44,5)
203 SELECT * FROM t1;
206 DELETE FROM t1;
207 INSERT INTO t1(a,b,c,d,e) VALUES(1,2,3,4,5);
208 INSERT INTO t1(a,b,c,d,e) VALUES(1,2,33,44,5)
210 SELECT * FROM t1;
227 CREATE VIEW t1(a) AS SELECT 1;
228 CREATE TRIGGER t1r1 INSTEAD OF INSERT ON t1 BEGIN
233 INSERT INTO t1 VALUES(3) ON CONFLICT(x) DO NOTHING;
252 CREATE TABLE t1(a INTEGER PRIMARY KEY ON CONFLICT REPLACE, b UNIQUE);
253 INSERT INTO t1(b) VALUES(22);
254 INSERT INTO t1 VALUES(2,22) ON CONFLICT (b) DO NOTHING;
255 SELECT * FROM t1;