Bug #29731 | SHOW STATUS and SHOW VARIABLES accept a WHERE clause | ||
---|---|---|---|
Submitted: | 11 Jul 2007 18:35 | Modified: | 24 Jul 2007 15:16 |
Reporter: | Baron Schwartz (Basic Quality Contributor) | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server: Documentation | Severity: | S3 (Non-critical) |
Version: | 5.0.44, 5.0.38 | OS: | Any |
Assigned to: | Paul DuBois | CPU Architecture: | Any |
[11 Jul 2007 18:35]
Baron Schwartz
[11 Jul 2007 18:40]
Paul DuBois
http://dev.mysql.com/doc/refman/5.0/en/show.html http://dev.mysql.com/doc/refman/5.0/en/extended-show.html
[11 Jul 2007 18:43]
Valeriy Kravchuk
Som this is really documented already.
[11 Jul 2007 18:44]
Baron Schwartz
Should the formal description at the top of the sections mention this? It mentions the optional LIKE clause: SHOW [GLOBAL | SESSION] STATUS [LIKE 'pattern'] Perhaps it should be something like SHOW [GLOBAL | SESSION] STATUS [LIKE 'pattern'] [WHERE <where-clause>
[11 Jul 2007 18:46]
Valeriy Kravchuk
Indeed, page http://dev.mysql.com/doc/refman/5.0/en/show-variables.html should be updated, I think.
[24 Jul 2007 15:16]
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. All SHOW statements that take a LIKE clause also accept a WHERE clause. I have updated the syntax and descriptions for the relevant SHOW statements to indicate this.