Lines Matching refs:c1
154 CREATE TABLE c1(a, b, c, d);
155 INSERT INTO c1(a, b) VALUES(1, 'a');
156 INSERT INTO c1(a, b) VALUES(1, 'b');
157 INSERT INTO c1(a, b) VALUES(1, 'c');
158 INSERT INTO c1(a, b) VALUES(1, 'd');
159 INSERT INTO c1(a, b) VALUES(1, 'e');
160 INSERT INTO c1(a, b) VALUES(1, 'f');
161 INSERT INTO c1(a, b) VALUES(1, 'g');
162 INSERT INTO c1(a, b) VALUES(1, 'h');
163 INSERT INTO c1(a, b) VALUES(1, 'i');
164 INSERT INTO c1(a, b) VALUES(1, 'j');
165 INSERT INTO c1(a, b) VALUES(1, 'k');
166 INSERT INTO c1(a, b) VALUES(1, 'l');
167 INSERT INTO c1(a, b) VALUES(1, 'm');
168 INSERT INTO c1(a, b) VALUES(1, 'n');
169 INSERT INTO c1(a, b) VALUES(1, 'o');
170 INSERT INTO c1(a, b) VALUES(1, 'p');
171 INSERT INTO c1(a, b) VALUES(2, 'a');
172 INSERT INTO c1(a, b) VALUES(2, 'b');
173 INSERT INTO c1(a, b) VALUES(2, 'c');
174 INSERT INTO c1(a, b) VALUES(2, 'd');
175 INSERT INTO c1(a, b) VALUES(2, 'e');
176 INSERT INTO c1(a, b) VALUES(2, 'f');
177 INSERT INTO c1(a, b) VALUES(2, 'g');
178 INSERT INTO c1(a, b) VALUES(2, 'h');
180 INSERT INTO c1(c, d) SELECT a, b FROM c1;
182 CREATE INDEX c1ab ON c1(a, b);
183 CREATE INDEX c1cd ON c1(c, d);
187 do_eqp_test 3.1.1 { SELECT * FROM c1 WHERE a=1 AND c=2 } \
188 {SEARCH c1 USING INDEX c1cd (c=?)}
190 do_eqp_test 3.1.2 { SELECT * FROM c1 WHERE a=1 AND b>'d' AND c=2 } \
191 {SEARCH c1 USING INDEX c1cd (c=?)}
193 do_eqp_test 3.1.3 { SELECT * FROM c1 WHERE a=1 AND b>'l' AND c=2 } \
194 {SEARCH c1 USING INDEX c1ab (a=? AND b>?)}
196 do_eqp_test 3.2.1 { SELECT * FROM c1 WHERE a=1 AND c>1 } \
197 {SEARCH c1 USING INDEX c1cd (c>?)}
199 do_eqp_test 3.2.2 { SELECT * FROM c1 WHERE a=1 AND c>0 } \
200 {SEARCH c1 USING INDEX c1ab (a=?)}
202 do_eqp_test 3.2.3 { SELECT * FROM c1 WHERE a=1 AND c>=1 } \
203 {SEARCH c1 USING INDEX c1ab (a=?)}
205 do_eqp_test 3.2.4 { SELECT * FROM c1 WHERE a=1 AND (c, d)>(1, 'c') } \
206 {SEARCH c1 USING INDEX c1ab (a=?)}
208 do_eqp_test 3.2.5 { SELECT * FROM c1 WHERE a=1 AND (c, d)>(1, 'o') } \
209 {SEARCH c1 USING INDEX c1cd ((c,d)>(?,?))}
211 do_eqp_test 3.2.6 { SELECT * FROM c1 WHERE a=1 AND (c, +b)>(1, 'c') } \
212 {SEARCH c1 USING INDEX c1ab (a=?)}
292 CREATE TABLE c1(x, y);
301 ( (a, b) == (SELECT x, y FROM c1) AND c3.d = c ) OR
302 ( c == (SELECT x, y FROM c1) AND c3.d = c )