Lines Matching refs:t1
29 CREATE TABLE t1(a,b);
32 INSERT INTO t1(a,b) SELECT x, x FROM cnt;
33 CREATE INDEX t1a ON t1(a);
38 SELECT * FROM t1 WHERE a BETWEEN 500 AND 2500;
39 } {/SCAN t1/}
42 SELECT * FROM t1 WHERE a BETWEEN 2900 AND 3000;
43 } {/SEARCH t1 USING INDEX t1a/}
46 SELECT * FROM t1 WHERE a BETWEEN 1700 AND 1750;
47 } {/SEARCH t1 USING INDEX t1a/}
50 SELECT * FROM t1 WHERE a BETWEEN 1 AND 500
51 } {/SEARCH t1 USING INDEX t1a/}
54 SELECT * FROM t1 WHERE a BETWEEN 3000 AND 3000000
55 } {/SEARCH t1 USING INDEX t1a/}
58 SELECT * FROM t1 WHERE a<500
59 } {/SEARCH t1 USING INDEX t1a/}
62 SELECT * FROM t1 WHERE a>2500
63 } {/SEARCH t1 USING INDEX t1a/}
66 SELECT * FROM t1 WHERE a>1900
67 } {/SEARCH t1 USING INDEX t1a/}
70 SELECT * FROM t1 WHERE a>1100
71 } {/SCAN t1/}
74 SELECT * FROM t1 WHERE a<1100
75 } {/SEARCH t1 USING INDEX t1a/}
78 SELECT * FROM t1 WHERE a<1900
79 } {/SCAN t1/}
85 CREATE INDEX t1a ON t1(a DESC);
90 SELECT * FROM t1 WHERE a BETWEEN 500 AND 2500;
91 } {/SCAN t1/}
94 SELECT * FROM t1 WHERE a BETWEEN 2900 AND 3000;
95 } {/SEARCH t1 USING INDEX t1a/}
98 SELECT * FROM t1 WHERE a BETWEEN 1700 AND 1750;
99 } {/SEARCH t1 USING INDEX t1a/}
102 SELECT * FROM t1 WHERE a BETWEEN 1 AND 500
103 } {/SEARCH t1 USING INDEX t1a/}
106 SELECT * FROM t1 WHERE a BETWEEN 3000 AND 3000000
107 } {/SEARCH t1 USING INDEX t1a/}
110 SELECT * FROM t1 WHERE a<500
111 } {/SEARCH t1 USING INDEX t1a/}
114 SELECT * FROM t1 WHERE a>2500
115 } {/SEARCH t1 USING INDEX t1a/}
118 SELECT * FROM t1 WHERE a>1900
119 } {/SEARCH t1 USING INDEX t1a/}
122 SELECT * FROM t1 WHERE a>1100
123 } {/SCAN t1/}
126 SELECT * FROM t1 WHERE a<1100
127 } {/SEARCH t1 USING INDEX t1a/}
130 SELECT * FROM t1 WHERE a<1900
131 } {/SCAN t1/}
137 DROP TABLE t1;
138 CREATE TABLE t1(a,b,c);
141 INSERT INTO t1(a,b,c) SELECT x, x, 123 FROM cnt;
142 CREATE INDEX t1ca ON t1(c,a);
147 SELECT * FROM t1 WHERE a BETWEEN 500 AND 2500 AND c=123;
148 } {/SCAN t1/}
151 SELECT * FROM t1 WHERE a BETWEEN 2900 AND 3000 AND c=123;
152 } {/SEARCH t1 USING INDEX t1ca/}
155 SELECT * FROM t1 WHERE a BETWEEN 1700 AND 1750 AND c=123;
156 } {/SEARCH t1 USING INDEX t1ca/}
159 SELECT * FROM t1 WHERE a BETWEEN 1 AND 500 AND c=123
160 } {/SEARCH t1 USING INDEX t1ca/}
163 SELECT * FROM t1 WHERE a BETWEEN 3000 AND 3000000 AND c=123
164 } {/SEARCH t1 USING INDEX t1ca/}
167 SELECT * FROM t1 WHERE a<500 AND c=123
168 } {/SEARCH t1 USING INDEX t1ca/}
171 SELECT * FROM t1 WHERE a>2500 AND c=123
172 } {/SEARCH t1 USING INDEX t1ca/}
175 SELECT * FROM t1 WHERE a>1900 AND c=123
176 } {/SEARCH t1 USING INDEX t1ca/}
179 SELECT * FROM t1 WHERE a>1100 AND c=123
180 } {/SCAN t1/}
183 SELECT * FROM t1 WHERE a<1100 AND c=123
184 } {/SEARCH t1 USING INDEX t1ca/}
187 SELECT * FROM t1 WHERE a<1900 AND c=123
188 } {/SCAN t1/}
194 CREATE INDEX t1ca ON t1(c ASC,a DESC);
199 SELECT * FROM t1 WHERE a BETWEEN 500 AND 2500 AND c=123;
200 } {/SCAN t1/}
203 SELECT * FROM t1 WHERE a BETWEEN 2900 AND 3000 AND c=123;
204 } {/SEARCH t1 USING INDEX t1ca/}
207 SELECT * FROM t1 WHERE a BETWEEN 1700 AND 1750 AND c=123;
208 } {/SEARCH t1 USING INDEX t1ca/}
211 SELECT * FROM t1 WHERE a BETWEEN 1 AND 500 AND c=123
212 } {/SEARCH t1 USING INDEX t1ca/}
215 SELECT * FROM t1 WHERE a BETWEEN 3000 AND 3000000 AND c=123
216 } {/SEARCH t1 USING INDEX t1ca/}
219 SELECT * FROM t1 WHERE a<500 AND c=123
220 } {/SEARCH t1 USING INDEX t1ca/}
223 SELECT * FROM t1 WHERE a>2500 AND c=123
224 } {/SEARCH t1 USING INDEX t1ca/}
227 SELECT * FROM t1 WHERE a>1900 AND c=123
228 } {/SEARCH t1 USING INDEX t1ca/}
231 SELECT * FROM t1 WHERE a>1100 AND c=123
232 } {/SCAN t1/}
235 SELECT * FROM t1 WHERE a<1100 AND c=123
236 } {/SEARCH t1 USING INDEX t1ca/}
239 SELECT * FROM t1 WHERE a<1900 AND c=123
240 } {/SCAN t1/}