Lines Matching refs:LEFT

13 # 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)
128   SELECT * FROM x1 LEFT JOIN x2 ON (a=x) WHERE 1 = coalesce(b, 1)
134   SELECT * FROM x1 LEFT JOIN x2 ON (a=x) WHERE 1 = coalesce(b, 1)
140   # These tests no longer work due to the LEFT-JOIN strength reduction
149     SELECT * FROM x1 LEFT JOIN x2 ON (a=x) WHERE 0 = (b IS NOT +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)
168     SELECT * FROM x1 LEFT JOIN x2 ON (a=x) WHERE x2.b = 32+32
176       SELECT * FROM x1 LEFT JOIN x2 ON (a=x) WHERE x2.b LIKE 'abc%'
184   SELECT * FROM x1 LEFT JOIN x2 ON (a=x) WHERE coalesce(x2.b, 1)