Lines Matching refs:t2
39 CREATE TABLE t2(a INT, b INT, ex TEXT);
44 SELECT * FROM t2, t1 WHERE t1.a=1 OR t1.b=2;
52 `--SCAN t2
55 SELECT * FROM t2 CROSS JOIN t1 WHERE t1.a=1 OR t1.b=2;
58 |--SCAN t2
183 CREATE TABLE t2(x INT, y INT, ex TEXT);
184 CREATE INDEX t2i1 ON t2(x);
194 det 2.2.2 "SELECT DISTINCT min(x), max(x) FROM t2 GROUP BY x ORDER BY 1" {
196 |--SCAN t2 USING COVERING INDEX t2i1
205 det 2.2.4 "SELECT DISTINCT * FROM t1, t2" {
208 |--SCAN t2
211 det 2.2.5 "SELECT DISTINCT * FROM t1, t2 ORDER BY t1.x" {
214 |--SCAN t2
218 det 2.2.6 "SELECT DISTINCT t2.x FROM t1, t2 ORDER BY t2.x" {
220 |--SCAN t2 USING COVERING INDEX t2i1
224 det 2.3.1 "SELECT max(x) FROM t2" {
226 `--SEARCH t2 USING COVERING INDEX t2i1
228 det 2.3.2 "SELECT min(x) FROM t2" {
230 `--SEARCH t2 USING COVERING INDEX t2i1
232 det 2.3.3 "SELECT min(x), max(x) FROM t2" {
234 `--SCAN t2 USING COVERING INDEX t2i1
273 SELECT * FROM t1 WHERE (SELECT x FROM t2 ORDER BY x);
278 `--SCAN t2 USING COVERING INDEX t2i1
294 (SELECT * FROM t2 ORDER BY x LIMIT 10) AS x2
302 | `--SCAN t2 USING INDEX t2i1
309 SELECT * FROM t1 WHERE y IN (SELECT y FROM t2)
314 `--SCAN t2
317 SELECT * FROM t1 WHERE y IN (SELECT y FROM t2 WHERE t1.x!=t2.x)
322 `--SCAN t2
325 SELECT * FROM t1 WHERE EXISTS (SELECT y FROM t2 WHERE t1.x!=t2.x)
330 `--SCAN t2
337 SELECT * FROM t1 UNION ALL SELECT * FROM t2
344 `--SCAN t2
347 SELECT * FROM t1 UNION ALL SELECT * FROM t2 ORDER BY 2
355 |--SCAN t2
359 SELECT * FROM t1 UNION SELECT * FROM t2 ORDER BY 2
367 |--SCAN t2
371 SELECT * FROM t1 INTERSECT SELECT * FROM t2 ORDER BY 2
379 |--SCAN t2
383 SELECT * FROM t1 EXCEPT SELECT * FROM t2 ORDER BY 2
391 |--SCAN t2
396 SELECT * FROM t1 UNION ALL SELECT * FROM t2 ORDER BY 1
404 `--SCAN t2 USING INDEX t2i1
407 SELECT * FROM t1 UNION SELECT * FROM t2 ORDER BY 1
415 |--SCAN t2 USING INDEX t2i1
419 SELECT * FROM t1 INTERSECT SELECT * FROM t2 ORDER BY 1
427 |--SCAN t2 USING INDEX t2i1
431 SELECT * FROM t1 EXCEPT SELECT * FROM t2 ORDER BY 1
439 |--SCAN t2 USING INDEX t2i1
444 SELECT x FROM t1 UNION SELECT x FROM t2
451 `--SCAN t2 USING COVERING INDEX t2i1
455 SELECT x FROM t1 UNION SELECT x FROM t2 UNION SELECT x FROM t1
462 | `--SCAN t2 USING COVERING INDEX t2i1
467 SELECT x FROM t1 UNION SELECT x FROM t2 UNION SELECT x FROM t1 ORDER BY 1
477 | `--SCAN t2 USING COVERING INDEX t2i1
518 # SELECT t1.*, t2.* FROM t1, t2 WHERE t1.a=1 AND t1.b>2;
520 # 0|1|1|SCAN t2
522 do_execsql_test 5.4.0 {CREATE TABLE t2(c INT, d INT, ex TEXT)}
523 det 5.4.1 "SELECT t1.a, t2.c FROM t1, t2 WHERE t1.a=1 AND t1.b>2" {
525 0 1 1 {SCAN t2}
529 # SELECT t1.*, t2.* FROM t2, t1 WHERE t1.a=1 AND t1.b>2;
531 # 0|1|0|SCAN t2
533 det 5.5 "SELECT t1.a, t2.c FROM t2, t1 WHERE t1.a=1 AND t1.b>2" {
535 0 1 0 {SCAN t2}
550 # SELECT c, d FROM t2 ORDER BY c;
551 # 0|0|0|SCAN t2
554 det 5.7 "SELECT c, d FROM t2 ORDER BY c" {
555 0 0 0 {SCAN t2}
559 # XVIDENCE-OF: R-58157-12355 sqlite> CREATE INDEX i4 ON t2(c);
560 # sqlite> EXPLAIN QUERY PLAN SELECT c, d FROM t2 ORDER BY c;
561 # 0|0|0|SCAN t2 USING INDEX i4
563 do_execsql_test 5.8.0 {CREATE INDEX i4 ON t2(c)}
564 det 5.8.1 "SELECT c, d FROM t2 ORDER BY c" {
565 0 0 0 {SCAN t2 USING INDEX i4}
569 # (SELECT b FROM t1 WHERE a=0), (SELECT a FROM t1 WHERE b=t2.c) FROM t2;
570 # 0|0|0|SCAN t2
577 SELECT (SELECT b FROM t1 WHERE a=0), (SELECT a FROM t1 WHERE b=t2.c) FROM t2
579 0 0 0 {SCAN t2 USING COVERING INDEX i4}
601 # SELECT * FROM (SELECT * FROM t2 WHERE c=1), t1;
602 # 0|0|0|SEARCH t2 USING INDEX i4 (c=?)
605 det 5.11 "SELECT a, b FROM (SELECT * FROM t2 WHERE c=1), t1" {
606 0 0 0 {SEARCH t2 USING INDEX i4 (c=?)}
611 # SELECT a FROM t1 UNION SELECT c FROM t2;
613 # 2|0|0|SCAN t2
616 det 5.12 "SELECT a,b FROM t1 UNION SELECT c, 99 FROM t2" {
618 2 0 0 {SCAN t2 USING COVERING INDEX i4}
623 # SELECT a FROM t1 EXCEPT SELECT d FROM t2 ORDER BY 1;
625 # 2|0|0|SCAN t2 2|0|0|USE TEMP B-TREE FOR ORDER BY
628 det 5.13 "SELECT a FROM t1 EXCEPT SELECT d FROM t2 ORDER BY 1" {
630 2 0 0 {SCAN t2}
668 SELECT a, b FROM t1 EXCEPT SELECT d, 99 FROM t2 ORDER BY 1
671 2 0 0 SCAN t2
686 CREATE TABLE t2(a INT, b INT, ex CHAR(100));
687 CREATE INDEX i1 ON t2(a);
695 det 7.2 "SELECT count(*) FROM t2" {
697 `--SCAN t2 USING COVERING INDEX i1
704 INSERT INTO t2(a,b) VALUES(1, 2);
705 INSERT INTO t2(a,b) VALUES(3, 4);
706 INSERT INTO t2(a,b) VALUES(5, 6);
719 det 7.5 "SELECT count(*) FROM t2" {
721 `--SCAN t2 USING COVERING INDEX i1
732 CREATE TABLE t2(a, b, c);
735 det 8.1.1 "SELECT * FROM t2" {
737 `--SCAN t2
740 det 8.1.2 "SELECT * FROM t2 WHERE rowid=?" {
742 `--SEARCH t2 USING INTEGER PRIMARY KEY (rowid=?)
745 det 8.1.3 "SELECT count(*) FROM t2" {
747 `--SCAN t2