Lines Matching refs:x2

106   CREATE TABLE x2(a, b);
110   SELECT * FROM x1 LEFT JOIN x2 ON (a=x) WHERE b IS NULL;
112   x2 {EQ(c0,r[2])}
116   SELECT * FROM x1 LEFT JOIN x2 ON (a=x) WHERE b IS +NULL;
118   x2 {EQ(c0,r[2])}
122   SELECT * FROM x1 LEFT JOIN x2 ON (a=x) WHERE 1 = (b IS NULL)
124   x2 {EQ(c0,r[2])}
128   SELECT * FROM x1 LEFT JOIN x2 ON (a=x) WHERE 1 = coalesce(b, 1)
130   x2 {EQ(c0,r[2])}
134   SELECT * FROM x1 LEFT JOIN x2 ON (a=x) WHERE 1 = coalesce(b, 1)
136   x2 {EQ(c0,r[2])}
143     SELECT * FROM x1 CROSS JOIN x2 ON (a=x) WHERE 0 = (b IS NOT NULL)
145     x2 {EQ(c0,r[2])}
149     SELECT * FROM x1 LEFT JOIN x2 ON (a=x) WHERE 0 = (b IS NOT +NULL)
151     x2 {EQ(c0,r[2])}
155     SELECT * FROM x1 LEFT JOIN x2 ON (a=x) WHERE b IS NOT +NULL
157     x2 {EQ(c0,r[2])}
161     SELECT * FROM x1 LEFT JOIN x2 ON (a=x)
164     x2 {EQ(c0,r[2])}
168     SELECT * FROM x1 LEFT JOIN x2 ON (a=x) WHERE x2.b = 32+32
170     x2 {AND(EQ(c1,ADD(32,32)),EQ(c0,r[2]))}
176       SELECT * FROM x1 LEFT JOIN x2 ON (a=x) WHERE x2.b LIKE 'abc%'
178       x2 {AND(expr,EQ(c0,r[2]))}
184   SELECT * FROM x1 LEFT JOIN x2 ON (a=x) WHERE coalesce(x2.b, 1)
186   x2 {EQ(c0,r[2])}