Lines Matching refs:LEFT

57       t1 NATURAL JOIN t2 NATURAL LEFT OUTER JOIN t3
63       t1 NATURAL LEFT OUTER JOIN t2 NATURAL JOIN t3
76         t1 NATURAL LEFT OUTER JOIN (t2 NATURAL JOIN t3)
89 # error for the ON clause of a LEFT JOIN to refer to a table to its right.
101   SELECT * FROM aa LEFT JOIN cc ON (a=b) JOIN bb ON (b=coalesce(c,1));
112 # omit unnecessary tables from a LEFT JOIN when UNIQUE, NOT NULL column 
128   SELECT v2 FROM t1 LEFT JOIN t2 USING (k2) LEFT JOIN t3_1 USING (k3);
132   `--SEARCH t2 USING INTEGER PRIMARY KEY (rowid=?) LEFT-JOIN
136   SELECT v2 FROM t1 LEFT JOIN t2 USING (k2) LEFT JOIN t3_2 USING (k3);
140   `--SEARCH t2 USING INTEGER PRIMARY KEY (rowid=?) LEFT-JOIN
145 # LEFT JOIN query.
161   SELECT v1, v3 FROM c1 LEFT JOIN c2 ON (c2.k=v1) LEFT JOIN c3 ON (c3.k=v2);
164   SELECT v1, v3 FROM c1 LEFT JOIN c2 ON (c2.k=v1) LEFT JOIN c3 ON (c3.k=v1+1);
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);
180   |--SEARCH c2 USING INTEGER PRIMARY KEY (rowid=?) LEFT-JOIN
181   `--SEARCH c3 USING INTEGER PRIMARY KEY (rowid=?) LEFT-JOIN
184   SELECT v1, v3 FROM c1 LEFT JOIN c2 ON (c2.k=v1) LEFT JOIN c3 ON (c3.k=v1+1);
188   `--SEARCH c3 USING INTEGER PRIMARY KEY (rowid=?) LEFT-JOIN
208   SELECT v1, v3 FROM c1 LEFT JOIN c2 ON (c2.k=v1) LEFT JOIN c3 ON (c3.k=v2);
211   SELECT v1, v3 FROM c1 LEFT JOIN c2 ON (c2.k=v1) LEFT JOIN c3 ON (c3.k=v1+1);
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);
223   SELECT v1, v3 FROM c1 LEFT JOIN c2 ON (c2.k=v1) LEFT JOIN c3 ON (c3.k=v2);
227   |--SEARCH c2 USING INDEX sqlite_autoindex_c2_1 (k=?) LEFT-JOIN
228   `--SEARCH c3 USING INDEX sqlite_autoindex_c3_1 (k=?) LEFT-JOIN
231   SELECT v1, v3 FROM c1 LEFT JOIN c2 ON (c2.k=v1) LEFT JOIN c3 ON (c3.k=v1+1);
235   `--SEARCH c3 USING INDEX sqlite_autoindex_c3_1 (k=?) LEFT-JOIN
239 # OSSFuzz found an assertion fault in the new LEFT JOIN eliminator code.
248     LEFT JOIN t1 AS b ON (a.x=b.x)
249     LEFT JOIN t2 AS c ON (a.x=c.x);
257     LEFT JOIN t1 AS b ON (a.x=b.x)
258     LEFT JOIN t2 AS c ON (a.x=c.x);
281   SELECT u2.* FROM u2 LEFT JOIN u1 ON( u1.a=u2.a AND u1.b=u2.b AND u1.c=u2.c );
292       FROM t1 LEFT JOIN (SELECT * FROM t2, t3) ON (c=b AND x=9)
307   SELECT * FROM t0 LEFT JOIN t1 
333   SELECT * FROM t0 LEFT JOIN v0 WHERE v0.c0 >= '0';
337   SELECT * FROM t0 LEFT JOIN v0 ON v0.c0 >= '0';
341   SELECT * FROM t0 LEFT JOIN v0 ON v0.c0 >= '0' WHERE TRUE 
350   SELECT ccc, ccc IS NULL AS ddd FROM t1 LEFT JOIN v2;
354   SELECT ccc, ccc IS NULL AS ddd FROM t1 LEFT JOIN v2;