Lines Matching refs:LEFT

13 # a LEFT OUTER JOIN are not used with indices.  See ticket #3015.
30     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;
51      explain_no_trace {SELECT * FROM t1 LEFT JOIN t2 ON x=b AND 1=c}
52   } [explain_no_trace {SELECT * FROM t1 LEFT JOIN t2 ON b=x AND c=1}]
54      explain_no_trace {SELECT * FROM t1 LEFT JOIN t2 ON x=b WHERE 1=c}
55   } [explain_no_trace {SELECT * FROM t1 LEFT JOIN t2 ON b=x WHERE c=1}]
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;
95     SELECT * FROM t1 LEFT JOIN t2 ON b=x AND 1=c;
101      explain_no_trace {SELECT * FROM t1 LEFT JOIN t2 ON x=b AND 1=c}
102   } [explain_no_trace {SELECT * FROM t1 LEFT JOIN t2 ON b=x AND c=1}]
104      explain_no_trace {SELECT * FROM t1 LEFT JOIN t2 ON x=b WHERE 1=c}
105   } [explain_no_trace {SELECT * FROM t1 LEFT JOIN t2 ON b=x WHERE c=1}]
111     SELECT * FROM t1 LEFT JOIN t2 ON b=x WHERE c=1;
116     SELECT * FROM t1 LEFT JOIN t2 ON x=b WHERE c=1;
121     SELECT * FROM t1 LEFT JOIN t2 ON x=b WHERE 1=c;
126     SELECT * FROM t1 LEFT JOIN t2 ON b=x WHERE 1=c;
131 # If the ON close on a LEFT JOIN is of the form x=y where both x and y
148            LEFT JOIN t5 ON t5.a=t4a.x AND t5.b=t4b.x
149            LEFT JOIN (SELECT 1 AS v) AS t6 ON t4a.x=t4b.x