Lines Matching refs:b

35   CREATE TABLE t2(b INT);
39   SELECT a, b
41   ORDER BY coalesce(a,b,3);
49   SELECT a, b
51   ORDER BY coalesce(a,b,3);
57   SELECT a, b
59   ORDER BY coalesce(a,b,3);
65   SELECT a, b
66   FROM t1 INNER JOIN t2 ON true WHERE b IS NULL
67   ORDER BY coalesce(a,b,3);
73   SELECT a, b
74   FROM t1 INNER JOIN t2 ON b IS NULL
75   ORDER BY coalesce(a,b,3);
81   SELECT a, b
83   ORDER BY coalesce(a,b,3);
91   SELECT a, b
93   ORDER BY coalesce(a,b,3);
99   SELECT a, b
101   ORDER BY coalesce(a,b,3);
108   SELECT a, b
109   FROM t1 LEFT JOIN t2 ON true WHERE b IS NULL
110   ORDER BY coalesce(a,b,3);
116   SELECT a, b
117   FROM t1 LEFT JOIN t2 ON b IS NULL
118   ORDER BY coalesce(a,b,3);
124   SELECT a, b
126   ORDER BY coalesce(a,b,3);
134   SELECT a, b
136   ORDER BY coalesce(a,b,3);
142   SELECT a, b
144   ORDER BY coalesce(a,b,3);
150   SELECT a, b
151   FROM t1 RIGHT JOIN t2 ON true WHERE b IS NULL
152   ORDER BY coalesce(a,b,3);
158   SELECT a, b
159   FROM t1 RIGHT JOIN t2 ON b IS NULL
160   ORDER BY coalesce(a,b,3);
167   SELECT a, b
169   ORDER BY coalesce(a,b,3);
177   SELECT a, b
179   ORDER BY coalesce(a,b,3);
189 #  SELECT a, b
191 #  ORDER BY coalesce(a,b,3);
196   SELECT a, b
197   FROM t1 FULL JOIN t2 ON true WHERE b IS NULL
198   ORDER BY coalesce(a,b,3);
208 #   SELECT a, b
209 #   FROM t1 FULL JOIN t2 ON b IS NULL
210 #   ORDER BY coalesce(a,b,3);
222   SELECT a, b
224   ORDER BY coalesce(a,b,3);
229   SELECT a, b
231   ORDER BY coalesce(a,b,3);
235   SELECT a, b
237   ORDER BY coalesce(a,b,3);
241   SELECT a, b
242   FROM t1 INNER JOIN t2 ON true WHERE b IS NULL
243   ORDER BY coalesce(a,b,3);
248   SELECT a, b
249   FROM t1 INNER JOIN t2 ON b IS NULL
250   ORDER BY coalesce(a,b,3);
255   SELECT a, b
257   ORDER BY coalesce(a,b,3);
262   SELECT a, b
264   ORDER BY coalesce(a,b,3);
268   SELECT a, b
270   ORDER BY coalesce(a,b,3);
275   SELECT a, b
276   FROM t1 LEFT JOIN t2 ON true WHERE b IS NULL
277   ORDER BY coalesce(a,b,3);
282   SELECT a, b
283   FROM t1 LEFT JOIN t2 ON b IS NULL
284   ORDER BY coalesce(a,b,3);
289   SELECT a, b
291   ORDER BY coalesce(a,b,3);
297   SELECT a, b
299   ORDER BY coalesce(a,b,3);
304   SELECT a, b
306   ORDER BY coalesce(a,b,3);
311   SELECT a, b
312   FROM t1 RIGHT JOIN t2 ON true WHERE b IS NULL
313   ORDER BY coalesce(a,b,3);
318   SELECT a, b
319   FROM t1 RIGHT JOIN t2 ON b IS NULL
320   ORDER BY coalesce(a,b,3);
325   SELECT a, b
327   ORDER BY coalesce(a,b,3);
332   SELECT a, b
334   ORDER BY coalesce(a,b,3);
341 #   SELECT a, b
343 #   ORDER BY coalesce(a,b,3);
348   SELECT a, b
349   FROM t1 FULL JOIN t2 ON true WHERE b IS NULL
350   ORDER BY coalesce(a,b,3);
357 #   SELECT a, b
358 #   FROM t1 FULL JOIN t2 ON b IS NULL
359 #   ORDER BY coalesce(a,b,3);
377 # CREATE TABLE t2(b INT);
393 #      {true WHERE b IS NULL}
394 #      {b IS NULL}
400 # append q1 "SELECT a, b\n"
402 # append q1 " ORDER BY coalesce(a,b,3);"
425 #      {true WHERE b IS NULL}
426 #      {b IS NULL}
432 # append q1 "SELECT a, b\n"
434 # append q1 " ORDER BY coalesce(a,b,3);"