Lines Matching refs:x1

204   CREATE TABLE x1(a INTEGER PRIMARY KEY, b, c, d);
205   CREATE INDEX x1bc ON x1(b, c);
206   INSERT INTO x1 VALUES(1,1,1,1);
207   INSERT INTO x1 VALUES(2,1,2,2);
208   INSERT INTO x1 VALUES(3,2,1,3);
209   INSERT INTO x1 VALUES(4,2,2,3);
210   INSERT INTO x1 VALUES(5,3,1,2);
211   INSERT INTO x1 VALUES(6,3,2,1);
216     DELETE FROM x1 ORDER BY a LIMIT 2;
217     SELECT a FROM x1;
224 #  DELETE FROM x1 INDEXED BY x1bc WHERE d=3 LIMIT 1;
228   DELETE FROM x1 INDEXED BY x1bc WHERE b=3 LIMIT 1;
229   SELECT a FROM x1;
235 #  UPDATE x1 INDEXED BY x1bc SET d=5 WHERE d=3 LIMIT 1;
239   UPDATE x1 INDEXED BY x1bc SET d=5 WHERE b=2 LIMIT 1;
240   SELECT a, d FROM x1;