MySQL Bugs: #88935: incorrect document on server status `Queries`

Bug #88935	incorrect document on server status `Queries`
Submitted:	15 Dec 2017 5:23	Modified:	29 Apr 2019 5:40
Reporter:	黄炎-爱可生 (OCA)	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Server: Connection Handling	Severity:	S3 (Non-critical)
Version:	5.7.19, 5.7.20	OS:	Any
Assigned to:		CPU Architecture:	Any
Tags:	Contribution

Description:
In https://dev.mysql.com/doc/refman/5.7/en/server-status-variables.html#statvar_Queries, document says: "The number of statements executed by the server. This variable includes statements executed within stored programs, unlike the Questions variable. It does not count COM_PING or COM_STATISTICS commands.", which is incorrect

Server status `Queries` does count `COM_PING` and `COM_STATISTICS`.

How to repeat:
0. show global status like 'queries'
1. send a `COM_PING` to mysqld
2. show global status like 'queries', it increased by 1

In code: 
status `queries` is equals to `thd->query_id`, which will be increased by `dispatch_command` for COM_*, including `COM_PING` and `COM_STATISTICS`.

Suggested fix:
Update documents.

Hello Yan Huang,

Thank you for the report and feedback.

Thanks,
Umesh

Posted by developer:
 
Per discussion above, this is a server bug. Recategorizing.

patch on #88935

Attachment: 88935.diff (application/octet-stream, text), 4.16 KiB.

Above patch makes 'queries' work as 'questions'. Hope it help if this bug is a server bug.

Thanks.

Hello Yan Huang,

Thank you for your contribution.
Please ensure to re-send the patch via  "Contributions" tab. Otherwise we would not be able to accept it.

regards,
Umesh

patch (*) I confirm the code being submitted is offered under the terms of the OCA, and that I am authorized to contribute it.

Contribution: 88935.diff (application/octet-stream, text), 4.16 KiB.

Hello Umesh,
The patch is resent via "Contributions" tab.

Thank you very much.