Home
last modified time | relevance | path

Searched refs:RIGHT (Results 1 – 25 of 34) sorted by relevance

12

/sqlite-3.40.0/test/
H A DjoinB.test100 RIGHT JOIN t5 USING(a)
200 RIGHT JOIN t5 USING(a)
254 RIGHT JOIN t4 USING(a)
279 RIGHT JOIN t4 USING(a)
305 RIGHT JOIN t4 USING(a)
306 RIGHT JOIN t5 USING(a)
350 NATURAL RIGHT JOIN t4
4448 RIGHT JOIN (t2 RIGHT JOIN t3 USING(a)) USING(a)
4563 RIGHT JOIN (t2 RIGHT JOIN t3 USING(a)) USING(a)
4675 RIGHT JOIN (t2 RIGHT JOIN t3 USING(a)) USING(a)
[all …]
H A DjoinC.test170 t3 RIGHT JOIN (
184 t3 RIGHT JOIN (
198 t3 RIGHT JOIN (
212 t3 RIGHT JOIN (
406 t3 RIGHT JOIN (
421 t3 RIGHT JOIN (
436 t3 RIGHT JOIN (
451 t3 RIGHT JOIN (
525 t2 RIGHT JOIN (
539 t2 RIGHT JOIN (
[all …]
H A DjoinF.test82 RIGHT JOIN t4 ON true
91 RIGHT JOIN t4 ON true
134 RIGHT JOIN t4 ON true
143 RIGHT JOIN t4 ON true
194 RIGHT JOIN t4 ON true
204 RIGHT JOIN t4 ON true
249 RIGHT JOIN t4 ON true
258 RIGHT JOIN t4 ON true
303 RIGHT JOIN t4 ON true
312 RIGHT JOIN t4 ON true
[all …]
H A Djoin8.test185 # Bloom filter usage by RIGHT and FULL JOIN
218 RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
238 RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
257 RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
345 # index-on-expr scan on a RIGHT JOIN
390 SELECT * FROM t1 RIGHT JOIN t2 ON t2.a<>0 NATURAL RIGHT JOIN t3;
531 SELECT * FROM t2 RIGHT JOIN t1 ON true;
711 RIGHT JOIN t3 ON true
712 RIGHT JOIN t4 ON true
739 RIGHT JOIN t4 ON b='';
[all …]
H A DjoinD.test826 RIGHT JOIN t4 ON t1.d=t4.d
997 RIGHT JOIN t4 ON t4.z>0
3022 RIGHT JOIN t4 ON t4.z>0
4132 RIGHT JOIN t3 ON t3.y>0
4605 RIGHT JOIN t3 ON t3.y>0
5029 RIGHT JOIN t3 ON t3.y>0
5043 RIGHT JOIN t4 ON t4.z>0
5668 RIGHT JOIN t3 ON t3.y>0
7282 RIGHT JOIN t4 ON t4.z>0
9380 RIGHT JOIN t4 ON t4.z>0
[all …]
H A Dmerge1.test68 | | `--RIGHT
70 | `--RIGHT
72 `--RIGHT
78 | `--RIGHT
80 `--RIGHT
133 | | | | `--RIGHT
135 | | | `--RIGHT
137 | | `--RIGHT
139 | `--RIGHT
141 `--RIGHT
H A DjoinA.test13 # This file implements tests for RIGHT and FULL OUTER JOINs.
97 RIGHT JOIN t3 USING(a,b,f)
110 RIGHT JOIN t2 USING(c,d)
112 RIGHT JOIN t4 USING(a,c,d,f)
127 RIGHT JOIN t4 USING(a,c,d,f)
140 RIGHT JOIN t2 USING(c,d)
142 RIGHT JOIN t4 USING(a,c,d,f)
155 RIGHT JOIN t2 USING(c,d)
175 RIGHT JOIN t3 USING(a,b,f)
H A DjoinE.test125 FROM t1 RIGHT JOIN t2 ON true
135 FROM t1 RIGHT JOIN t2 ON true WHERE a IS NULL
143 FROM t1 RIGHT JOIN t2 ON a IS NULL
151 FROM t1 RIGHT JOIN t2 ON true WHERE b IS NULL
159 FROM t1 RIGHT JOIN t2 ON b IS NULL
290 FROM t1 RIGHT JOIN t2 ON true
298 FROM t1 RIGHT JOIN t2 ON true WHERE a IS NULL
305 FROM t1 RIGHT JOIN t2 ON a IS NULL
319 FROM t1 RIGHT JOIN t2 ON b IS NULL
388 # foreach j1 {INNER LEFT RIGHT FULL} {
[all …]
H A Dautoindex4.test36 SELECT t1.*, t2.*, '|' FROM t2 RIGHT JOIN t1 ON a=234 AND x=555;
42 SELECT t1.*, t2.*, '|' FROM t2 RIGHT JOIN t1 ON x=555 WHERE a=234;
48 SELECT t1.*, t2.*, '|' FROM t2 RIGHT JOIN t1 WHERE a=234 AND x=555;
83 RIGHT JOIN Items ON (A.Name = Items.ItemName and Items.ItemName = 'dummy')
101 RIGHT JOIN Items ON (A.Name = Items.ItemName and Items.ItemName = 'dummy')
H A Deqp.test354 `--RIGHT
366 `--RIGHT
378 `--RIGHT
390 `--RIGHT
403 `--RIGHT
414 `--RIGHT
416 `--USE TEMP B-TREE FOR RIGHT PART OF ORDER BY
426 `--RIGHT
438 `--RIGHT
476 | `--RIGHT
[all …]
H A Djoin9.test13 # This file implements tests for RIGHT and FULL OUTER JOINs.
147 FROM t5 NATURAL RIGHT JOIN t4 NATURAL LEFT JOIN t6
158 FROM t5 NATURAL RIGHT JOIN t4 NATURAL LEFT JOIN t6
170 FROM t4 NATURAL RIGHT JOIN t5 NATURAL RIGHT JOIN t6
182 FROM t4 NATURAL RIGHT JOIN t5 NATURAL RIGHT JOIN t6
486 t4 RIGHT JOIN (
H A Dupfrom4.test49 UPDATE t5 SET b=y, c=v FROM m2 RIGHT JOIN m1 ON (x=u) WHERE x=a;
71 FROM dual, c1 NATURAL RIGHT JOIN c2
89 FROM dual, c1 NATURAL RIGHT JOIN c2
H A Daffinity3.test36 RIGHT JOIN customer c ON i.id=c.id;
45 FROM v1 RIGHT JOIN customer c ON v1.id=c.id;
49 FROM v1rj RIGHT JOIN customer c ON v1rj.id=c.id;
H A Djoin7.test13 # This file implements tests for RIGHT and FULL OUTER JOINs.
209 SELECT * FROM t1 RIGHT OUTER JOIN t2 ON b=c ORDER BY +b;
223 SELECT * FROM dual JOIN t1 ON true RIGHT OUTER JOIN t2 ON b=c ORDER BY +b;
238 SELECT * FROM dual CROSS JOIN t1 RIGHT OUTER JOIN t2 ON b=c ORDER BY +b;
246 FROM t1 CROSS JOIN dual RIGHT OUTER JOIN t2 ON b=c ORDER BY +b;
H A DjoinH.test81 SELECT (d IS NULL) FROM t1 RIGHT JOIN t2 ON (j=33);
89 SELECT (d IS NULL) FROM t1 RIGHT JOIN t2 ON (j=33);
H A Dwith6.test280 | `--RIGHT-JOIN t3
299 `--RIGHT-JOIN t3
317 `--RIGHT-JOIN t3
H A Djoin2.test69 t2 NATURAL RIGHT OUTER JOIN t1 NATURAL JOIN t3
82 t2 NATURAL JOIN t3 NATURAL RIGHT JOIN t1
104 SELECT * FROM aa RIGHT JOIN cc ON (a=b) JOIN bb ON (b=coalesce(c,1));
H A Drowvalue.test270 SELECT t1.*, t2.* FROM t2 RIGHT JOIN t1 ON (a,b)=(x,y);
648 SELECT 21 FROM t0 RIGHT JOIN t1 ON (c0, x'') != (NULL, 0);
654 SELECT 31 FROM t0 RIGHT JOIN t1 WHERE (c0, x'') != (NULL, 0);
722 SELECT * FROM b RIGHT JOIN a ON b2=NULL AND b2=5 WHERE (b1,substr(b.b1,1,1))==(SELECT 1024,'b');
732 SELECT * FROM t2 RIGHT JOIN t1 ON b=NULL WHERE (c,d)==(SELECT 123, 456+a);
H A Dvtab6.test228 # SELECT * FROM t1 NATURAL RIGHT OUTER JOIN t2;
230 #} {1 {RIGHT and FULL OUTER JOINs are not currently supported}}
H A Dbtree01.test152 SELECT y, c FROM t1 RIGHT JOIN t2 ON y=a ORDER BY x;
H A Dindex6.test513 # Cannot do a scan of a partial index on the left table of a RIGHT JOIN
528 SELECT * FROM t2 RIGHT JOIN t3 ON d<>0 LEFT JOIN t1 ON c=3 WHERE t1.a<>0;
H A Dcost.test106 `--USE TEMP B-TREE FOR RIGHT PART OF ORDER BY
H A Daltertab3.test434 CAST(CAST(CAST(CAST(CAST(CAST(CAST(CAST(CAST(CAST(CAST(RIGHT
484 WITH x(a) AS(SELECT * FROM s) VALUES(RIGHT)
/sqlite-3.40.0/ext/fts3/unicode/
H A DUnicodeData.txt7770 2326;ERASE TO THE RIGHT;So;0;ON;;;;;N;DELETE TO THE RIGHT KEY;;;;
8304 2576;BOX DRAWINGS LIGHT RIGHT;So;0;ON;;;;;N;FORMS LIGHT RIGHT;;;;
8308 257A;BOX DRAWINGS HEAVY RIGHT;So;0;ON;;;;;N;FORMS HEAVY RIGHT;;;;
8342 259C;QUADRANT UPPER LEFT AND UPPER RIGHT AND LOWER RIGHT;So;0;ON;;;;;N;;;;;
8345 259F;QUADRANT UPPER RIGHT AND LOWER LEFT AND LOWER RIGHT;So;0;ON;;;;;N;;;;;
8866 27A9;RIGHT-SHADED WHITE RIGHTWARDS ARROW;So;0;ON;;;;;N;RIGHT-SHADED WHITE RIGHT ARROW;;;;
8870 27AD;HEAVY LOWER RIGHT-SHADOWED WHITE RIGHTWARDS ARROW;So;0;ON;;;;;N;HEAVY LOWER RIGHT-SHADOWED WHI…
8871 27AE;HEAVY UPPER RIGHT-SHADOWED WHITE RIGHTWARDS ARROW;So;0;ON;;;;;N;HEAVY UPPER RIGHT-SHADOWED WHI…
8872 27AF;NOTCHED LOWER RIGHT-SHADOWED WHITE RIGHTWARDS ARROW;So;0;ON;;;;;N;NOTCHED LOWER RIGHT-SHADOWED…
8874 27B1;NOTCHED UPPER RIGHT-SHADOWED WHITE RIGHTWARDS ARROW;So;0;ON;;;;;N;NOTCHED UPPER RIGHT-SHADOWED…
[all …]
/sqlite-3.40.0/ext/rtree/
H A Drtree1.test746 SELECT * FROM t1 JOIN t0 ON x0>a RIGHT JOIN rt0 ON true WHERE +x0 = 0;
749 SELECT * FROM t1 JOIN t0 ON x0>a RIGHT JOIN rt0 ON true WHERE x0 = 0;
753 SELECT * FROM t1 JOIN t0 ON true RIGHT JOIN rt0 ON x0>a WHERE +x0 = 0;
756 SELECT * FROM t1 JOIN t0 ON true RIGHT JOIN rt0 ON x0>a WHERE x0 = 0;

12