Lines Matching refs:t2
27 CREATE TABLE t2(x,y);
28 CREATE INDEX t2x ON t2(x);
29 SELECT avg(DISTINCT b) FROM (SELECT * FROM t2 LEFT RIGHT JOIN t1 ON c);
74 CREATE TABLE t2(d int, e int);
75 INSERT INTO t2 VALUES(3,333),(4,444);
80 SELECT * FROM t1 RIGHT JOIN t2 ON c=d JOIN t3 ON f=e;
89 CREATE TABLE t2(id INTEGER PRIMARY KEY, b INT);
97 INSERT INTO t2 SELECT value, 1 FROM generate_series(1,256) WHERE value & 2;
107 NATURAL FULL JOIN t2
155 CREATE TABLE t2(c, d);
156 INSERT INTO t2(c,d) SELECT x, x FROM t1;
157 CREATE INDEX t2dc ON t2(d, c);
158 SELECT (SELECT c FROM sqlite_temp_schema FULL JOIN t2 ON d IN (1,2,3) ORDER BY d) AS x FROM t1;
167 SELECT * FROM t1 AS t2 NATURAL RIGHT JOIN t1 AS t3
192 CREATE TABLE t2(b INT, x INT);
193 INSERT INTO t2(b,x) SELECT b, a FROM t1 WHERE a%2=0;
194 CREATE INDEX t2b ON t2(b);
209 INSERT INTO sqlite_stat1 VALUES('t2','t2b','48 1');
216 SELECT t1.*, t2.*, t3.*
217 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
236 SELECT t1.*, t2.*, t3.*
237 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
255 SELECT t1.*, t2.*, t3.*
256 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
261 } {/.*BLOOM FILTER ON t2.*BLOOM FILTER ON t3.*BLOOM FILTER ON t4.*/}
269 CREATE TABLE t2(c INT, d INT);
272 INSERT INTO t2 VALUES(3, 4);
277 FROM t3 LEFT JOIN t2 ON true
278 JOIN t1 ON (t3.e IS t2.c);
282 FROM t3 LEFT JOIN t2 ON true
283 JOIN t1 ON (t3.e IS NOT DISTINCT FROM t2.c);
294 SELECT * FROM t1 NATURAL RIGHT JOIN t1 AS t2 WHERE (a,b) IN (SELECT a+0, b FROM t1);
303 CREATE TABLE t2(c0);
307 INSERT INTO t2 VALUES(2);
313 FROM t2 NATURAL JOIN t1 RIGHT JOIN t3 ON t1.c0;
317 FROM t2 NATURAL JOIN t1 RIGHT JOIN t3 ON t1.c0;
321 FROM t2 NATURAL CROSS JOIN t1 RIGHT JOIN t3 ON t1.c0;
325 FROM t1 NATURAL CROSS JOIN t2 RIGHT JOIN t3 ON t1.c0;
333 FROM t2 NATURAL JOIN t1 RIGHT JOIN t3 ON t1.c0;
337 FROM t1 NATURAL CROSS JOIN t2 RIGHT JOIN t3 ON t1.c0;
341 FROM t2 NATURAL JOIN t1 RIGHT JOIN t3 ON t1.c0<>0;
352 CREATE TABLE t2(b);
353 INSERT INTO t2 VALUES(0),(1),(2);
354 SELECT * FROM t1 RIGHT JOIN t2 ON (a=b) WHERE 99+(b+1)!=99;
357 CREATE INDEX t2b ON t2(b+1) WHERE b IS NOT NULL;
358 SELECT * FROM t1 RIGHT JOIN t2 ON (a=b) WHERE 99+(b+1)!=99;
362 DROP TABLE t2;
364 CREATE TABLE t2(b, c, d);
365 INSERT INTO t2 VALUES(1, 3, 'not-4');
366 SELECT b, d FROM t1 RIGHT JOIN t2 WHERE (b+0)=1 AND d!=4;
369 CREATE INDEX i2 ON t2((b+0), d);
370 SELECT b, d FROM t1 RIGHT JOIN t2 WHERE (b+0)=1 AND d!=4;
374 CREATE INDEX i2 ON t2((b+0), d) WHERE d IS NOT NULL;
375 SELECT b, d FROM t1 RIGHT JOIN t2 WHERE (b+0)=1 AND d!=4;
386 CREATE TABLE t2(a INT); INSERT INTO t2 VALUES(0),(2);
390 SELECT * FROM t1 RIGHT JOIN t2 ON t2.a<>0 NATURAL RIGHT JOIN t3;
393 SELECT * FROM t1 RIGHT JOIN t2 ON t2.a<>0 NATURAL LEFT JOIN t3;
396 SELECT * FROM t1 LEFT JOIN t2 ON t2.a<>0 NATURAL RIGHT JOIN t3;
405 SELECT * FROM t1 LEFT JOIN t2 ON t2.a<>0 NATURAL LEFT JOIN t3;
415 CREATE TABLE t2(x TEXT, y TEXT); INSERT INTO t2 VALUES('x', 'y');
416 SELECT * FROM t0 JOIN t1 ON (t2.x NOTNULL) LEFT JOIN t2 ON false;
417 SELECT * FROM t0 JOIN t1 ON (t2.x NOTNULL) LEFT JOIN t2 ON false
418 WHERE t2.y ISNULL;
454 CREATE TABLE t2(y INT);
460 SELECT * FROM t1 LEFT JOIN t2 ON true JOIN t3 ON t2.y IS NOT NULL;
463 SELECT * FROM t1 LEFT JOIN t2 ON true JOIN t3 ON t2.y IS NOT NULL
489 CREATE TABLE t2(b TEXT);
491 INSERT INTO t2(b) VALUES ('x');
496 SELECT * FROM t1 RIGHT JOIN t2 ON true LEFT JOIN t3 ON a<>'';
499 SELECT * FROM t1 RIGHT JOIN t2 ON true LEFT JOIN t3 ON a<>'' WHERE c IS NULL;
502 SELECT * FROM t1 RIGHT JOIN t2 ON true JOIN t3 ON a<>'' WHERE c IS NULL;
505 SELECT * FROM t1 RIGHT JOIN t2 ON true JOIN t3 ON a<>'';
508 SELECT * FROM t1 RIGHT JOIN t2 ON true LEFT JOIN t3 ON a<>'' WHERE c<>'';
511 SELECT * FROM t1 RIGHT JOIN t2 ON true LEFT JOIN t3 ON a<>'' WHERE c IS NOT NULL;
514 SELECT * FROM t1 RIGHT JOIN t2 ON true JOIN t3 ON a<>'' WHERE c<>'';
517 SELECT * FROM t1 RIGHT JOIN t2 ON true JOIN t3 ON a<>'' WHERE c IS NOT NULL;
526 CREATE TABLE t2(z INT);
531 SELECT * FROM t2 RIGHT JOIN t1 ON true;
534 SELECT 99=id AND 0=y AS "truth" FROM t2 RIGHT JOIN t1 ON true;
537 SELECT (99, 0)==(id, y) AS "truth" FROM t2 RIGHT JOIN t1;
540 SELECT * FROM t2 RIGHT JOIN t1 WHERE 99=id AND 0=y;
543 SELECT * FROM t2 RIGHT JOIN t1 WHERE 99=+id AND 0=y;
546 SELECT * FROM t2 RIGHT JOIN t1 WHERE (99, 0)==(id,y);
549 SELECT * FROM t2 RIGHT JOIN t1 WHERE (99, 0)==(+id,y);
552 SELECT * FROM t2 RIGHT JOIN t1 WHERE 1=id AND 0=y;
555 SELECT * FROM t2 RIGHT JOIN t1 WHERE 1=+id AND 0=y;
558 SELECT * FROM t2 RIGHT JOIN t1 WHERE (1, 0)==(id,y);
561 SELECT * FROM t2 RIGHT JOIN t1 WHERE (1, 0)==(+id,y);
582 CREATE TABLE t2(x INT); INSERT INTO t2 VALUES (0);
583 SELECT *, x NOTNULL, (x NOTNULL)=a FROM t2 RIGHT JOIN t1 ON true WHERE (x NOTNULL)=a;
587 SELECT *, x NOTNULL, (x NOTNULL)=a FROM t2 RIGHT JOIN t1 ON true WHERE (x NOTNULL)=a;
593 SELECT *, x NOTNULL, (x NOTNULL)=a FROM t2 RIGHT JOIN t1 ON true INNER JOIN t3 ON (x NOTNULL)=a;
602 SELECT *, x NOTNULL, (x NOTNULL)=a FROM t2
606 SELECT *, x NOTNULL, (x NOTNULL)=a FROM t2
615 CREATE TABLE t2(b INT, c INT);
619 INSERT INTO t2 VALUES(50,51);
622 CREATE INDEX t2b ON t2( (b IS NOT NULL) );
626 SELECT * FROM t1 LEFT JOIN t2 ON true INNER JOIN t3 ON (b IS NOT NULL)=0;
636 CREATE TABLE t2(z TEXT);
640 SELECT * FROM t2 JOIN v0 ON z<>'bbb' RIGHT JOIN t1 ON z<>'ccc';
643 SELECT * FROM t2 JOIN v0 ON z<>'bbb' RIGHT JOIN t1 ON z<>'ccc' ORDER BY z;
646 SELECT 99 as "m" FROM t2 JOIN v0 ON z<>'bbb' RIGHT JOIN t1 ON z<>'ccc';
649 SELECT 99 as "m" FROM t2 JOIN v0 ON z<>'bbb' RIGHT JOIN t1 ON z<>'ccc' ORDER BY z;
653 FROM (SELECT 99 as "m" FROM t2 JOIN v0 ON z<>'' RIGHT JOIN t1 ON z<>'') AS "t3";
657 FROM (SELECT 99 as "m" FROM t2 JOIN v0 ON z<>'' RIGHT JOIN t1 ON z<>'' ORDER BY z) AS "t3";
669 CREATE TABLE t2(c INT); INSERT INTO t2 VALUES(NULL);
673 SELECT (b IS TRUE) FROM t1 JOIN t3 ON (b=TRUE) RIGHT JOIN t2 ON TRUE;
676 SELECT * FROM t1 JOIN t3 ON (b=TRUE) RIGHT JOIN t2 ON TRUE WHERE (b IS TRUE);
680 DROP TABLE t2;
683 CREATE TABLE t2(b INT);
689 SELECT * FROM t1 JOIN t2 ON d>b RIGHT JOIN t3 ON true WHERE +d = 0;
692 SELECT * FROM t1 JOIN t2 ON d>b RIGHT JOIN t3 ON true WHERE d = 0;
705 CREATE TABLE t2(b INT);
710 LEFT JOIN t2 ON true
727 CREATE TABLE t2(b TEXT, c TEXT NOT NULL);
728 INSERT INTO t2 VALUES('a', 'b');
737 LEFT JOIN t2 ON TRUE
744 LEFT JOIN t2 ON TRUE
773 CREATE TABLE t2(b2 INT);
783 SELECT * FROM t1 LEFT JOIN t2 ON true JOIN t3 ON (b2 IN (a1)) FULL JOIN t4 ON true;
786 SELECT 1 FROM t1 LEFT JOIN t2 ON true JOIN t3 ON (b2 IN (a1)) FULL JOIN t4 ON true;
796 CREATE TABLE t2(b INT, c INT);
797 CREATE VIEW t3(d) AS SELECT NULL FROM t2 FULL OUTER JOIN t1 ON c=a UNION ALL SELECT b FROM t2;
799 INSERT INTO t2(b, c) VALUES (99, NULL);
800 SELECT DISTINCT b, c, d FROM t2, t3 WHERE b<>0
801 UNION SELECT DISTINCT b, c, d FROM t2, t3 WHERE b ISNULL;