Lines Matching refs:t3
376 CREATE TABLE t3(a,b,c);
377 CREATE INDEX t3a ON t3(a);
378 CREATE INDEX t3bc ON t3(b,c);
379 CREATE INDEX t3acb ON t3(a,c,b);
380 INSERT INTO t3 SELECT w, 101-w, y FROM t1;
381 SELECT count(*), sum(a), sum(b), sum(c) FROM t3;
386 SELECT * FROM t3 ORDER BY a LIMIT 3
391 SELECT * FROM t3 ORDER BY a+1 LIMIT 3
396 SELECT * FROM t3 WHERE a<10 ORDER BY a LIMIT 3
401 SELECT * FROM t3 WHERE a>0 AND a<10 ORDER BY a LIMIT 3
406 SELECT * FROM t3 WHERE a>0 ORDER BY a LIMIT 3
411 SELECT * FROM t3 WHERE b>0 ORDER BY a LIMIT 3
416 SELECT * FROM t3 WHERE a IN (3,5,7,1,9,4,2) ORDER BY a LIMIT 3
421 SELECT * FROM t3 WHERE a=1 AND c>0 ORDER BY a LIMIT 3
426 SELECT * FROM t3 WHERE a=1 AND c>0 ORDER BY a,c LIMIT 3
431 SELECT * FROM t3 WHERE a=1 AND c>0 ORDER BY c LIMIT 3
436 SELECT * FROM t3 WHERE a=1 AND c>0 ORDER BY a DESC LIMIT 3
441 SELECT * FROM t3 WHERE a=1 AND c>0 ORDER BY a DESC, c DESC LIMIT 3
446 SELECT * FROM t3 WHERE a=1 AND c>0 ORDER BY c DESC LIMIT 3
451 SELECT * FROM t3 WHERE a=1 AND c>0 ORDER BY c,a LIMIT 3
456 SELECT * FROM t3 WHERE a=1 AND c>0 ORDER BY a DESC, c ASC LIMIT 3
461 SELECT * FROM t3 WHERE a=1 AND c>0 ORDER BY a ASC, c DESC LIMIT 3
466 SELECT * FROM t3 WHERE a=1 AND c>0 ORDER BY a LIMIT 3
471 SELECT * FROM t3 WHERE a=1 AND c>0 ORDER BY a,c LIMIT 3
476 SELECT * FROM t3 WHERE a=1 AND c>0 ORDER BY a,c,b LIMIT 3
481 SELECT * FROM t3 WHERE a>0 ORDER BY a DESC LIMIT 3
486 SELECT * FROM t3 WHERE a>0 ORDER BY -a LIMIT 3
491 SELECT * FROM t3 ORDER BY b LIMIT 3
496 SELECT t3.a, t1.x FROM t3, t1 WHERE t3.a=t1.w ORDER BY t3.a LIMIT 3
501 SELECT t3.a, t1.x FROM t3, t1 WHERE t3.a=t1.w ORDER BY t1.x, t3.a LIMIT 3