Lines Matching refs:x1

96   CREATE TABLE x1(i INTEGER PRIMARY KEY, j);
97   INSERT INTO x1 VALUES(1, 'one');
98   INSERT INTO x1 VALUES(2, 'two');
99   INSERT INTO x1 VALUES(3, 'three');
100   INSERT INTO x1 VALUES(4, 'four');
101   CREATE INDEX x1j ON x1(j);
103   SELECT * FROM x1 WHERE i=2;
107   nLoop 1 nVisit 1 nEst 1.0 zName x1 
108   zExplain {SEARCH x1 USING INTEGER PRIMARY KEY (rowid=?)}
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<?)}
145   INSERT INTO x2 SELECT i, j, i || ' ' || j FROM x1;