MySQL Bugs: #57716: SHOW PROFILE truncates

Bug #57716	SHOW PROFILE truncates
Submitted:	25 Oct 2010 17:45	Modified:	25 Oct 2010 20:35
Reporter:	Peter Laursen (Basic Quality Contributor)	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Server	Severity:	S3 (Non-critical)
Version:	5.1.51	OS:	Any
Assigned to:		CPU Architecture:	Any
Tags:	qc

Description:
This is a small cosmetical issue with SHOW PROFILE only.

How to repeat:
-- ensure Query Cache is enabled
SET profiling = 1;
SELECT .. ; -- anything. QC will cache query and result
SELECT .. ; -- result is now sent from QC
SHOW PROFILE; -- see 'sending cached result to client' get truncated to 'sending cached result to clien'

Suggested fix:
Don't have longer strings in SHOW PROFILE output than the character buffer used (rewrite too-long-strings or increase buffer size)

Thank you for the bug report.

mysql 5.1 >SHOW PROFILE;
+--------------------------------+----------+
| Status                         | Duration |
+--------------------------------+----------+
| starting                       | 0.000030 |
| checking query cache for query | 0.000011 |
| checking privileges on cached  | 0.000008 |
| sending cached result to clien | 0.000581 |
| logging slow query             | 0.000003 |
| cleaning up                    | 0.000004 |
+--------------------------------+----------+
6 rows in set (0.00 sec)

mysql 5.1 >

related: bug #59273