Lines Matching refs:t6
287 CREATE TABLE t6(x);
288 INSERT INTO t6 VALUES(1);
289 INSERT INTO t6 VALUES(2);
290 INSERT INTO t6 VALUES(NULL);
291 SELECT coalesce(min(x),-1) FROM t6;
296 SELECT max(x) FROM t6;
301 CREATE INDEX i6 ON t6(x);
302 SELECT coalesce(min(x),-1) FROM t6;
307 SELECT max(x) FROM t6;
312 DELETE FROM t6 WHERE x NOT NULL;
313 SELECT count(*) FROM t6;
318 SELECT count(x) FROM t6;
323 SELECT (SELECT min(x) FROM t6), (SELECT max(x) FROM t6);
328 SELECT min(x), max(x) 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 INSERT INTO t6 SELECT * FROM t6;
342 INSERT INTO t6 SELECT * FROM t6;
343 SELECT count(*) FROM t6;
348 SELECT count(x) FROM t6;
353 SELECT (SELECT min(x) FROM t6), (SELECT max(x) FROM t6);
358 SELECT min(x), max(x) FROM t6;