mysql-test/t/select_found.test

10 select SQL_CALC_FOUND_ROWS * from t1;
12 select SQL_CALC_FOUND_ROWS * from t1 limit 1;
14 select SQL_BUFFER_RESULT SQL_CALC_FOUND_ROWS * from t1 limit 1;
16 select SQL_CALC_FOUND_ROWS * from t1 order by b desc limit 1;
18 select SQL_CALC_FOUND_ROWS distinct b from t1 limit 1;
20 select SQL_CALC_FOUND_ROWS b,count(*) as c from t1 group by b order by c desc limit 1;
22 select SQL_CALC_FOUND_ROWS * from t1 left join t1 as t2 on (t1.b=t2.a) limit 2,1;
27 # Test SQL_CALC_FOUND_ROWS optimization when used with one table and filesort
39 # Test of SQL_CALC_FOUND_ROWS with DISTINCT
68 --let $query=SELECT SQL_CALC_FOUND_ROWS DISTINCT email FROM t2 LEFT JOIN t1  ON kid = t2.id WHERE t…
78 SELECT SQL_CALC_FOUND_ROWS DISTINCT email FROM t2 LEFT JOIN t1  ON kid = t2.id WHERE t1.id IS NULL …
85 SELECT SQL_CALC_FOUND_ROWS DISTINCT email FROM t2 LEFT JOIN t1  ON kid = t2.id WHERE t1.id IS NULL …
103 SELECT SQL_CALC_FOUND_ROWS titre,numeropost,maxnumrep FROM t1 WHERE numeropost IN (1,2) ORDER BY ma…
105 SELECT SQL_CALC_FOUND_ROWS 1 FROM (SELECT 1) as a LIMIT 0;
107 SELECT SQL_CALC_FOUND_ROWS * FROM t1 WHERE numeropost > 1  LIMIT 0;
109 SELECT SQL_CALC_FOUND_ROWS * FROM t1 LIMIT 0;
111 SELECT SQL_CALC_FOUND_ROWS * FROM t1 ORDER BY numeropost  LIMIT 0;
121 select SQL_CALC_FOUND_ROWS * from t1 where id > 3 limit 0, 1;
123 select SQL_CALC_FOUND_ROWS * from t1 where id > 3 AND 1=2 limit 0, 1;
125 select SQL_CALC_FOUND_ROWS * from t1 where id > 6 limit 0, 1;
162 SELECT SQL_CALC_FOUND_ROWS * FROM t1 WHERE a = '2' LIMIT 0, 1;
172 SELECT SQL_CALC_FOUND_ROWS * FROM t1 WHERE a = 0 GROUP BY a HAVING a > 10;
182 SELECT SQL_CALC_FOUND_ROWS 'foo';
184 SELECT SQL_CALC_FOUND_ROWS 'foo' limit 0;
188 SELECT SQL_CALC_FOUND_ROWS 'foo' UNION SELECT 'bar' LIMIT 0;
197 SELECT SQL_CALC_FOUND_ROWS DISTINCT 'a' FROM t1 GROUP BY b LIMIT 2;