Lines Matching refs:xyz

33     INSERT INTO t1 VALUES(1, NULL, 'xyz') ON CONFLICT DO NOTHING;
89       CREATE TABLE xyz(a INTEGER PRIMARY KEY, b, c, d);
90       CREATE UNIQUE INDEX xyz1 ON xyz(d, c, b COLLATE nocase);
94       CREATE TABLE xyz(a INT PRIMARY KEY, b, c, d);
95       CREATE UNIQUE INDEX xyz1 ON xyz(d, c, b COLLATE nocase);
99       CREATE TABLE xyz(a INT PRIMARY KEY, b, c, d) WITHOUT ROWID;
100       CREATE UNIQUE INDEX xyz1 ON xyz(d, c, b COLLATE nocase);
106     INSERT INTO xyz VALUES(10, 1, 1, 'one');
123       INSERT INTO xyz VALUES(11, 1, 1, 'one') $oc
128     SELECT * FROM xyz;
174     CREATE UNIQUE INDEX abc2 ON abc(y) WHERE x='xyz' COLLATE nocase;
182     INSERT INTO abc VALUES(3, 'xyz', 3);
191     5 "ON CONFLICT(y) WHERE x='xyz' COLLATE nocase DO NOTHING" 1
200   } {1 one 1 2 two 2 3 xyz 3 4 XYZ 4}
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