Bug #34651 SHOW INNODB STATUS syntax error
Submitted: 18 Feb 2008 23:25 Modified: 19 Feb 2008 18:20
Reporter: Peter Gulutzan Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version:6.0.5-alpha-debug OS:Linux (SUSE 10 | 32-bit)
Assigned to: Paul DuBois CPU Architecture:Any

[18 Feb 2008 23:25] Peter Gulutzan 
Description:
The MySQL Reference Manual for 6.0
http://dev.mysql.com/doc/refman/6.0/en/show-innodb-status.html

says
"
SHOW INNODB STATUS
In MySQL 6.0, this is a deprecated synonym for SHOW ENGINE INNODB STATUS.
"

But it's not deprecated. It's gone.
I get a syntax error if I use it.

How to repeat:
mysql> show innodb status;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'innodb status' at line 1
[19 Feb 2008 0:43] MySQL Verification Team 
Thank you for the bug report.
[19 Feb 2008 18:20] 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.

Removed mention of SHOW INNODB STATUS as deprecated in 6.0, because it's gone.

Similar lingering references were made to table_type, SHOW TABLE TYPES, LOAD TABLE ... FROM MASTER, LOAD DATA FROM MASTER, BACKUP TABLE, and RESTORE TABLE.