| /dports/databases/xtrabackup8/percona-xtrabackup-8.0.14/mysql-test/t/ |
| H A D | select_found.test | 16 select SQL_CALC_FOUND_ROWS * from t1;
18 select SQL_CALC_FOUND_ROWS * from t1 limit 1;
22 select SQL_CALC_FOUND_ROWS * from t1 order by b desc limit 1;
24 select SQL_CALC_FOUND_ROWS distinct b from t1 limit 1;
30 # Demonstrate printing of SQL_CALC_FOUND_ROWS in EXPLAIN.
32 select SQL_CALC_FOUND_ROWS * from t1 limit 10 offset 100;
49 # Test of SQL_CALC_FOUND_ROWS with DISTINCT
119 SELECT SQL_CALC_FOUND_ROWS * FROM t1 LIMIT 0;
192 SELECT SQL_CALC_FOUND_ROWS 'foo';
194 SELECT SQL_CALC_FOUND_ROWS 'foo' limit 0;
[all …]
|
| /dports/databases/mysql55-client/mysql-5.5.62/mysql-test/t/ |
| H A D | 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;
39 # Test of SQL_CALC_FOUND_ROWS with DISTINCT
99 SELECT SQL_CALC_FOUND_ROWS 1 FROM (SELECT 1) as a LIMIT 0;
103 SELECT SQL_CALC_FOUND_ROWS * FROM t1 LIMIT 0;
176 SELECT SQL_CALC_FOUND_ROWS 'foo';
178 SELECT SQL_CALC_FOUND_ROWS 'foo' limit 0;
[all …]
|
| /dports/databases/xtrabackup8/percona-xtrabackup-8.0.14/mysql-test/r/ |
| H A D | select_found.result | 4 select SQL_CALC_FOUND_ROWS * from t1;
21 select SQL_CALC_FOUND_ROWS * from t1 limit 1;
31 select SQL_BUFFER_RESULT SQL_CALC_FOUND_ROWS * from t1 limit 1;
41 select SQL_CALC_FOUND_ROWS * from t1 order by b desc limit 1;
51 select SQL_CALC_FOUND_ROWS distinct b from t1 limit 1;
88 select SQL_CALC_FOUND_ROWS * from t1 limit 10 offset 100;
258 SELECT SQL_CALC_FOUND_ROWS 1 FROM (SELECT 1) as a LIMIT 0;
276 SELECT SQL_CALC_FOUND_ROWS * FROM t1 LIMIT 0;
377 SELECT SQL_CALC_FOUND_ROWS 'foo';
387 SELECT SQL_CALC_FOUND_ROWS 'foo' limit 0;
[all …]
|
| /dports/databases/percona56-server/percona-server-5.6.51-91.0/mysql-test/t/ |
| H A D | 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;
39 # Test of SQL_CALC_FOUND_ROWS with DISTINCT
105 SELECT SQL_CALC_FOUND_ROWS 1 FROM (SELECT 1) as a LIMIT 0;
109 SELECT SQL_CALC_FOUND_ROWS * FROM t1 LIMIT 0;
182 SELECT SQL_CALC_FOUND_ROWS 'foo';
184 SELECT SQL_CALC_FOUND_ROWS 'foo' limit 0;
[all …]
|
| /dports/databases/percona56-client/percona-server-5.6.51-91.0/mysql-test/t/ |
| H A D | 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;
39 # Test of SQL_CALC_FOUND_ROWS with DISTINCT
105 SELECT SQL_CALC_FOUND_ROWS 1 FROM (SELECT 1) as a LIMIT 0;
109 SELECT SQL_CALC_FOUND_ROWS * FROM t1 LIMIT 0;
182 SELECT SQL_CALC_FOUND_ROWS 'foo';
184 SELECT SQL_CALC_FOUND_ROWS 'foo' limit 0;
[all …]
|
| /dports/databases/percona-pam-for-mysql/percona-server-5.6.51-91.0/mysql-test/t/ |
| H A D | 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;
39 # Test of SQL_CALC_FOUND_ROWS with DISTINCT
105 SELECT SQL_CALC_FOUND_ROWS 1 FROM (SELECT 1) as a LIMIT 0;
109 SELECT SQL_CALC_FOUND_ROWS * FROM t1 LIMIT 0;
182 SELECT SQL_CALC_FOUND_ROWS 'foo';
184 SELECT SQL_CALC_FOUND_ROWS 'foo' limit 0;
[all …]
|
| /dports/databases/mysqlwsrep56-server/mysql-wsrep-wsrep_5.6.51-25.33/mysql-test/t/ |
| H A D | 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;
39 # Test of SQL_CALC_FOUND_ROWS with DISTINCT
105 SELECT SQL_CALC_FOUND_ROWS 1 FROM (SELECT 1) as a LIMIT 0;
109 SELECT SQL_CALC_FOUND_ROWS * FROM t1 LIMIT 0;
182 SELECT SQL_CALC_FOUND_ROWS 'foo';
184 SELECT SQL_CALC_FOUND_ROWS 'foo' limit 0;
[all …]
|
| /dports/databases/mysql56-client/mysql-5.6.51/mysql-test/t/ |
| H A D | 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;
39 # Test of SQL_CALC_FOUND_ROWS with DISTINCT
105 SELECT SQL_CALC_FOUND_ROWS 1 FROM (SELECT 1) as a LIMIT 0;
109 SELECT SQL_CALC_FOUND_ROWS * FROM t1 LIMIT 0;
182 SELECT SQL_CALC_FOUND_ROWS 'foo';
184 SELECT SQL_CALC_FOUND_ROWS 'foo' limit 0;
[all …]
|
| /dports/databases/xtrabackup/percona-xtrabackup-2.4.21/mysql-test/t/ |
| H A D | select_found.test | 15 select SQL_CALC_FOUND_ROWS * from t1;
17 select SQL_CALC_FOUND_ROWS * from t1 limit 1;
19 select SQL_BUFFER_RESULT SQL_CALC_FOUND_ROWS * from t1 limit 1;
21 select SQL_CALC_FOUND_ROWS * from t1 order by b desc limit 1;
23 select SQL_CALC_FOUND_ROWS distinct b from t1 limit 1;
44 # Test of SQL_CALC_FOUND_ROWS with DISTINCT
110 SELECT SQL_CALC_FOUND_ROWS 1 FROM (SELECT 1) as a LIMIT 0;
114 SELECT SQL_CALC_FOUND_ROWS * FROM t1 LIMIT 0;
187 SELECT SQL_CALC_FOUND_ROWS 'foo';
189 SELECT SQL_CALC_FOUND_ROWS 'foo' limit 0;
[all …]
|
| /dports/databases/percona57-server/percona-server-5.7.36-39/mysql-test/t/ |
| H A D | select_found.test | 15 select SQL_CALC_FOUND_ROWS * from t1;
17 select SQL_CALC_FOUND_ROWS * from t1 limit 1;
19 select SQL_BUFFER_RESULT SQL_CALC_FOUND_ROWS * from t1 limit 1;
21 select SQL_CALC_FOUND_ROWS * from t1 order by b desc limit 1;
23 select SQL_CALC_FOUND_ROWS distinct b from t1 limit 1;
44 # Test of SQL_CALC_FOUND_ROWS with DISTINCT
110 SELECT SQL_CALC_FOUND_ROWS 1 FROM (SELECT 1) as a LIMIT 0;
114 SELECT SQL_CALC_FOUND_ROWS * FROM t1 LIMIT 0;
187 SELECT SQL_CALC_FOUND_ROWS 'foo';
189 SELECT SQL_CALC_FOUND_ROWS 'foo' limit 0;
[all …]
|
| /dports/databases/percona57-pam-for-mysql/percona-server-5.7.36-39/mysql-test/t/ |
| H A D | select_found.test | 15 select SQL_CALC_FOUND_ROWS * from t1;
17 select SQL_CALC_FOUND_ROWS * from t1 limit 1;
19 select SQL_BUFFER_RESULT SQL_CALC_FOUND_ROWS * from t1 limit 1;
21 select SQL_CALC_FOUND_ROWS * from t1 order by b desc limit 1;
23 select SQL_CALC_FOUND_ROWS distinct b from t1 limit 1;
44 # Test of SQL_CALC_FOUND_ROWS with DISTINCT
110 SELECT SQL_CALC_FOUND_ROWS 1 FROM (SELECT 1) as a LIMIT 0;
114 SELECT SQL_CALC_FOUND_ROWS * FROM t1 LIMIT 0;
187 SELECT SQL_CALC_FOUND_ROWS 'foo';
189 SELECT SQL_CALC_FOUND_ROWS 'foo' limit 0;
[all …]
|
| /dports/databases/percona57-client/percona-server-5.7.36-39/mysql-test/t/ |
| H A D | select_found.test | 15 select SQL_CALC_FOUND_ROWS * from t1;
17 select SQL_CALC_FOUND_ROWS * from t1 limit 1;
19 select SQL_BUFFER_RESULT SQL_CALC_FOUND_ROWS * from t1 limit 1;
21 select SQL_CALC_FOUND_ROWS * from t1 order by b desc limit 1;
23 select SQL_CALC_FOUND_ROWS distinct b from t1 limit 1;
44 # Test of SQL_CALC_FOUND_ROWS with DISTINCT
110 SELECT SQL_CALC_FOUND_ROWS 1 FROM (SELECT 1) as a LIMIT 0;
114 SELECT SQL_CALC_FOUND_ROWS * FROM t1 LIMIT 0;
187 SELECT SQL_CALC_FOUND_ROWS 'foo';
189 SELECT SQL_CALC_FOUND_ROWS 'foo' limit 0;
[all …]
|
| /dports/databases/mysqlwsrep57-server/mysql-wsrep-wsrep_5.7.35-25.27/mysql-test/t/ |
| H A D | select_found.test | 15 select SQL_CALC_FOUND_ROWS * from t1;
17 select SQL_CALC_FOUND_ROWS * from t1 limit 1;
19 select SQL_BUFFER_RESULT SQL_CALC_FOUND_ROWS * from t1 limit 1;
21 select SQL_CALC_FOUND_ROWS * from t1 order by b desc limit 1;
23 select SQL_CALC_FOUND_ROWS distinct b from t1 limit 1;
44 # Test of SQL_CALC_FOUND_ROWS with DISTINCT
110 SELECT SQL_CALC_FOUND_ROWS 1 FROM (SELECT 1) as a LIMIT 0;
114 SELECT SQL_CALC_FOUND_ROWS * FROM t1 LIMIT 0;
187 SELECT SQL_CALC_FOUND_ROWS 'foo';
189 SELECT SQL_CALC_FOUND_ROWS 'foo' limit 0;
[all …]
|
| /dports/databases/mysql57-client/mysql-5.7.36/mysql-test/t/ |
| H A D | select_found.test | 15 select SQL_CALC_FOUND_ROWS * from t1;
17 select SQL_CALC_FOUND_ROWS * from t1 limit 1;
19 select SQL_BUFFER_RESULT SQL_CALC_FOUND_ROWS * from t1 limit 1;
21 select SQL_CALC_FOUND_ROWS * from t1 order by b desc limit 1;
23 select SQL_CALC_FOUND_ROWS distinct b from t1 limit 1;
44 # Test of SQL_CALC_FOUND_ROWS with DISTINCT
110 SELECT SQL_CALC_FOUND_ROWS 1 FROM (SELECT 1) as a LIMIT 0;
114 SELECT SQL_CALC_FOUND_ROWS * FROM t1 LIMIT 0;
187 SELECT SQL_CALC_FOUND_ROWS 'foo';
189 SELECT SQL_CALC_FOUND_ROWS 'foo' limit 0;
[all …]
|
| /dports/databases/mysql55-client/mysql-5.5.62/mysql-test/r/ |
| H A D | select_found.result | 4 select SQL_CALC_FOUND_ROWS * from t1;
17 select SQL_CALC_FOUND_ROWS * from t1 limit 1;
23 select SQL_BUFFER_RESULT SQL_CALC_FOUND_ROWS * from t1 limit 1;
29 select SQL_CALC_FOUND_ROWS * from t1 order by b desc limit 1;
35 select SQL_CALC_FOUND_ROWS distinct b from t1 limit 1;
174 SELECT SQL_CALC_FOUND_ROWS 1 FROM (SELECT 1) as a LIMIT 0;
184 SELECT SQL_CALC_FOUND_ROWS * FROM t1 LIMIT 0;
197 select SQL_CALC_FOUND_ROWS * from t1 where id > 3 limit 0, 1;
255 SELECT SQL_CALC_FOUND_ROWS 'foo';
261 SELECT SQL_CALC_FOUND_ROWS 'foo' limit 0;
[all …]
|
| /dports/databases/percona57-pam-for-mysql/percona-server-5.7.36-39/mysql-test/r/ |
| H A D | select_found.result | 4 select SQL_CALC_FOUND_ROWS * from t1;
17 select SQL_CALC_FOUND_ROWS * from t1 limit 1;
23 select SQL_BUFFER_RESULT SQL_CALC_FOUND_ROWS * from t1 limit 1;
29 select SQL_CALC_FOUND_ROWS * from t1 order by b desc limit 1;
35 select SQL_CALC_FOUND_ROWS distinct b from t1 limit 1;
181 SELECT SQL_CALC_FOUND_ROWS 1 FROM (SELECT 1) as a LIMIT 0;
191 SELECT SQL_CALC_FOUND_ROWS * FROM t1 LIMIT 0;
262 SELECT SQL_CALC_FOUND_ROWS 'foo';
268 SELECT SQL_CALC_FOUND_ROWS 'foo' limit 0;
276 SELECT SQL_CALC_FOUND_ROWS 'foo' UNION SELECT 'bar' LIMIT 0;
[all …]
|
| /dports/databases/mysqlwsrep57-server/mysql-wsrep-wsrep_5.7.35-25.27/mysql-test/r/ |
| H A D | select_found.result | 4 select SQL_CALC_FOUND_ROWS * from t1;
17 select SQL_CALC_FOUND_ROWS * from t1 limit 1;
23 select SQL_BUFFER_RESULT SQL_CALC_FOUND_ROWS * from t1 limit 1;
29 select SQL_CALC_FOUND_ROWS * from t1 order by b desc limit 1;
35 select SQL_CALC_FOUND_ROWS distinct b from t1 limit 1;
181 SELECT SQL_CALC_FOUND_ROWS 1 FROM (SELECT 1) as a LIMIT 0;
191 SELECT SQL_CALC_FOUND_ROWS * FROM t1 LIMIT 0;
262 SELECT SQL_CALC_FOUND_ROWS 'foo';
268 SELECT SQL_CALC_FOUND_ROWS 'foo' limit 0;
276 SELECT SQL_CALC_FOUND_ROWS 'foo' UNION SELECT 'bar' LIMIT 0;
[all …]
|
| /dports/databases/percona57-server/percona-server-5.7.36-39/mysql-test/r/ |
| H A D | select_found.result | 4 select SQL_CALC_FOUND_ROWS * from t1;
17 select SQL_CALC_FOUND_ROWS * from t1 limit 1;
23 select SQL_BUFFER_RESULT SQL_CALC_FOUND_ROWS * from t1 limit 1;
29 select SQL_CALC_FOUND_ROWS * from t1 order by b desc limit 1;
35 select SQL_CALC_FOUND_ROWS distinct b from t1 limit 1;
181 SELECT SQL_CALC_FOUND_ROWS 1 FROM (SELECT 1) as a LIMIT 0;
191 SELECT SQL_CALC_FOUND_ROWS * FROM t1 LIMIT 0;
262 SELECT SQL_CALC_FOUND_ROWS 'foo';
268 SELECT SQL_CALC_FOUND_ROWS 'foo' limit 0;
276 SELECT SQL_CALC_FOUND_ROWS 'foo' UNION SELECT 'bar' LIMIT 0;
[all …]
|
| /dports/databases/xtrabackup/percona-xtrabackup-2.4.21/mysql-test/r/ |
| H A D | select_found.result | 4 select SQL_CALC_FOUND_ROWS * from t1;
17 select SQL_CALC_FOUND_ROWS * from t1 limit 1;
23 select SQL_BUFFER_RESULT SQL_CALC_FOUND_ROWS * from t1 limit 1;
29 select SQL_CALC_FOUND_ROWS * from t1 order by b desc limit 1;
35 select SQL_CALC_FOUND_ROWS distinct b from t1 limit 1;
181 SELECT SQL_CALC_FOUND_ROWS 1 FROM (SELECT 1) as a LIMIT 0;
191 SELECT SQL_CALC_FOUND_ROWS * FROM t1 LIMIT 0;
262 SELECT SQL_CALC_FOUND_ROWS 'foo';
268 SELECT SQL_CALC_FOUND_ROWS 'foo' limit 0;
276 SELECT SQL_CALC_FOUND_ROWS 'foo' UNION SELECT 'bar' LIMIT 0;
[all …]
|
| /dports/databases/percona57-client/percona-server-5.7.36-39/mysql-test/r/ |
| H A D | select_found.result | 4 select SQL_CALC_FOUND_ROWS * from t1;
17 select SQL_CALC_FOUND_ROWS * from t1 limit 1;
23 select SQL_BUFFER_RESULT SQL_CALC_FOUND_ROWS * from t1 limit 1;
29 select SQL_CALC_FOUND_ROWS * from t1 order by b desc limit 1;
35 select SQL_CALC_FOUND_ROWS distinct b from t1 limit 1;
181 SELECT SQL_CALC_FOUND_ROWS 1 FROM (SELECT 1) as a LIMIT 0;
191 SELECT SQL_CALC_FOUND_ROWS * FROM t1 LIMIT 0;
262 SELECT SQL_CALC_FOUND_ROWS 'foo';
268 SELECT SQL_CALC_FOUND_ROWS 'foo' limit 0;
276 SELECT SQL_CALC_FOUND_ROWS 'foo' UNION SELECT 'bar' LIMIT 0;
[all …]
|
| /dports/databases/mysql57-client/mysql-5.7.36/mysql-test/r/ |
| H A D | select_found.result | 4 select SQL_CALC_FOUND_ROWS * from t1;
17 select SQL_CALC_FOUND_ROWS * from t1 limit 1;
23 select SQL_BUFFER_RESULT SQL_CALC_FOUND_ROWS * from t1 limit 1;
29 select SQL_CALC_FOUND_ROWS * from t1 order by b desc limit 1;
35 select SQL_CALC_FOUND_ROWS distinct b from t1 limit 1;
181 SELECT SQL_CALC_FOUND_ROWS 1 FROM (SELECT 1) as a LIMIT 0;
191 SELECT SQL_CALC_FOUND_ROWS * FROM t1 LIMIT 0;
262 SELECT SQL_CALC_FOUND_ROWS 'foo';
268 SELECT SQL_CALC_FOUND_ROWS 'foo' limit 0;
276 SELECT SQL_CALC_FOUND_ROWS 'foo' UNION SELECT 'bar' LIMIT 0;
[all …]
|
| /dports/databases/percona56-server/percona-server-5.6.51-91.0/mysql-test/r/ |
| H A D | select_found.result | 4 select SQL_CALC_FOUND_ROWS * from t1;
17 select SQL_CALC_FOUND_ROWS * from t1 limit 1;
23 select SQL_BUFFER_RESULT SQL_CALC_FOUND_ROWS * from t1 limit 1;
29 select SQL_CALC_FOUND_ROWS * from t1 order by b desc limit 1;
35 select SQL_CALC_FOUND_ROWS distinct b from t1 limit 1;
179 SELECT SQL_CALC_FOUND_ROWS 1 FROM (SELECT 1) as a LIMIT 0;
189 SELECT SQL_CALC_FOUND_ROWS * FROM t1 LIMIT 0;
202 select SQL_CALC_FOUND_ROWS * from t1 where id > 3 limit 0, 1;
260 SELECT SQL_CALC_FOUND_ROWS 'foo';
266 SELECT SQL_CALC_FOUND_ROWS 'foo' limit 0;
[all …]
|
| /dports/databases/percona56-client/percona-server-5.6.51-91.0/mysql-test/r/ |
| H A D | select_found.result | 4 select SQL_CALC_FOUND_ROWS * from t1;
17 select SQL_CALC_FOUND_ROWS * from t1 limit 1;
23 select SQL_BUFFER_RESULT SQL_CALC_FOUND_ROWS * from t1 limit 1;
29 select SQL_CALC_FOUND_ROWS * from t1 order by b desc limit 1;
35 select SQL_CALC_FOUND_ROWS distinct b from t1 limit 1;
179 SELECT SQL_CALC_FOUND_ROWS 1 FROM (SELECT 1) as a LIMIT 0;
189 SELECT SQL_CALC_FOUND_ROWS * FROM t1 LIMIT 0;
202 select SQL_CALC_FOUND_ROWS * from t1 where id > 3 limit 0, 1;
260 SELECT SQL_CALC_FOUND_ROWS 'foo';
266 SELECT SQL_CALC_FOUND_ROWS 'foo' limit 0;
[all …]
|
| /dports/databases/percona-pam-for-mysql/percona-server-5.6.51-91.0/mysql-test/r/ |
| H A D | select_found.result | 4 select SQL_CALC_FOUND_ROWS * from t1;
17 select SQL_CALC_FOUND_ROWS * from t1 limit 1;
23 select SQL_BUFFER_RESULT SQL_CALC_FOUND_ROWS * from t1 limit 1;
29 select SQL_CALC_FOUND_ROWS * from t1 order by b desc limit 1;
35 select SQL_CALC_FOUND_ROWS distinct b from t1 limit 1;
179 SELECT SQL_CALC_FOUND_ROWS 1 FROM (SELECT 1) as a LIMIT 0;
189 SELECT SQL_CALC_FOUND_ROWS * FROM t1 LIMIT 0;
202 select SQL_CALC_FOUND_ROWS * from t1 where id > 3 limit 0, 1;
260 SELECT SQL_CALC_FOUND_ROWS 'foo';
266 SELECT SQL_CALC_FOUND_ROWS 'foo' limit 0;
[all …]
|
| /dports/databases/mysqlwsrep56-server/mysql-wsrep-wsrep_5.6.51-25.33/mysql-test/r/ |
| H A D | select_found.result | 4 select SQL_CALC_FOUND_ROWS * from t1;
17 select SQL_CALC_FOUND_ROWS * from t1 limit 1;
23 select SQL_BUFFER_RESULT SQL_CALC_FOUND_ROWS * from t1 limit 1;
29 select SQL_CALC_FOUND_ROWS * from t1 order by b desc limit 1;
35 select SQL_CALC_FOUND_ROWS distinct b from t1 limit 1;
179 SELECT SQL_CALC_FOUND_ROWS 1 FROM (SELECT 1) as a LIMIT 0;
189 SELECT SQL_CALC_FOUND_ROWS * FROM t1 LIMIT 0;
202 select SQL_CALC_FOUND_ROWS * from t1 where id > 3 limit 0, 1;
260 SELECT SQL_CALC_FOUND_ROWS 'foo';
266 SELECT SQL_CALC_FOUND_ROWS 'foo' limit 0;
[all …]
|