Lines Matching refs:x1

105   CREATE TABLE x1(x, y);
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)
143     SELECT * FROM x1 CROSS JOIN x2 ON (a=x) WHERE 0 = (b IS NOT NULL)
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)