Lines Matching refs:t6
176 CREATE TABLE t6(a);
177 INSERT INTO t6 VALUES(1);
178 INSERT INTO t6 VALUES(2);
179 INSERT INTO t6 SELECT a+2 FROM t6;
181 SELECT * FROM t6;
186 SELECT * FROM t6 LIMIT -1 OFFSET -1;
191 SELECT * FROM t6 LIMIT 2 OFFSET -123;
196 SELECT * FROM t6 LIMIT -432 OFFSET 2;
201 SELECT * FROM t6 LIMIT -1
206 SELECT * FROM t6 LIMIT -1 OFFSET 1
211 SELECT * FROM t6 LIMIT 0
216 SELECT * FROM t6 LIMIT 0 OFFSET 1
225 SELECT x FROM t2 LIMIT 5 UNION ALL SELECT a FROM t6;
230 SELECT x FROM t2 LIMIT 5 UNION SELECT a FROM t6;
235 SELECT x FROM t2 LIMIT 5 EXCEPT SELECT a FROM t6 LIMIT 3;
240 SELECT x FROM t2 LIMIT 0,5 INTERSECT SELECT a FROM t6;
245 SELECT x FROM t2 UNION ALL SELECT a FROM t6 LIMIT 5;
250 SELECT x FROM t2 UNION ALL SELECT a FROM t6 LIMIT 3 OFFSET 1;
255 SELECT x FROM t2 UNION ALL SELECT a FROM t6 ORDER BY 1 LIMIT 3 OFFSET 1;
270 SELECT a+9 FROM t6 EXCEPT SELECT y FROM t2 LIMIT 2;
275 SELECT a+9 FROM t6 EXCEPT SELECT y FROM t2 ORDER BY 1 DESC LIMIT 2;
280 SELECT a+26 FROM t6 INTERSECT SELECT x FROM t2 LIMIT 1;
285 SELECT a+27 FROM t6 INTERSECT SELECT x FROM t2 LIMIT 1;
290 SELECT a+27 FROM t6 INTERSECT SELECT x FROM t2 LIMIT 1 OFFSET 1;
295 SELECT a+27 FROM t6 INTERSECT SELECT x FROM t2