Lines Matching refs:t3
27 puts $fd "1\tone\t0\tI\t3.141592653"
34 puts $fd "8\teight\t3\tVIII\t-1.6"
577 CREATE TABLE t3(a,b,c);
578 CREATE INDEX t3a ON t3(a);
579 CREATE INDEX t3bc ON t3(b,c);
580 CREATE INDEX t3acb ON t3(a,c,b);
581 INSERT INTO t3 SELECT w, 101-w, y FROM t1;
582 SELECT count(*), sum(a), sum(b), sum(c) FROM t3;
587 SELECT * FROM t3 ORDER BY a LIMIT 3
592 SELECT * FROM t3 ORDER BY a+1 LIMIT 3
597 SELECT * FROM t3 WHERE a<10 ORDER BY a LIMIT 3
602 SELECT * FROM t3 WHERE a>0 AND a<10 ORDER BY a LIMIT 3
607 SELECT * FROM t3 WHERE a>0 ORDER BY a LIMIT 3
612 SELECT * FROM t3 WHERE b>0 ORDER BY a LIMIT 3
617 SELECT * FROM t3 WHERE a IN (3,5,7,1,9,4,2) ORDER BY a LIMIT 3
622 SELECT * FROM t3 WHERE a=1 AND c>0 ORDER BY a LIMIT 3
627 SELECT * FROM t3 WHERE a=1 AND c>0 ORDER BY a LIMIT 3
632 SELECT * FROM t3 WHERE a=1 AND c>0 ORDER BY a,c LIMIT 3
637 SELECT * FROM t3 WHERE a=1 AND c>0 ORDER BY a,c,b LIMIT 3
642 SELECT * FROM t3 WHERE a>0 ORDER BY a DESC LIMIT 3
647 SELECT * FROM t3 WHERE a>0 ORDER BY a+1 DESC LIMIT 3
652 SELECT * FROM t3 ORDER BY b LIMIT 3
657 SELECT t3.a, t1.x FROM t3, t1 WHERE t3.a=t1.w ORDER BY t3.a LIMIT 3
662 SELECT t3.a, t1.x FROM t3, t1 WHERE t3.a=t1.w ORDER BY t1.x, t3.a LIMIT 3