mysql-test/r/select_found.result

4 select SQL_CALC_FOUND_ROWS * from t1;
15 Warning	1287	SQL_CALC_FOUND_ROWS is deprecated and will be removed in a future release. Consider us…
21 select SQL_CALC_FOUND_ROWS * from t1 limit 1;
25 Warning	1287	SQL_CALC_FOUND_ROWS is deprecated and will be removed in a future release. Consider us…
31 select SQL_BUFFER_RESULT SQL_CALC_FOUND_ROWS * from t1 limit 1;
35 Warning	1287	SQL_CALC_FOUND_ROWS is deprecated and will be removed in a future release. Consider us…
41 select SQL_CALC_FOUND_ROWS * from t1 order by b desc limit 1;
45 Warning	1287	SQL_CALC_FOUND_ROWS is deprecated and will be removed in a future release. Consider us…
51 select SQL_CALC_FOUND_ROWS distinct b from t1 limit 1;
55 Warning	1287	SQL_CALC_FOUND_ROWS is deprecated and will be removed in a future release. Consider us…
61 select SQL_CALC_FOUND_ROWS b,count(*) as c from t1 group by b order by c desc limit 1;
65 Warning	1287	SQL_CALC_FOUND_ROWS is deprecated and will be removed in a future release. Consider us…
71 select SQL_CALC_FOUND_ROWS * from t1 left join t1 as t2 on (t1.b=t2.a) limit 2,1;
75 Warning	1287	SQL_CALC_FOUND_ROWS is deprecated and will be removed in a future release. Consider us…
81 EXPLAIN FORMAT=tree select SQL_CALC_FOUND_ROWS * from t1 limit 10 offset 100;
83 -> Limit/Offset: 10/100 row(s) (no early end due to SQL_CALC_FOUND_ROWS)
87 Warning	1287	SQL_CALC_FOUND_ROWS is deprecated and will be removed in a future release. Consider us…
88 select SQL_CALC_FOUND_ROWS * from t1 limit 10 offset 100;
91 Warning	1287	SQL_CALC_FOUND_ROWS is deprecated and will be removed in a future release. Consider us…
105 Warning	1287	SQL_CALC_FOUND_ROWS is deprecated and will be removed in a future release. Consider us…
116 Warning	1287	SQL_CALC_FOUND_ROWS is deprecated and will be removed in a future release. Consider us…
141 EXPLAIN SELECT SQL_CALC_FOUND_ROWS DISTINCT email FROM t2 LEFT JOIN t1  ON kid = t2.id WHERE t1.id …
146 Warning	1287	SQL_CALC_FOUND_ROWS is deprecated and will be removed in a future release. Consider us…
149 SELECT SQL_CALC_FOUND_ROWS DISTINCT email FROM t2 LEFT JOIN t1  ON kid = t2.id WHERE t1.id IS NULL …
153 SELECT SQL_CALC_FOUND_ROWS DISTINCT email FROM t2 LEFT JOIN t1  ON kid = t2.id WHERE t1.id IS NULL …
166 Warning	1287	SQL_CALC_FOUND_ROWS is deprecated and will be removed in a future release. Consider us…
172 SELECT SQL_CALC_FOUND_ROWS DISTINCT email FROM t2 LEFT JOIN t1  ON kid = t2.id WHERE t1.id IS NULL …
185 Warning	1287	SQL_CALC_FOUND_ROWS is deprecated and will be removed in a future release. Consider us…
216 SELECT SQL_CALC_FOUND_ROWS DISTINCT email FROM t2 LEFT JOIN t1  ON kid = t2.id WHERE t1.id IS NULL …
229 Warning	1287	SQL_CALC_FOUND_ROWS is deprecated and will be removed in a future release. Consider us…
248 SELECT SQL_CALC_FOUND_ROWS titre,numeropost,maxnumrep FROM t1 WHERE numeropost IN (1,2) ORDER BY ma…
252 Warning	1287	SQL_CALC_FOUND_ROWS is deprecated and will be removed in a future release. Consider us…
258 SELECT SQL_CALC_FOUND_ROWS 1 FROM (SELECT 1) as a LIMIT 0;
261 Warning	1287	SQL_CALC_FOUND_ROWS is deprecated and will be removed in a future release. Consider us…
267 SELECT SQL_CALC_FOUND_ROWS * FROM t1 WHERE numeropost > 1  LIMIT 0;
270 Warning	1287	SQL_CALC_FOUND_ROWS is deprecated and will be removed in a future release. Consider us…
276 SELECT SQL_CALC_FOUND_ROWS * FROM t1 LIMIT 0;
279 Warning	1287	SQL_CALC_FOUND_ROWS is deprecated and will be removed in a future release. Consider us…
285 SELECT SQL_CALC_FOUND_ROWS * FROM t1 ORDER BY numeropost  LIMIT 0;
288 Warning	1287	SQL_CALC_FOUND_ROWS is deprecated and will be removed in a future release. Consider us…
297 select SQL_CALC_FOUND_ROWS * from t1 where id > 3 limit 0, 1;
301 Warning	1287	SQL_CALC_FOUND_ROWS is deprecated and will be removed in a future release. Consider us…
307 select SQL_CALC_FOUND_ROWS * from t1 where id > 3 AND 1=2 limit 0, 1;
310 Warning	1287	SQL_CALC_FOUND_ROWS is deprecated and will be removed in a future release. Consider us…
316 select SQL_CALC_FOUND_ROWS * from t1 where id > 6 limit 0, 1;
319 Warning	1287	SQL_CALC_FOUND_ROWS is deprecated and will be removed in a future release. Consider us…
346 SELECT SQL_CALC_FOUND_ROWS * FROM t1 WHERE a = '2' LIMIT 0, 1;
350 Warning	1287	SQL_CALC_FOUND_ROWS is deprecated and will be removed in a future release. Consider us…
359 SELECT SQL_CALC_FOUND_ROWS * FROM t1 WHERE a = 0 GROUP BY a HAVING a > 10;
362 Warning	1287	SQL_CALC_FOUND_ROWS is deprecated and will be removed in a future release. Consider us…
377 SELECT SQL_CALC_FOUND_ROWS 'foo';
381 Warning	1287	SQL_CALC_FOUND_ROWS is deprecated and will be removed in a future release. Consider us…
387 SELECT SQL_CALC_FOUND_ROWS 'foo' limit 0;
390 Warning	1287	SQL_CALC_FOUND_ROWS is deprecated and will be removed in a future release. Consider us…
401 SELECT SQL_CALC_FOUND_ROWS 'foo' UNION SELECT 'bar' LIMIT 0;
404 Warning	1287	SQL_CALC_FOUND_ROWS is deprecated and will be removed in a future release. Consider us…
412 SELECT SQL_CALC_FOUND_ROWS DISTINCT 'a' FROM t1 GROUP BY b LIMIT 2;
416 Warning	1287	SQL_CALC_FOUND_ROWS is deprecated and will be removed in a future release. Consider us…
429 (SELECT SQL_CALC_FOUND_ROWS * FROM t1 LIMIT 2 OFFSET 2)
436 Warning	1287	SQL_CALC_FOUND_ROWS is deprecated and will be removed in a future release. Consider us…
448 (SELECT SQL_CALC_FOUND_ROWS * FROM t1 WHERE false LIMIT 8, 1)
453 Warning	1287	SQL_CALC_FOUND_ROWS is deprecated and will be removed in a future release. Consider us…