Lines Matching refs:t6
174 CREATE TABLE t6(a);
175 INSERT INTO t6 VALUES(1);
176 INSERT INTO t6 VALUES(2);
177 INSERT INTO t6 SELECT a+2 FROM t6;
179 SELECT * FROM t6;
184 SELECT * FROM t6 LIMIT -1 OFFSET -1;
189 SELECT * FROM t6 LIMIT 2 OFFSET -123;
194 SELECT * FROM t6 LIMIT -432 OFFSET 2;
199 SELECT * FROM t6 LIMIT -1
204 SELECT * FROM t6 LIMIT -1 OFFSET 1
209 SELECT * FROM t6 LIMIT 0
214 SELECT * FROM t6 LIMIT 0 OFFSET 1
223 SELECT x FROM t2 LIMIT 5 UNION ALL SELECT a FROM t6;
228 SELECT x FROM t2 LIMIT 5 UNION SELECT a FROM t6;
233 SELECT x FROM t2 LIMIT 5 EXCEPT SELECT a FROM t6 LIMIT 3;
238 SELECT x FROM t2 LIMIT 0,5 INTERSECT SELECT a FROM t6;
243 SELECT x FROM t2 UNION ALL SELECT a FROM t6 LIMIT 5;
248 SELECT x FROM t2 UNION ALL SELECT a FROM t6 LIMIT 3 OFFSET 1;
253 SELECT x FROM t2 UNION ALL SELECT a FROM t6 ORDER BY 1 LIMIT 3 OFFSET 1;
268 SELECT a+9 FROM t6 EXCEPT SELECT y FROM t2 LIMIT 2;
273 SELECT a+9 FROM t6 EXCEPT SELECT y FROM t2 ORDER BY 1 DESC LIMIT 2;
278 SELECT a+26 FROM t6 INTERSECT SELECT x FROM t2 LIMIT 1;
283 SELECT a+27 FROM t6 INTERSECT SELECT x FROM t2 LIMIT 1;
288 SELECT a+27 FROM t6 INTERSECT SELECT x FROM t2 LIMIT 1 OFFSET 1;
293 SELECT a+27 FROM t6 INTERSECT SELECT x FROM t2