EXPLAIN shows type=range, while SHOW EXPLAIN and userstat show full table scan is used

Description

For the following query

usual EXPLAIN produces

while SHOW EXPLAIN says

As always, SLEEP in the query is not essential, it just makes the query a bit longer and allows to catch it by SHOW EXPLAIN.

bzr version-info (5.5-show-explain-test1)

Test case:

Environment

None

Assignee

Sergei Petrunia

Reporter

Elena Stepanova

Labels

None

Fix versions

Priority

Major
Configure