MySQL Bugs: #82002: Incorrect Rows

Bug #82002	Incorrect Rows_examined value
Submitted:	25 Jun 2016 7:53	Modified:	27 Jul 2016 8:18
Reporter:	imane ziabat	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Server: Logging	Severity:	S3 (Non-critical)
Version:	5.6	OS:	Ubuntu
Assigned to:		CPU Architecture:	Any

Description:
Version: 5.6.30-76.3-log (Percona Server (GPL), Release 76.3, Revision 3850db5)

Entries in the slow query log could have an incorrect Rows_examined value

How to repeat:
In Log file I have for this query :

select count(*) as cnt from users;

# Query_time: 2.672217  Lock_time: 0.000062  Rows_sent: 0  
Rows_examined: 788210  Rows_affected: 0

But actually I have just 10 rows

mysql> SELECT COUNT(*) FROM users;
+----------+
| COUNT(*) |
+----------+
|      9   |
+----------+

Hello Imane Ziabat,

Thank you for the report.
I could not repeat this issue at my end with options --slow_query_log=1 --log-queries-not-using-indexes --long-query-time=0 on 5.6.31 and using dummy schema. Could you please share details from your environment such as show create table users\G and conf file used? You may want to mark as private note after posting here.

Thanks,
Umesh

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".