Lines Matching refs:RIGHT
12 # This file implements tests for RIGHT and FULL OUTER JOINs.
23 # EVIDENCE-OF: R-33754-02880 you can say "LEFT RIGHT JOIN" which is the
29 SELECT avg(DISTINCT b) FROM (SELECT * FROM t2 LEFT RIGHT JOIN t1 ON c);
34 # RIGHT JOIN body subroutine before the first use of any register containing
67 # Jump to addrHalt inside the RIGHT JOIN body subroutine bypasses the
80 SELECT * FROM t1 RIGHT JOIN t2 ON c=d JOIN t3 ON f=e;
144 SELECT a FROM t1 NATURAL RIGHT JOIN t1 WHERE a=5555 OR (1,b)==(SELECT 2 IN (2,2),4);
167 SELECT * FROM t1 AS t2 NATURAL RIGHT JOIN t1 AS t3
174 SELECT value, t1.* FROM json_each('7') NATURAL RIGHT JOIN t1
181 SELECT value, t1.* FROM json_each('17') NATURAL RIGHT JOIN t1
185 # Bloom filter usage by RIGHT and FULL JOIN
218 RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
232 # EVIDENCE-OF: R-33754-02880 you can say "LEFT RIGHT JOIN" which is the
238 RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
240 SELECT * FROM t0 LEFT RIGHT JOIN t4 ON t0.a=t4.d AND t4.z>0
257 RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
294 SELECT * FROM t1 NATURAL RIGHT JOIN t1 AS t2 WHERE (a,b) IN (SELECT a+0, b FROM t1);
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;
329 FROM t2i NATURAL JOIN t1 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;
345 # index-on-expr scan on a RIGHT JOIN
354 SELECT * FROM t1 RIGHT JOIN t2 ON (a=b) WHERE 99+(b+1)!=99;
358 SELECT * FROM t1 RIGHT JOIN t2 ON (a=b) WHERE 99+(b+1)!=99;
366 SELECT b, d FROM t1 RIGHT JOIN t2 WHERE (b+0)=1 AND d!=4;
370 SELECT b, d FROM t1 RIGHT JOIN t2 WHERE (b+0)=1 AND d!=4;
375 SELECT b, d FROM t1 RIGHT JOIN t2 WHERE (b+0)=1 AND d!=4;
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;
430 SELECT * FROM v0 RIGHT JOIN t1 ON t1.a<>'' INNER JOIN t0 ON t0.c<>'';
431 SELECT * FROM v0 RIGHT JOIN t1 ON t1.a<>'' INNER JOIN t0 ON t0.c<>'' WHERE b ISNULL;
440 SELECT * FROM y0 RIGHT JOIN y1 ON true INNER JOIN y2 ON true WHERE y2.c!=99 AND y2.c!=98;
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;
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);
569 SELECT t3.a FROM t4 RIGHT JOIN t3 ON (x=a) WHERE (b, 4)=(SELECT 3, 4);
572 SELECT t3.a FROM t4 RIGHT JOIN t3 ON (x=a) WHERE (b, 4) IS (SELECT 3, 4);
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;
603 RIGHT JOIN rtree1 ON true INNER JOIN t3 ON (x NOTNULL)=+a;
607 RIGHT JOIN rtree1 ON true INNER JOIN t3 ON (x NOTNULL)=a;
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";
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);
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;
700 # involved with a RIGHT JOIN must also be applied to automatic indexes.
711 RIGHT JOIN t3 ON true
712 RIGHT JOIN t4 ON true
720 # NOT NULL constraint is too aggresive if the query contains RIGHT JOIN.
739 RIGHT JOIN t4 ON b='';
746 RIGHT JOIN t4 ON b=''
764 SELECT * FROM t4 JOIN t7 ON true RIGHT JOIN (SELECT y AS z FROM t7) AS t6 ON (x=z);