MySQL Bugs: #27883: information_schema.proccesslist is full list

Bug #27883	information_schema.proccesslist is full list
Submitted:	17 Apr 2007 14:52	Modified:	19 Apr 2007 18:52
Reporter:	Scott Noyes (Basic Quality Contributor)	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Documentation	Severity:	S3 (Non-critical)
Version:	5.1.7	OS:	Any
Assigned to:	Paul DuBois	CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
The manual says, 
"The following statements are equivalent:
SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST
SHOW PROCESSLIST"

However, selecting from the information_schema shows the info field with more than 100 characters, which is the behavior when using the FULL keyword.

How to repeat:
http://dev.mysql.com/doc/refman/5.1/en/processlist-table.html

Suggested fix:
Change the equivalent statement to SHOW FULL PROCESSLIST

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.