Lines Matching refs:LEFT

73   execsql {SELECT * FROM xy LEFT JOIN ab ON 0}
76   execsql {SELECT * FROM xy LEFT JOIN ab ON 1}
79   execsql {SELECT * FROM xy LEFT JOIN ab ON NULL}
82   execsql {SELECT * FROM xy LEFT JOIN ab ON 0 WHERE 0}
85   execsql {SELECT * FROM xy LEFT JOIN ab ON 1 WHERE 0}
88   execsql {SELECT * FROM xy LEFT JOIN ab ON NULL WHERE 0}
91   execsql {SELECT * FROM xy LEFT JOIN ab ON 0 WHERE 1}
94   execsql {SELECT * FROM xy LEFT JOIN ab ON 1 WHERE 1}
97   execsql {SELECT * FROM xy LEFT JOIN ab ON NULL WHERE 1}
100   execsql {SELECT * FROM xy LEFT JOIN ab ON 0 WHERE NULL}
103   execsql {SELECT * FROM xy LEFT JOIN ab ON 1 WHERE NULL}
106   execsql {SELECT * FROM xy LEFT JOIN ab ON NULL WHERE NULL}
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;
161   SELECT * FROM x1 LEFT JOIN x2 JOIN x3 WHERE x3.d = x2.b;
165 # 2015-08-20.  LEFT JOIN and the push-down optimization.
177   LEFT JOIN (
184          LEFT JOIN (SELECT 1) ON fruit='banana';
195   SELECT count(z) FROM y1 LEFT JOIN y2 ON x GROUP BY y;
199   SELECT count(z) FROM ( SELECT * FROM y1 ) LEFT JOIN y2 ON x GROUP BY y;
204   SELECT count(z) FROM v1 LEFT JOIN y2 ON x GROUP BY y;
208   SELECT count(z) FROM ( SELECT * FROM y1 ) LEFT JOIN y2 ON x
212   SELECT * FROM ( SELECT * FROM y1 ) LEFT JOIN y2 ON x
229   SELECT * FROM t1 LEFT JOIN t2 ON a=2 OR b=3 WHERE y IS NULL;
236   SELECT ifnull(z, '!!!') FROM t3 LEFT JOIN t4 ON (x=y);
241   SELECT ifnull(z, '!!!') FROM t3 LEFT JOIN t4 ON (x=y);
275   SELECT * FROM t1 LEFT JOIN t2 ON (
283      |  `--SEARCH t2 USING INDEX t2xy (x=? AND y=?) LEFT-JOIN
285         `--SEARCH t2 USING INDEX t2xy (x=? AND y=?) LEFT-JOIN
302   SELECT * FROM t3 LEFT JOIN t4 ON (t4.x = t3.x) WHERE (t4.y = ? OR t4.z = ?);
306   `--SEARCH t4 USING INDEX t4xz (x=?) LEFT-JOIN
349   SELECT a FROM (SELECT a FROM t1 NATURAL LEFT JOIN t1) NATURAL LEFT JOIN t1 WHERE (rowid,1)<=(5,0);
371 # Bloom-filter on a LEFT JOIN with NULL-based WHERE constraints.
387   SELECT count(*) FROM t1 LEFT JOIN t2 ON c=b WHERE d IS NULL;
390   SELECT count(*) FROM t1 LEFT JOIN t2 ON c=b WHERE d=100;
393   SELECT count(*) FROM t1 LEFT JOIN t2 ON c=b WHERE d>=300;