Lines Matching refs:x2

144   CREATE TABLE x2(i INTEGER, j, k);
145   INSERT INTO x2 SELECT i, j, i || ' ' || j FROM x1;
146   CREATE INDEX x2j ON x2(j);
147   CREATE INDEX x2ij ON x2(i, j);
148   SELECT * FROM x2 WHERE j BETWEEN 'three' AND 'two'
153   zExplain {SEARCH x2 USING INDEX x2j (j>? AND j<?)}
157   SELECT * FROM x2 WHERE i=1 AND j='two'
161   zExplain {SEARCH x2 USING INDEX x2ij (i=? AND j=?)}
165   SELECT * FROM x2 WHERE i=5 AND j='two'
169   zExplain {SEARCH x2 USING INDEX x2ij (i=? AND j=?)}
173   SELECT * FROM x2 WHERE i=3 AND j='three'
177   zExplain {SEARCH x2 USING INDEX x2ij (i=? AND j=?)}