Lines Matching refs:t3
378 CREATE TABLE t3(a,b,c);
379 CREATE INDEX t3a ON t3(a);
380 CREATE INDEX t3bc ON t3(b,c);
381 CREATE INDEX t3acb ON t3(a,c,b);
382 INSERT INTO t3 SELECT w, 101-w, y FROM t1;
383 SELECT count(*), sum(a), sum(b), sum(c) FROM t3;
388 SELECT * FROM t3 ORDER BY a LIMIT 3
393 SELECT * FROM t3 ORDER BY a+1 LIMIT 3
398 SELECT * FROM t3 WHERE a<10 ORDER BY a LIMIT 3
403 SELECT * FROM t3 WHERE a>0 AND a<10 ORDER BY a LIMIT 3
408 SELECT * FROM t3 WHERE a>0 ORDER BY a LIMIT 3
413 SELECT * FROM t3 WHERE b>0 ORDER BY a LIMIT 3
418 SELECT * FROM t3 WHERE a IN (3,5,7,1,9,4,2) ORDER BY a LIMIT 3
423 SELECT * FROM t3 WHERE a=1 AND c>0 ORDER BY a LIMIT 3
428 SELECT * FROM t3 WHERE a=1 AND c>0 ORDER BY a,c LIMIT 3
433 SELECT * FROM t3 WHERE a=1 AND c>0 ORDER BY c LIMIT 3
438 SELECT * FROM t3 WHERE a=1 AND c>0 ORDER BY a DESC LIMIT 3
443 SELECT * FROM t3 WHERE a=1 AND c>0 ORDER BY a DESC, c DESC LIMIT 3
448 SELECT * FROM t3 WHERE a=1 AND c>0 ORDER BY c DESC LIMIT 3
453 SELECT * FROM t3 WHERE a=1 AND c>0 ORDER BY c,a LIMIT 3
458 SELECT * FROM t3 WHERE a=1 AND c>0 ORDER BY a DESC, c ASC LIMIT 3
463 SELECT * FROM t3 WHERE a=1 AND c>0 ORDER BY a ASC, c DESC LIMIT 3
468 SELECT * FROM t3 WHERE a=1 AND c>0 ORDER BY a LIMIT 3
473 SELECT * FROM t3 WHERE a=1 AND c>0 ORDER BY a,c LIMIT 3
478 SELECT * FROM t3 WHERE a=1 AND c>0 ORDER BY a,c,b LIMIT 3
483 SELECT * FROM t3 WHERE a>0 ORDER BY a DESC LIMIT 3
488 SELECT * FROM t3 WHERE a>0 ORDER BY -a LIMIT 3
493 SELECT * FROM t3 ORDER BY b LIMIT 3
498 SELECT t3.a, t1.x FROM t3, t1 WHERE t3.a=t1.w ORDER BY t3.a LIMIT 3
503 SELECT t3.a, t1.x FROM t3, t1 WHERE t3.a=t1.w ORDER BY t1.x, t3.a LIMIT 3