Lines Matching refs:t6
285 CREATE TABLE t6(x);
286 INSERT INTO t6 VALUES(1);
287 INSERT INTO t6 VALUES(2);
288 INSERT INTO t6 VALUES(NULL);
289 SELECT coalesce(min(x),-1) FROM t6;
294 SELECT max(x) FROM t6;
299 CREATE INDEX i6 ON t6(x);
300 SELECT coalesce(min(x),-1) FROM t6;
305 SELECT max(x) FROM t6;
310 DELETE FROM t6 WHERE x NOT NULL;
311 SELECT count(*) FROM t6;
316 SELECT count(x) FROM t6;
321 SELECT (SELECT min(x) FROM t6), (SELECT max(x) FROM t6);
326 SELECT min(x), max(x) FROM t6;
331 INSERT INTO t6 SELECT * FROM t6;
332 INSERT INTO t6 SELECT * FROM t6;
333 INSERT INTO t6 SELECT * FROM t6;
334 INSERT INTO t6 SELECT * FROM t6;
335 INSERT INTO t6 SELECT * FROM t6;
336 INSERT INTO t6 SELECT * FROM t6;
337 INSERT INTO t6 SELECT * FROM t6;
338 INSERT INTO t6 SELECT * FROM t6;
339 INSERT INTO t6 SELECT * FROM t6;
340 INSERT INTO t6 SELECT * FROM t6;
341 SELECT count(*) FROM t6;
346 SELECT count(x) FROM t6;
351 SELECT (SELECT min(x) FROM t6), (SELECT max(x) FROM t6);
356 SELECT min(x), max(x) FROM t6;