Bug #71301 Manual mentions COM_FETCH "command" that does not exist (any more)
Submitted: 5 Jan 2014 13:24 Modified: 22 Jan 2014 13:41
Reporter: Valeriy Kravchuk Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version:5.6 OS:Any
Assigned to: Paul DuBois CPU Architecture:Any
Tags: COM_FETCH, performance_schema, setup_instruments

[5 Jan 2014 13:24] Valeriy Kravchuk
Description:
Manual page on instruments naming for PERFORMANCE_SCHEMA (http://dev.mysql.com/doc/refman/5.6/en/performance-schema-instrument-naming.html) says:

"statement/com: An instrumented command operation. These have names corresponding to COM_xxx operations (see the mysql_com.h header file and sql/sql_parse.cc. For example, the statement/com/Connect and statement/com/Fetch instruments correspond to the COM_CONNECT and COM_FETCH commands."

I think COM_FETCH is not a good example, as I can not find it neither in mysql_com.h header nor in recent source code any more. Maybe you meant something like COM_STMT_FETCH?

How to repeat:
openxs@ao756:~/bzr/mysql-5.6$ bzr version-info
revision-id: balasubramanian.kandasamy@oracle.com-20131117175136-krens8wjj5zgeg4z
date: 2013-11-17 18:51:36 +0100
build-date: 2014-01-05 15:18:59 +0200
revno: 5585
branch-nick: mysql-5.6
openxs@ao756:~/bzr/mysql-5.6$ grep -rn COM_FETCH *
include/mysql.h:624:  unsigned long  prefetch_rows;        /* number of rows per one COM_FETCH */
openxs@ao756:~/bzr/mysql-5.6$ grep COM_FETCH /usr/include/mysql_com.h
openxs@ao756:~/bzr/mysql-5.6$ grep COM_ /usr/include/mysql_com.h
  COM_SLEEP, COM_QUIT, COM_INIT_DB, COM_QUERY, COM_FIELD_LIST,
  COM_CREATE_DB, COM_DROP_DB, COM_REFRESH, COM_SHUTDOWN, COM_STATISTICS,
  COM_PROCESS_INFO, COM_CONNECT, COM_PROCESS_KILL, COM_DEBUG, COM_PING,
  COM_TIME, COM_DELAYED_INSERT, COM_CHANGE_USER, COM_BINLOG_DUMP,
  COM_TABLE_DUMP, COM_CONNECT_OUT, COM_REGISTER_SLAVE,
  COM_STMT_PREPARE, COM_STMT_EXECUTE, COM_STMT_SEND_LONG_DATA, COM_STMT_CLOSE,
  COM_STMT_RESET, COM_SET_OPTION, COM_STMT_FETCH, COM_DAEMON,
  COM_END
  in reply to COM_STMT_EXECUTE and COM_STMT_FETCH commands.
  COM_STMT_FETCH command.
openxs@ao756:~/bzr/mysql-5.6$

Suggested fix:
Fix that manual page to mention COM_* commands that are really supported in current MySQL 5.6.
[22 Jan 2014 13:41] 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, and will be included in the next release of the relevant products.

Changed to use more obvious correspondence: Init DB -> COM_INIT_DB