Lines Matching refs:t2
47 CREATE TABLE t2(d, e, f);
53 INSERT INTO t2 VALUES(3, 6, 9);
54 INSERT INTO t2 VALUES(12, 15, 18);
55 INSERT INTO t2 VALUES(21, 24, 27);
65 CREATE INDEX i2 ON t2(d);
71 SELECT * FROM (SELECT a FROM t1 UNION ALL SELECT d FROM t2)
73 SELECT a FROM t1 UNION ALL SELECT d FROM t2
77 SELECT * FROM (SELECT a FROM t1 UNION ALL SELECT d FROM t2) ORDER BY 1
79 SELECT a FROM t1 UNION ALL SELECT d FROM t2 ORDER BY 1
84 (SELECT a FROM t1 UNION ALL SELECT d FROM t2)
87 SELECT a FROM t1 WHERE a>10 UNION ALL SELECT d FROM t2 WHERE d>10 ORDER BY 1
92 (SELECT a FROM t1 UNION ALL SELECT d FROM t2)
97 SELECT d FROM t2 WHERE d>10
103 (SELECT a FROM t1 UNION ALL SELECT d FROM t2 WHERE d > 12)
108 SELECT d FROM t2 WHERE d>12 AND d>10
113 SELECT * FROM (SELECT a FROM t1 UNION ALL SELECT d FROM t2) ORDER BY 1
116 SELECT a FROM t1 UNION ALL SELECT d FROM t2 ORDER BY 1 LIMIT 2
120 SELECT * FROM (SELECT a FROM t1 UNION ALL SELECT d FROM t2) ORDER BY 1
123 SELECT a FROM t1 UNION ALL SELECT d FROM t2 ORDER BY 1 LIMIT 2 OFFSET 3
128 SELECT a FROM t1 UNION ALL SELECT d FROM t2 UNION ALL SELECT c FROM t1
131 SELECT a FROM t1 UNION ALL SELECT d FROM t2 UNION ALL SELECT c FROM t1
136 SELECT a FROM t1 UNION ALL SELECT d FROM t2 UNION ALL SELECT c FROM t1
139 SELECT a FROM t1 UNION ALL SELECT d FROM t2 UNION ALL SELECT c FROM t1
145 SELECT a FROM t1 UNION ALL SELECT d FROM t2 UNION ALL SELECT c FROM t1
148 SELECT a FROM t1 WHERE a>=10 UNION ALL SELECT d FROM t2 WHERE d>=10
154 SELECT * FROM (SELECT a FROM t1 UNION ALL SELECT d FROM t2 LIMIT 2)
156 SELECT a FROM t1 UNION ALL SELECT d FROM t2 LIMIT 2
161 # SELECT * FROM (SELECT a FROM t1 UNION ALL SELECT d FROM t2 ORDER BY a ASC)
163 # SELECT a FROM t1 UNION ALL SELECT d FROM t2 ORDER BY 1 ASC
167 # SELECT * FROM (SELECT a FROM t1 UNION ALL SELECT d FROM t2 ORDER BY a DESC)
169 # SELECT a FROM t1 UNION ALL SELECT d FROM t2 ORDER BY 1 DESC
174 # SELECT a FROM t1 UNION ALL SELECT d FROM t2 ORDER BY a DESC
177 # SELECT a FROM t1 UNION ALL SELECT d FROM t2 ORDER BY 1 DESC
183 # SELECT a, b FROM t1 UNION ALL SELECT d, e FROM t2 ORDER BY a ASC, e DESC
186 # SELECT a, b FROM t1 UNION ALL SELECT d, e FROM t2 ORDER BY a ASC, e DESC
210 CREATE INDEX i4 ON t2(d);
211 CREATE INDEX i5 ON t2(e);
212 CREATE INDEX i6 ON t2(f);
224 (SELECT c FROM t1 UNION ALL SELECT e FROM t2)
232 (SELECT c FROM t1 UNION ALL SELECT e FROM t2)
239 (SELECT c FROM t1 UNION ALL SELECT e FROM t2)
246 (SELECT c FROM t1 UNION ALL SELECT e FROM t2) AS t4, t1 AS t3
254 SELECT d FROM t2
256 SELECT a FROM (SELECT a FROM t1 UNION ALL SELECT d FROM t2)
261 SELECT * FROM (SELECT a FROM t1 UNION ALL SELECT d FROM t2)
263 SELECT * FROM (SELECT a FROM t1 UNION ALL SELECT d FROM t2)
270 SELECT * FROM (SELECT e FROM t2 UNION ALL SELECT f FROM t2)
275 SELECT * FROM (SELECT e FROM t2 UNION ALL SELECT f FROM t2)
282 SELECT * FROM (SELECT e FROM t2 UNION ALL SELECT f FROM t2)
291 SELECT * FROM (SELECT e FROM t2 UNION ALL SELECT f FROM t2)
301 SELECT * FROM (SELECT e FROM t2 UNION ALL SELECT f FROM t2)
307 SELECT c FROM t1 UNION SELECT e FROM t2 UNION ALL SELECT f FROM t2
313 SELECT * FROM (SELECT e FROM t2 UNION ALL SELECT f FROM t2)
315 SELECT * FROM (SELECT e FROM t2 UNION ALL SELECT f FROM t2)
324 SELECT * FROM (SELECT e FROM t2 UNION ALL SELECT f FROM t2)
330 SELECT * FROM (SELECT e FROM t2 UNION ALL SELECT f FROM t2)
338 SELECT * FROM (SELECT e FROM t2 UNION ALL SELECT f FROM t2)
340 SELECT * FROM (SELECT e FROM t2 UNION ALL SELECT f FROM t2)
348 SELECT a FROM t1 UNION ALL SELECT d FROM t2 LIMIT 4
356 SELECT a FROM t1 UNION ALL SELECT d FROM t2 LIMIT 4 OFFSET 2
364 SELECT DISTINCT (a/10) FROM t1 UNION ALL SELECT DISTINCT(d%2) FROM t2
372 SELECT DISTINCT (a/10) FROM t1 UNION ALL SELECT DISTINCT(d%2) FROM t2
379 SELECT * FROM (SELECT * FROM t1 UNION ALL SELECT * FROM t2) ORDER BY a+b
385 SELECT * FROM (SELECT 345 UNION ALL SELECT d FROM t2) ORDER BY 1;
394 SELECT a*10 + 0.1, f*10 + 0.1 FROM t1 JOIN t2 ON (c=d)
406 SELECT a*10 + 0.1, f*10 + 0.1 FROM t1 LEFT JOIN t2 ON (c=d)
418 SELECT a*10 + 0.1, f*10 + 0.1 FROM t1 LEFT JOIN t2 ON (c=d)