Home
last modified time | relevance | path

Searched refs:LEFT (Results 1 – 25 of 105) sorted by relevance

12345

/sqlite-3.40.0/test/
H A Djoin2.test128 SELECT v2 FROM t1 LEFT JOIN t2 USING (k2) LEFT JOIN t3_1 USING (k3);
136 SELECT v2 FROM t1 LEFT JOIN t2 USING (k2) LEFT JOIN t3_2 USING (k3);
145 # LEFT JOIN query.
161 SELECT v1, v3 FROM c1 LEFT JOIN c2 ON (c2.k=v1) LEFT JOIN c3 ON (c3.k=v2);
168 SELECT DISTINCT v1, v3 FROM c1 LEFT JOIN c2 LEFT JOIN c3 ON (c3.k=v1+1);
172 SELECT v1, v3 FROM c1 LEFT JOIN c2 LEFT JOIN c3 ON (c3.k=v1+1);
176 SELECT v1, v3 FROM c1 LEFT JOIN c2 ON (c2.k=v1) LEFT JOIN c3 ON (c3.k=v2);
208 SELECT v1, v3 FROM c1 LEFT JOIN c2 ON (c2.k=v1) LEFT JOIN c3 ON (c3.k=v2);
215 SELECT DISTINCT v1, v3 FROM c1 LEFT JOIN c2 LEFT JOIN c3 ON (c3.k=v1+1);
219 SELECT v1, v3 FROM c1 LEFT JOIN c2 LEFT JOIN c3 ON (c3.k=v1+1);
[all …]
H A DjoinB.test187 LEFT JOIN (t4 LEFT JOIN t5 USING(a)) USING(a)
603 LEFT JOIN (t4 LEFT JOIN t5 USING(a)) USING(a)
1039 LEFT JOIN (t4 LEFT JOIN t5 USING(a)) USING(a)
1489 LEFT JOIN (t4 LEFT JOIN t5 USING(a)) USING(a)
1926 LEFT JOIN (t4 LEFT JOIN t5 USING(a)) USING(a)
2250 LEFT JOIN (t2 LEFT JOIN t3 USING(a)) USING(a)
2355 LEFT JOIN (t2 LEFT JOIN t3 USING(a)) USING(a)
2356 LEFT JOIN (t4 LEFT JOIN t5 USING(a)) USING(a)
2463 LEFT JOIN (t2 LEFT JOIN t3 USING(a)) USING(a)
2574 LEFT JOIN (t2 LEFT JOIN t3 USING(a)) USING(a)
[all …]
H A DjoinC.test110 t3 LEFT JOIN (
125 t3 LEFT JOIN (
140 t3 LEFT JOIN (
155 t3 LEFT JOIN (
285 t2 LEFT JOIN (
300 t2 LEFT JOIN (
315 t2 LEFT JOIN (
330 t2 LEFT JOIN (
345 t2 LEFT JOIN (
346 t3 LEFT JOIN (
[all …]
H A Dwhere6.test30 SELECT * FROM t1 LEFT JOIN t2 ON b=x AND c=1;
35 SELECT * FROM t1 LEFT JOIN t2 ON x=b AND c=1;
40 SELECT * FROM t1 LEFT JOIN t2 ON x=b AND 1=c;
45 SELECT * FROM t1 LEFT JOIN t2 ON b=x AND 1=c;
60 SELECT * FROM t1 LEFT JOIN t2 ON b=x WHERE c=1;
65 SELECT * FROM t1 LEFT JOIN t2 ON x=b WHERE c=1;
70 SELECT * FROM t1 LEFT JOIN t2 ON b=x WHERE 1=c;
80 SELECT * FROM t1 LEFT JOIN t2 ON b=x AND c=1;
85 SELECT * FROM t1 LEFT JOIN t2 ON x=b AND c=1;
90 SELECT * FROM t1 LEFT JOIN t2 ON x=b AND 1=c;
[all …]
H A DjoinF.test65 LEFT JOIN t4 ON true
73 LEFT JOIN t4 ON true
117 LEFT JOIN t4 ON true
125 LEFT JOIN t4 ON true
173 LEFT JOIN t4 ON true
183 LEFT JOIN t4 ON true
232 LEFT JOIN t4 ON true
240 LEFT JOIN t4 ON true
285 LEFT JOIN t4 ON true
294 LEFT JOIN t4 ON true
[all …]
H A Djoin.test366 } {1 {unknown join type: LEFT BOGUS}}
519 # LEFT JOIN evaluate to NULL for rows where the LEFT JOIN does not
856 FROM t1 LEFT JOIN t2
861 FROM t1 LEFT JOIN t2
866 FROM t1 LEFT JOIN t2
871 FROM t1 LEFT JOIN t2
876 FROM t1 LEFT JOIN t2
917 FROM t1 LEFT JOIN t2 ON 0
971 SELECT * FROM t1 LEFT JOIN t2
1007 # right table of a LEFT JOIN.
[all …]
H A Djoin5.test73 execsql {SELECT * FROM xy LEFT JOIN ab ON 0}
76 execsql {SELECT * FROM xy LEFT JOIN ab ON 1}
110 # Incorrect output on a LEFT JOIN.
123 SELECT * FROM x1 LEFT JOIN x2 LEFT JOIN x3 ON x3.d = x2.b;
145 LEFT JOIN t4 ON t4.w = t3.w
146 LEFT JOIN t5 ON t5.z = t4.z
147 LEFT JOIN t2 ON t2.u = t5.m
148 LEFT JOIN t1 xyz ON xyz.y = t2.x;
177 LEFT JOIN (
275 SELECT * FROM t1 LEFT JOIN t2 ON (
[all …]
H A Dcursorhint2.test13 # involving LEFT JOIN.
71 SELECT * FROM t1 LEFT JOIN t2 ON (a=c) WHERE d IS NULL;
77 SELECT * FROM t1 LEFT JOIN t2 ON (a=c AND a=10) WHERE d IS NULL;
89 SELECT * FROM t1 LEFT JOIN t2 ON (a=c) LEFT JOIN t3 ON (d=f);
96 SELECT * FROM t1 LEFT JOIN t2 ON (a=c AND d=e) LEFT JOIN t3 ON (d=f);
110 SELECT * FROM x1 LEFT JOIN x2 ON (a=x) WHERE b IS NULL;
116 SELECT * FROM x1 LEFT JOIN x2 ON (a=x) WHERE b IS +NULL;
122 SELECT * FROM x1 LEFT JOIN x2 ON (a=x) WHERE 1 = (b IS NULL)
155 SELECT * FROM x1 LEFT JOIN x2 ON (a=x) WHERE b IS NOT +NULL
161 SELECT * FROM x1 LEFT JOIN x2 ON (a=x)
[all …]
H A Dtkt1537.test28 SELECT * FROM t1 LEFT JOIN t2 ON a1=b OR a2=+b;
33 SELECT * FROM t1 LEFT JOIN t2 ON a1=b OR a2=b;
38 SELECT * FROM t2 LEFT JOIN t1 ON a1=b OR a2=b;
44 SELECT * FROM t1 LEFT JOIN t2 ON b IN (a1,a2);
49 SELECT * FROM t2 LEFT JOIN t1 ON b IN (a2,a1);
58 SELECT * FROM t1 LEFT JOIN t2 ON a1=b OR a2=b;
63 SELECT * FROM t2 LEFT JOIN t1 ON a1=b OR a2=b;
70 SELECT * FROM t1 LEFT JOIN t2 ON b IN (a1,a2);
75 SELECT * FROM t2 LEFT JOIN t1 ON b IN (a2,a1);
88 SELECT * FROM t1 LEFT JOIN t2 ON b BETWEEN a1 AND a2;
[all …]
H A DjoinD.test451 LEFT JOIN t4 ON t1.d=t4.d
463 LEFT JOIN t4 ON t1.d=t4.d
487 LEFT JOIN t4 ON t1.d=t4.d
499 LEFT JOIN t4 ON t1.d=t4.d
618 LEFT JOIN t4 ON t4.z>0
1864 LEFT JOIN t3 ON t3.y>0
2537 LEFT JOIN t3 ON t3.y>0
2562 LEFT JOIN t4 ON t4.z>0
3008 LEFT JOIN t3 ON t3.y>0
3780 LEFT JOIN t3 ON t3.y>0
[all …]
H A Daltertab3.test437 CROSS,CROSS,NATURAL,sqlite_master(*)OVER a,(WITH a AS(VALUES(LEFT)UNION
438 VALUES(LEFT)UNION VALUES(LEFT)UNION VALUES(LEFT)UNION VALUES(LEFT)UNION
439 VALUES(LEFT)UNION VALUES(LEFT))VALUES(LEFT))IN
440 STORED,LEFT,LEFT,LEFT,LEFT,LEFT,LEFT)*LEFT FOLLOWING)ORDER BY
441 LEFT,LEFT,LEFT,LEFT,LEFT,LEFT,LEFT,LEFT,LEFT,LEFT,LEFT LIMIT
442 LEFT,INDEXED(*)OVER(PARTITION BY
443 CROSS,CROSS,CROSS,LEFT,INDEXED(*)OVER(PARTITION BY
445 LEFT,LEFT,LEFT,LEFT,LEFT,LEFT,LEFT,LEFT,LEFT,LEFT,LEFT),
446 LEFT,LEFT,INNER,CROSS,CROSS,CROSS,INNER,NATURAL ORDER BY
450 } {1 {error in view q: no such column: LEFT}}
H A Dtkt-31338dca7e.test95 SELECT * FROM t3 LEFT JOIN t1 ON d=g LEFT JOIN t4 ON c=h
105 SELECT * FROM t3 LEFT JOIN t1 ON d=g LEFT JOIN t4 ON c=h
115 SELECT * FROM t3 LEFT JOIN t1 ON d=g LEFT JOIN t4 ON c=h
125 SELECT * FROM t3 LEFT JOIN t1 ON d=g LEFT JOIN t4 ON c=h
140 SELECT * FROM t3 LEFT JOIN t1 ON d=g LEFT JOIN t4 ON c=h
157 SELECT * FROM t3 LEFT JOIN t1 ON d=g LEFT JOIN t4 ON c=h
168 SELECT * FROM t3 LEFT JOIN t1 ON d=g LEFT JOIN t4 ON c=h
H A Dwhere3.test13 # in cases that include a LEFT JOIN.
156 SELECT * FROM tA, tB, tC LEFT JOIN tD ON dpk=cx
162 SELECT * FROM tA, tB, tC LEFT JOIN tD ON cx=dpk
168 SELECT * FROM tA, tB, tC LEFT JOIN tD ON cx=dpk
174 SELECT * FROM tA, tB, tC LEFT JOIN tD ON cx=dpk
180 SELECT * FROM tA, tB, tC LEFT JOIN tD ON dpk=cx
186 SELECT * FROM tA, tB, tC LEFT JOIN tD ON dpk=cx
192 SELECT * FROM tA, tB, tC LEFT JOIN tD ON dpk=cx
467 SELECT x1 FROM t71 LEFT JOIN t72 ON x2=y1;
482 SELECT x3 FROM t73 LEFT JOIN t72 ON x2=y3;
[all …]
H A Dmerge1.test62 |--LEFT
64 | |--LEFT
66 | | |--LEFT
74 |--LEFT
76 | |--LEFT
123 |--LEFT
125 | |--LEFT
127 | | |--LEFT
129 | | | |--LEFT
131 | | | | |--LEFT
H A Dautoindex4.test33 SELECT *, '|' FROM t1 LEFT JOIN t2 ON a=234 AND x=555;
39 SELECT *, '|' FROM t1 LEFT JOIN t2 ON x=555 WHERE a=234;
45 SELECT *, '|' FROM t1 LEFT JOIN t2 WHERE a=234 AND x=555;
76 LEFT JOIN B ON (B.Name = Items.ItemName)
84 LEFT JOIN B ON (B.Name = Items.ItemName)
94 LEFT JOIN B ON (B.Name = Items.ItemName)
102 LEFT JOIN B ON (B.Name = Items.ItemName)
115 {LEFT JOIN}
123 {LEFT JOIN}
147 {LEFT JOIN}
[all …]
H A Dvtab6.test218 SELECT * FROM t1 NATURAL LEFT JOIN t2;
223 SELECT * FROM t2 NATURAL LEFT OUTER JOIN t1;
233 SELECT * FROM t1 LEFT JOIN t2 ON t1.a=t2.d
238 SELECT * FROM t1 LEFT JOIN t2 ON t1.a IS t2.d
291 SELECT * FROM t1 LEFT BOGUS JOIN t2;
293 } {1 {unknown join type: LEFT BOGUS}}
394 SELECT * FROM t9 LEFT JOIN v10_11 ON( a=x );
407 SELECT * FROM v10_11 LEFT JOIN t9 ON( a=x );
436 SELECT * FROM t12 NATURAL LEFT JOIN t13
446 SELECT * FROM t12 NATURAL LEFT JOIN t13
[all …]
H A Djoin8.test54 NATURAL LEFT FULL JOIN t1
58 NATURAL LEFT JOIN t1
61 NATURAL LEFT FULL JOIN t1
277 FROM t3 LEFT JOIN t2 ON true
282 FROM t3 LEFT JOIN t2 ON true
405 SELECT * FROM t1 LEFT JOIN t2 ON t2.a<>0 NATURAL LEFT JOIN t3;
477 SELECT * FROM t4 LEFT JOIN t5 ON x=y LEFT JOIN t6 ON (x=z) ORDER BY +x;
480 SELECT * FROM t4 LEFT JOIN t5 ON x=y LEFT JOIN t6 ON (x=z)
710 LEFT JOIN t2 ON true
737 LEFT JOIN t2 ON TRUE
[all …]
H A DselectD.test124 FROM t1 LEFT JOIN (t2 LEFT JOIN (t3 LEFT JOIN t4 USING(a))
134 FROM (t1 LEFT JOIN t2 USING(a)) JOIN (t3 LEFT JOIN t4 USING(a))
142 FROM (t1 LEFT JOIN t2 USING(a)) JOIN (t3 LEFT JOIN t4 USING(a))
149 FROM (t1 LEFT JOIN t2 USING(a)) JOIN (t3 LEFT JOIN t4 USING(a))
167 LEFT JOIN (SELECT count(*) AS cnt, x1.d
H A DjoinA.test81 LEFT JOIN t2 USING(c,d)
82 LEFT JOIN t3 USING(a,b,f)
83 LEFT JOIN t4 USING(a,c,d,f)
96 LEFT JOIN t2 USING(c,d)
98 LEFT JOIN t4 USING(a,c,d,f)
111 LEFT JOIN t3 USING(a,b,f)
126 LEFT JOIN t3 USING(a,b,f)
156 LEFT JOIN t3 USING(a,b,f)
174 LEFT JOIN t2 USING(c,d)
H A DjoinE.test82 FROM t1 LEFT JOIN t2 ON true
92 FROM t1 LEFT JOIN t2 ON true WHERE a IS NULL
100 FROM t1 LEFT JOIN t2 ON a IS NULL
109 FROM t1 LEFT JOIN t2 ON true WHERE b IS NULL
117 FROM t1 LEFT JOIN t2 ON b IS NULL
256 FROM t1 LEFT JOIN t2 ON true
263 FROM t1 LEFT JOIN t2 ON true WHERE a IS NULL
269 FROM t1 LEFT JOIN t2 ON a IS NULL
283 FROM t1 LEFT JOIN t2 ON b IS NULL
388 # foreach j1 {INNER LEFT RIGHT FULL} {
[all …]
H A Dunionall.test134 SELECT * FROM t1 LEFT JOIN t2 ON (x=k);
301 SELECT * FROM t1 LEFT JOIN t3 ON a=k
344 …SELECT *, '+' FROM t1 LEFT JOIN t2 ON (a NOT IN(SELECT v FROM t1, t3 WHERE a=k)=NOT EXISTS(SELECT …
347 SELECT *, '+' FROM t1 LEFT JOIN t3 ON (a NOT IN(SELECT v FROM t1 LEFT JOIN t2 ON (a=k))=k);
414 …SELECT * FROM (SELECT t1.a, t1.b, t0.c0 AS c, v0.c0 AS d FROM t0 LEFT JOIN v0 ON v0.c0>'0',t1) WHE…
417 …SELECT * FROM (SELECT t1.a, t1.b, t0.c0 AS c, v0.c0 AS d FROM t0 LEFT JOIN v0 ON v0.c0>'0',t1) WHE…
420 …SELECT * FROM (SELECT t1.a, t1.b, t0.c0 AS c, v0.c0 AS d FROM t0 LEFT JOIN v0 ON v0.c0>'0',t1) WHE…
424 …SELECT * FROM (SELECT t1.a, t1.b, t0.c0 AS c, v0.c0 AS d FROM t0 LEFT JOIN v0 ON v0.c0>'0',t1) WHE…
427 …SELECT * FROM (SELECT t1.a, t1.b, t0.c0 AS c, v0.c0 AS d FROM t0 LEFT JOIN v0 ON v0.c0>'0',t1) WHE…
430 …SELECT * FROM (SELECT t1.a, t1.b, t0.c0 AS c, v0.c0 AS d FROM t0 LEFT JOIN v0 ON v0.c0>'0',t1) WHE…
[all …]
H A Ddistinctagg.test177 3 1 "SELECT count(DISTINCT a) FROM t1 LEFT JOIN t3" 4
178 4 1 "SELECT count(DISTINCT a) FROM t1 LEFT JOIN t3 WHERE t3.x=1" 4
179 5 1 "SELECT count(DISTINCT a) FROM t1 LEFT JOIN t3 WHERE t3.x=0" 0
180 6 1 "SELECT count(DISTINCT a) FROM t1 LEFT JOIN t3 ON (t3.x=0)" 4
181 7 1 "SELECT count(DISTINCT x) FROM t1 LEFT JOIN t3" 2
182 8 1 "SELECT count(DISTINCT x) FROM t1 LEFT JOIN t3 WHERE t3.x=1" 1
183 9 1 "SELECT count(DISTINCT x) FROM t1 LEFT JOIN t3 WHERE t3.x=0" 0
184 10 1 "SELECT count(DISTINCT x) FROM t1 LEFT JOIN t3 ON (t3.x=0)" 0
207 SELECT count(DISTINCT c) FROM t1 LEFT JOIN t2;
H A DwhereD.test165 # LEFT JOIN with an OR in the ON clause causes segfault
173 SELECT * FROM t41 AS x LEFT JOIN t42 AS y ON (y.d=x.c) OR (y.e=x.b);
198 LEFT JOIN (SELECT a AS c, b AS d FROM t44) AS y ON a=c
204 LEFT JOIN (SELECT a AS c, b AS d FROM t44) AS y ON a=c
211 SELECT * FROM t44 LEFT JOIN t46 ON a=c
215 SELECT * FROM t44 LEFT JOIN t46 ON a=c
342 # (because it is the right table of a LEFT JOIN that does not match)
352 SELECT t1.* FROM t1 LEFT JOIN t2 ON abs(t1.a)=abs(t2.b);
367 SELECT * FROM y1 LEFT JOIN y2 ON ((x=1 AND y=b) OR (x=2 AND y=b))
398 FROM foo LEFT JOIN bar
[all …]
H A Dwhere4.test143 SELECT * FROM t2 LEFT JOIN t3 ON a=x WHERE +y IS NULL;
148 SELECT * FROM t2 LEFT JOIN t3 ON a=x WHERE y IS NULL;
153 SELECT * FROM t2 LEFT JOIN t3 ON a=x WHERE NULL is y;
159 SELECT * FROM t2 LEFT JOIN t3 ON a=x WHERE y IS $null;
175 SELECT * FROM test t1 LEFT OUTER JOIN test2 t2 ON t1.col1 = t2.col1
181 SELECT * FROM test t1 LEFT OUTER JOIN test2 t2 ON t1.col1 = t2.col1
187 SELECT * FROM test t1 LEFT OUTER JOIN test2 t2 ON t1.col1 = t2.col1
193 SELECT * FROM test t1 LEFT OUTER JOIN test2 t2 ON t1.col1 = t2.col1
208 FROM t2 LEFT JOIN t4 b1
209 LEFT JOIN t4 b2 ON b2.x=b1.x AND b2.y IN (b1.y);
H A De_select2.test80 # If the -left option is present, the join is done LEFT JOIN style.
385 test_join $tn.4 "t1 LEFT JOIN t2 USING (a)" {
403 test_join $tn.10 "t1 NATURAL LEFT JOIN t2" {
406 test_join $tn.11 "t1 NATURAL LEFT OUTER JOIN t2" {
421 test_join $tn.16 "t2 NATURAL LEFT JOIN t1" {
424 test_join $tn.17 "t2 NATURAL LEFT OUTER JOIN t1" {
427 test_join $tn.18 "t1 LEFT JOIN t2 USING (b)" {
440 test_join $tn.23 "t1 NATURAL LEFT JOIN t3" {
443 test_join $tn.24 "t3 NATURAL LEFT JOIN t1" {
446 test_join $tn.25 "t1 LEFT JOIN t3 ON (t3.b=t1.b)" {
[all …]

12345