Lines Matching refs:x1
276 CREATE TABLE x1(a, b, c, d, e);
277 CREATE INDEX x1a ON x1(a);
278 CREATE INDEX x1bc ON x1(b, c);
279 CREATE INDEX x1cd ON x1(c, d);
281 INSERT INTO x1 VALUES(1, 2, 3, 4, 'A');
282 INSERT INTO x1 VALUES(5, 6, 7, 8, 'B');
283 INSERT INTO x1 VALUES(9, 10, 11, 12, 'C');
284 INSERT INTO x1 VALUES(13, 14, 15, 16, 'D');
288 SELECT e FROM x1 WHERE b=2 OR c=7;
291 SELECT c FROM x1 WHERE b=2 OR c=7;
295 SELECT e FROM x1 WHERE a=1 OR b=10;
298 SELECT c FROM x1 WHERE a=1 OR b=10;
301 SELECT rowid FROM x1 WHERE a=1 OR b=10;
305 SELECT a FROM x1 WHERE b BETWEEN 1 AND 4 OR c BETWEEN 8 AND 12
308 SELECT b, c FROM x1 WHERE b BETWEEN 1 AND 4 OR c BETWEEN 8 AND 12
311 SELECT rowid, c FROM x1 WHERE b BETWEEN 1 AND 4 OR c BETWEEN 8 AND 12
315 SELECT a FROM x1 WHERE rowid = 2 OR c=11
318 SELECT d FROM x1 WHERE rowid = 2 OR c=11
321 SELECT d FROM x1 WHERE c=11 OR rowid = 2
324 SELECT a FROM x1 WHERE c=11 OR rowid = 2
328 SELECT rowid FROM x1 WHERE a=1 OR b=6 OR c=11
331 SELECT c FROM x1 WHERE a=1 OR b=6 OR c=11
334 SELECT c FROM x1 WHERE c=11 OR a=1 OR b=6
337 SELECT c FROM x1 WHERE b=6 OR c=11 OR a=1