Bug #75360 Com_explain_other status variable is not described in the manual

• Submitted: 31 Dec 2014 10:19
• Modified: 22 Jan 2015 1:37
• Reporter: Valeriy Kravchuk
• Status: Closed
• Category: MySQL Server: Documentation
• Severity: S3 (Non-critical)
• Version: 5.7.5, 5.7.6
• OS: Any
• Assigned to: Paul DuBois
• CPU Architecture: Any
• Tags: Com_explain_other, missing manual

[31 Dec 2014 10:19] Valeriy Kravchuk

Description:
MySQL 5.7 already has Com_explain_other status variable, but http://dev.mysql.com/doc/refman/5.7/en/server-status-variables.html says nothing about it.

While we are on the topic, EXPLAIN OTHER is not documented at http://dev.mysql.com/doc/refman/5.7/en/explain.html as well.

How to repeat:
openxs@ao756:~/git/mysql-server$ grep -rni com_explain_other
sql/sql_yacc.yy:11887:            Lex->sql_command= SQLCOM_EXPLAIN_OTHER;
sql/sql_cmd.h:96:  SQLCOM_EXPLAIN_OTHER,
sql/sql_parse.cc:2129:              lex->sql_command == SQLCOM_EXPLAIN_OTHER);
sql/sql_parse.cc:4784:  case SQLCOM_EXPLAIN_OTHER:
sql/mysqld.cc:2452:  {"explain_other",        (char*) offsetof(STATUS_VAR, com_stat[(uint) SQLCOM_EXPLAIN_OTHER]), SHOW_LONG_STATUS},
...

Suggested fix:
Please, document all new status variables already introduced in 5.7.5.

[31 Dec 2014 11:06] MySQL Verification Team

Hello Valeriy,

Thank you for the report.

Thanks,
Umesh

[31 Dec 2014 11:07] MySQL Verification Team

// 5.7.6

mysql> show variables like '%version%';
+-------------------------+---------------------------------------------------------+
| Variable_name           | Value                                                   |
+-------------------------+---------------------------------------------------------+
| innodb_version          | 5.7.6                                                   |
| protocol_version        | 10                                                      |
| slave_type_conversions  |                                                         |
| version                 | 5.7.6-m16-enterprise-commercial-advanced                |
| version_comment         | MySQL Enterprise Server - Advanced Edition (Commercial) |
| version_compile_machine | x86_64                                                  |
| version_compile_os      | linux-glibc2.5                                          |
+-------------------------+---------------------------------------------------------+
7 rows in set (0.00 sec)

mysql> show status  like 'Com_explain%';
+-------------------+-------+
| Variable_name     | Value |
+-------------------+-------+
| Com_explain_other | 0     |
+-------------------+-------+
1 row in set (0.00 sec)

[22 Jan 2015 1:37] Paul DuBois

Thank you for your bug report. This issue has been addressed in the documentation. The updated documentation will appear on our website shortly.

There is no EXPLAIN OTHER.

Com_explain_other was added in 5.7.2 as an accompaniment to EXPLAIN FOR CONNECTION.

http://dev.mysql.com/doc/refman/5.7/en/explain-for-connection.html