Bug #93238 error rows_examined when logout
Submitted: 17 Nov 2018 13:15 Modified: 18 Nov 2018 5:35
Reporter: xiaobin lin (OCA) Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Logging Severity:S3 (Non-critical)
Version:5.x, 5.6.42, 5.7.24, 8.0.13 OS:Any
Assigned to: CPU Architecture:Any
Tags: logout, Rows_examined

[17 Nov 2018 13:15] xiaobin lin
Description:
When a connection quit, the sent,rows_examined is the value of last query.

How to repeat:

create table t(id int, c int)engine=innodb;
insert into t values(1,1);
set global log_output='table';
set long_query_time=0;
select * from t;
quit

==connect again==
select rows_sent,rows_examined,sql_text from mysql.slow_log where sql_text='Quit'
+-----------+---------------+----------+
| rows_sent | rows_examined | sql_text |
+-----------+---------------+----------+
|         1 |             1 | Quit     |
+-----------+---------------+----------+

Suggested fix:
expected: rows_sent=0, rows_examined=0
[18 Nov 2018 5:35] Umesh Shastry
Hello xiaobin lin,

Thank you for the report and test case.

thanks,
Umesh