Lines Matching refs:a
4 # a legal notice, here is a blessing:
17 # 1. Run a TCL script (included at the bottom of this file) that
24 # 3. Make a few minor global search-and-replace operations to convert
25 # the psql output into a form suitable for this test module.
33 CREATE TABLE t1(a INT);
39 SELECT a, b
41 ORDER BY coalesce(a,b,3);
49 SELECT a, b
50 FROM t1 INNER JOIN t2 ON true WHERE a IS NULL
51 ORDER BY coalesce(a,b,3);
57 SELECT a, b
58 FROM t1 INNER JOIN t2 ON a IS NULL
59 ORDER BY coalesce(a,b,3);
65 SELECT a, b
67 ORDER BY coalesce(a,b,3);
73 SELECT a, b
75 ORDER BY coalesce(a,b,3);
81 SELECT a, b
83 ORDER BY coalesce(a,b,3);
91 SELECT a, b
92 FROM t1 LEFT JOIN t2 ON true WHERE a IS NULL
93 ORDER BY coalesce(a,b,3);
99 SELECT a, b
100 FROM t1 LEFT JOIN t2 ON a IS NULL
101 ORDER BY coalesce(a,b,3);
108 SELECT a, b
110 ORDER BY coalesce(a,b,3);
116 SELECT a, b
118 ORDER BY coalesce(a,b,3);
124 SELECT a, b
126 ORDER BY coalesce(a,b,3);
134 SELECT a, b
135 FROM t1 RIGHT JOIN t2 ON true WHERE a IS NULL
136 ORDER BY coalesce(a,b,3);
142 SELECT a, b
143 FROM t1 RIGHT JOIN t2 ON a IS NULL
144 ORDER BY coalesce(a,b,3);
150 SELECT a, b
152 ORDER BY coalesce(a,b,3);
158 SELECT a, b
160 ORDER BY coalesce(a,b,3);
167 SELECT a, b
169 ORDER BY coalesce(a,b,3);
177 SELECT a, b
178 FROM t1 FULL JOIN t2 ON true WHERE a IS NULL
179 ORDER BY coalesce(a,b,3);
189 # SELECT a, b
190 # FROM t1 FULL JOIN t2 ON a IS NULL
191 # ORDER BY coalesce(a,b,3);
196 SELECT a, b
198 ORDER BY coalesce(a,b,3);
208 # SELECT a, b
210 # ORDER BY coalesce(a,b,3);
222 SELECT a, b
224 ORDER BY coalesce(a,b,3);
229 SELECT a, b
230 FROM t1 INNER JOIN t2 ON true WHERE a IS NULL
231 ORDER BY coalesce(a,b,3);
235 SELECT a, b
236 FROM t1 INNER JOIN t2 ON a IS NULL
237 ORDER BY coalesce(a,b,3);
241 SELECT a, b
243 ORDER BY coalesce(a,b,3);
248 SELECT a, b
250 ORDER BY coalesce(a,b,3);
255 SELECT a, b
257 ORDER BY coalesce(a,b,3);
262 SELECT a, b
263 FROM t1 LEFT JOIN t2 ON true WHERE a IS NULL
264 ORDER BY coalesce(a,b,3);
268 SELECT a, b
269 FROM t1 LEFT JOIN t2 ON a IS NULL
270 ORDER BY coalesce(a,b,3);
275 SELECT a, b
277 ORDER BY coalesce(a,b,3);
282 SELECT a, b
284 ORDER BY coalesce(a,b,3);
289 SELECT a, b
291 ORDER BY coalesce(a,b,3);
297 SELECT a, b
298 FROM t1 RIGHT JOIN t2 ON true WHERE a IS NULL
299 ORDER BY coalesce(a,b,3);
304 SELECT a, b
305 FROM t1 RIGHT JOIN t2 ON a IS NULL
306 ORDER BY coalesce(a,b,3);
311 SELECT a, b
313 ORDER BY coalesce(a,b,3);
318 SELECT a, b
320 ORDER BY coalesce(a,b,3);
325 SELECT a, b
327 ORDER BY coalesce(a,b,3);
332 SELECT a, b
333 FROM t1 FULL JOIN t2 ON true WHERE a IS NULL
334 ORDER BY coalesce(a,b,3);
341 # SELECT a, b
342 # FROM t1 FULL JOIN t2 ON a IS NULL
343 # ORDER BY coalesce(a,b,3);
348 SELECT a, b
350 ORDER BY coalesce(a,b,3);
357 # SELECT a, b
359 # ORDER BY coalesce(a,b,3);
375 # CREATE TABLE t1(a INT);
391 # {true WHERE a IS NULL}
392 # {a IS NULL}
400 # append q1 "SELECT a, b\n"
402 # append q1 " ORDER BY coalesce(a,b,3);"
423 # {true WHERE a IS NULL}
424 # {a IS NULL}
432 # append q1 "SELECT a, b\n"
434 # append q1 " ORDER BY coalesce(a,b,3);"