1--disable_warnings
2DROP TABLE IF EXISTS t1;
3--enable_warnings
4
5CREATE TABLE t1 (a INT, INDEX (a));
6INSERT INTO t1 VALUES (),(),(),(),(),(),(),(),(),();
7
8FLUSH STATUS;
9SELECT a FROM t1 ORDER BY a LIMIT 1;
10SHOW STATUS LIKE 'HANDLER_READ%';
11
12FLUSH STATUS;
13SELECT a FROM t1 ORDER BY a DESC LIMIT 1;
14SHOW STATUS LIKE 'HANDLER_READ%';
15
16FLUSH STATUS;
17SELECT a FROM t1 ORDER BY a LIMIT 3;
18SHOW STATUS LIKE 'HANDLER_READ%';
19
20FLUSH STATUS;
21SELECT a FROM t1 ORDER BY a DESC LIMIT 3;
22SHOW STATUS LIKE 'HANDLER_READ%';
23
24DROP TABLE t1;
25
26