Lines Matching refs:LEFT

165 # 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);
180     SELECT * FROM t41 AS x LEFT JOIN t42 AS y ON (y.d=x.c) OR (y.e=x.b);
185     SELECT * FROM t41 AS x LEFT JOIN t42 AS y ON (y.d=x.c) OR (y.d=x.b);
190 # Incorrect result on LEFT JOIN with OR constraints and an ORDER BY clause.
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
417     FROM foo LEFT JOIN bar