Lines Matching refs:j

96   CREATE TABLE x1(i INTEGER PRIMARY KEY, j);
101   CREATE INDEX x1j ON x1(j);
112   SELECT * FROM x1 WHERE j='two'
116   zExplain {SEARCH x1 USING COVERING INDEX x1j (j=?)}
120   SELECT * FROM x1 WHERE j<'two'
124   zExplain {SEARCH x1 USING COVERING INDEX x1j (j<?)}
128   SELECT * FROM x1 WHERE j>='two'
132   zExplain {SEARCH x1 USING COVERING INDEX x1j (j>?)}
136   SELECT * FROM x1 WHERE j BETWEEN 'three' AND 'two'
140   zExplain {SEARCH x1 USING COVERING INDEX x1j (j>? AND j<?)}
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=?)}
279   set alphabet {a b c d e f g h i j k l m n o p q r s t u v w x y z}
330   SELECT count(*) FROM t2 WHERE y = 'j';
333   SELECT count(*) FROM t2 WHERE y = 'j';
382     INSERT INTO ft1 VALUES('e j i j i e b c f g');
383     INSERT INTO ft1 VALUES('g f b g j c h a d f');
384     INSERT INTO ft1 VALUES('j i a e g f a i a c');
385     INSERT INTO ft1 VALUES('f d g g j j c a h g');
386     INSERT INTO ft1 VALUES('b d h a d j j j b i');
387     INSERT INTO ft1 VALUES('j e a b j e c b c i');
388     INSERT INTO ft1 VALUES('a d e f b j j c g d');