Lines Matching refs:SELECT
25 # collate2-3.* SELECT <expr> expressions (sqliteExprCode).
98 SELECT a FROM collate2t1 WHERE a > 'aa' ORDER BY 1;
103 SELECT a FROM collate2t1 WHERE a COLLATE binary > 'aa' ORDER BY 1;
108 SELECT a FROM collate2t1 WHERE b COLLATE binary > 'aa' ORDER BY 1;
113 SELECT a FROM collate2t1 WHERE c COLLATE binary > 'aa' ORDER BY 1;
118 SELECT b FROM collate2t1 WHERE b > 'aa' ORDER BY 1, oid;
123 SELECT b FROM collate2t1 WHERE a COLLATE nocase > 'aa'
129 SELECT b FROM collate2t1 WHERE b COLLATE nocase > 'aa'
135 SELECT b FROM collate2t1 WHERE c COLLATE nocase > 'aa'
141 SELECT b FROM collate2t1 WHERE b > 'aa' ORDER BY +b;
146 SELECT b FROM collate2t1 WHERE a COLLATE nocase > 'aa' ORDER BY +b;
151 SELECT b FROM collate2t1 WHERE b COLLATE nocase > 'aa' ORDER BY +b;
156 SELECT b FROM collate2t1 WHERE c COLLATE nocase > 'aa' ORDER BY +b;
161 SELECT c FROM collate2t1 WHERE c > 'aa' ORDER BY 1;
166 SELECT c FROM collate2t1 WHERE a COLLATE backwards > 'aa'
172 SELECT c FROM collate2t1 WHERE b COLLATE backwards > 'aa'
178 SELECT c FROM collate2t1 WHERE c COLLATE backwards > 'aa'
184 SELECT a FROM collate2t1 WHERE a < 'aa' ORDER BY 1;
189 SELECT b FROM collate2t1 WHERE b < 'aa' ORDER BY 1, oid;
194 SELECT b FROM collate2t1 WHERE b < 'aa' ORDER BY +b;
199 SELECT c FROM collate2t1 WHERE c < 'aa' ORDER BY 1;
204 SELECT a FROM collate2t1 WHERE a = 'aa';
209 SELECT b FROM collate2t1 WHERE b = 'aa' ORDER BY oid;
214 SELECT c FROM collate2t1 WHERE c = 'aa';
219 SELECT a FROM collate2t1 WHERE a >= 'aa' ORDER BY 1;
224 SELECT b FROM collate2t1 WHERE b >= 'aa' ORDER BY 1, oid;
229 SELECT c FROM collate2t1 WHERE c >= 'aa' ORDER BY 1;
234 SELECT a FROM collate2t1 WHERE a <= 'aa' ORDER BY 1;
239 SELECT b FROM collate2t1 WHERE b <= 'aa' ORDER BY 1, oid;
244 SELECT c FROM collate2t1 WHERE c <= 'aa' ORDER BY 1;
249 SELECT a FROM collate2t1 WHERE a BETWEEN 'Aa' AND 'Bb' ORDER BY 1;
254 SELECT b FROM collate2t1 WHERE b BETWEEN 'Aa' AND 'Bb' ORDER BY 1, oid;
259 SELECT b FROM collate2t1 WHERE b BETWEEN 'Aa' AND 'Bb' ORDER BY +b;
264 SELECT c FROM collate2t1 WHERE c BETWEEN 'Aa' AND 'Bb' ORDER BY 1;
269 SELECT a FROM collate2t1 WHERE
276 SELECT b FROM collate2t1 WHERE
283 SELECT c FROM collate2t1 WHERE
292 SELECT a FROM collate2t1 WHERE a IN ('aa', 'bb') ORDER BY 1, oid;
297 SELECT b FROM collate2t1 WHERE b IN ('aa', 'bb') ORDER BY 1, oid;
302 SELECT c FROM collate2t1 WHERE c IN ('aa', 'bb') ORDER BY 1, oid;
307 SELECT a FROM collate2t1
308 WHERE a IN (SELECT a FROM collate2t1 WHERE a IN ('aa', 'bb'));
313 SELECT b FROM collate2t1
314 WHERE b IN (SELECT a FROM collate2t1 WHERE a IN ('aa', 'bb'));
319 SELECT c FROM collate2t1
320 WHERE c IN (SELECT a FROM collate2t1 WHERE a IN ('aa', 'bb'));
327 SELECT a FROM collate2t1 WHERE NOT a > 'aa' ORDER BY 1;
332 SELECT b FROM collate2t1 WHERE NOT b > 'aa' ORDER BY 1, oid;
337 SELECT c FROM collate2t1 WHERE NOT c > 'aa' ORDER BY 1;
342 SELECT a FROM collate2t1 WHERE NOT a < 'aa' ORDER BY 1;
347 SELECT b FROM collate2t1 WHERE NOT b < 'aa' ORDER BY 1, oid;
352 SELECT c FROM collate2t1 WHERE NOT c < 'aa' ORDER BY 1;
357 SELECT a FROM collate2t1 WHERE NOT a = 'aa';
362 SELECT b FROM collate2t1 WHERE NOT b = 'aa';
367 SELECT c FROM collate2t1 WHERE NOT c = 'aa';
372 SELECT a FROM collate2t1 WHERE NOT a >= 'aa' ORDER BY 1;
377 SELECT b FROM collate2t1 WHERE NOT b >= 'aa' ORDER BY 1, oid;
382 SELECT c FROM collate2t1 WHERE NOT c >= 'aa' ORDER BY 1;
387 SELECT a FROM collate2t1 WHERE NOT a <= 'aa' ORDER BY 1;
392 SELECT b FROM collate2t1 WHERE NOT b <= 'aa' ORDER BY 1, oid;
397 SELECT c FROM collate2t1 WHERE NOT c <= 'aa' ORDER BY 1;
402 SELECT a FROM collate2t1 WHERE a NOT BETWEEN 'Aa' AND 'Bb' ORDER BY 1;
407 SELECT b FROM collate2t1 WHERE b NOT BETWEEN 'Aa' AND 'Bb' ORDER BY 1, oid;
412 SELECT c FROM collate2t1 WHERE c NOT BETWEEN 'Aa' AND 'Bb' ORDER BY 1;
417 SELECT a FROM collate2t1 WHERE NOT CASE a WHEN 'aa' THEN 1 ELSE 0 END;
422 SELECT b FROM collate2t1 WHERE NOT CASE b WHEN 'aa' THEN 1 ELSE 0 END;
427 SELECT c FROM collate2t1 WHERE NOT CASE c WHEN 'aa' THEN 1 ELSE 0 END;
434 SELECT a FROM collate2t1 WHERE NOT a IN ('aa', 'bb');
439 SELECT b FROM collate2t1 WHERE NOT b IN ('aa', 'bb');
444 SELECT c FROM collate2t1 WHERE NOT c IN ('aa', 'bb');
449 SELECT a FROM collate2t1
450 WHERE NOT a IN (SELECT a FROM collate2t1 WHERE a IN ('aa', 'bb'));
455 SELECT b FROM collate2t1
456 WHERE NOT b IN (SELECT a FROM collate2t1 WHERE a IN ('aa', 'bb'));
461 SELECT c FROM collate2t1
462 WHERE NOT c IN (SELECT a FROM collate2t1 WHERE a IN ('aa', 'bb'));
469 SELECT a > 'aa' FROM collate2t1;
474 SELECT b > 'aa' FROM collate2t1;
479 SELECT c > 'aa' FROM collate2t1;
484 SELECT a < 'aa' FROM collate2t1;
489 SELECT b < 'aa' FROM collate2t1;
494 SELECT c < 'aa' FROM collate2t1;
499 SELECT a = 'aa' FROM collate2t1;
504 SELECT b = 'aa' FROM collate2t1;
509 SELECT c = 'aa' FROM collate2t1;
514 SELECT a <= 'aa' FROM collate2t1;
519 SELECT b <= 'aa' FROM collate2t1;
524 SELECT c <= 'aa' FROM collate2t1;
529 SELECT a >= 'aa' FROM collate2t1;
534 SELECT b >= 'aa' FROM collate2t1;
539 SELECT c >= 'aa' FROM collate2t1;
544 SELECT a BETWEEN 'Aa' AND 'Bb' FROM collate2t1;
549 SELECT b BETWEEN 'Aa' AND 'Bb' FROM collate2t1;
554 SELECT c BETWEEN 'Aa' AND 'Bb' FROM collate2t1;
559 SELECT CASE a WHEN 'aa' THEN 1 ELSE 0 END FROM collate2t1;
564 SELECT CASE b WHEN 'aa' THEN 1 ELSE 0 END FROM collate2t1;
569 SELECT CASE c WHEN 'aa' THEN 1 ELSE 0 END FROM collate2t1;
576 SELECT a IN ('aa', 'bb') FROM collate2t1;
581 SELECT b IN ('aa', 'bb') FROM collate2t1;
586 SELECT c IN ('aa', 'bb') FROM collate2t1;
591 SELECT a IN (SELECT a FROM collate2t1 WHERE a IN ('aa', 'bb'))
597 SELECT b IN (SELECT a FROM collate2t1 WHERE a IN ('aa', 'bb'))
603 SELECT c IN (SELECT a FROM collate2t1 WHERE a IN ('aa', 'bb'))
623 SELECT collate2t1.a FROM collate2t1, collate2t2
629 SELECT collate2t1.a FROM collate2t1, collate2t2
638 SELECT collate2t1.a FROM collate2t1, collate2t3
644 SELECT collate2t1.a FROM collate2t1, collate2t3
665 SELECT collate2t1.b FROM collate2t1 JOIN collate2t2 USING (b);
670 SELECT collate2t1.b FROM collate2t2 JOIN collate2t1 USING (b);
675 SELECT collate2t1.b FROM collate2t1 NATURAL JOIN collate2t2;
680 SELECT collate2t1.b FROM collate2t2 NATURAL JOIN collate2t1;
685 SELECT collate2t2.b FROM collate2t1 LEFT OUTER JOIN collate2t2 USING (b) order by collate2t1.oid;
690 SELECT collate2t1.b, collate2t2.b FROM collate2t2 LEFT OUTER JOIN collate2t1 USING (b);
