Comment 5 for bug 1704195

Compiled with -DMYSQL_MAINTAINER_MODE=OFF, but still seeing the issue:

mysql> show processlist;
+----+------+-----------------+------+------------+------+-------------------------+--------------------------------------------+-----------+---------------+
| Id | User | Host | db | Command | Time | State | Info | Rows_sent | Rows_examined |
+----+------+-----------------+------+------------+------+-------------------------+--------------------------------------------+-----------+---------------+
| 2 | root | localhost:59258 | test | Query | 0 | init | show processlist | 0 | 0 |
| 3 | root | localhost:59262 | test | Query | 20 | User sleep | select sleep(1) from goods limit 1000, 300 | 20 | 0 |
| 4 | root | localhost:59264 | test | Field List | 11 | Waiting for table flush | | 0 | 0 |
+----+------+-----------------+------+------------+------+-------------------------+--------------------------------------------+-----------+---------------+
3 rows in set (0,01 sec)

Test case I use:

1. Load dump from the link which will be provided in separate comment.
2. In session 1: select sleep(1) from goods limit 1000, 300;
3. In session 2: analyze table goods;
4. In session 3: either connect to the database or select * from goods order by id limit 10;