Bug #65698 information_schema.PROCESSLIST truncated

Submitted: 21 Jun 2012 9:25 Modified: 21 Jun 2012 18:26
Reporter: Jo R Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Information schema Severity:S3 (Non-critical)
Version:5.1.41, 5.1.64, 5.5.26, 5.6.6 OS:Any
Assigned to: CPU Architecture:Any
Tags: PROCESSLIST, truncated

[21 Jun 2012 9:25] Jo R 
Description:
information_schema.PROCESSLIST gets truncated when contains non ASCII character.

How to repeat:
execute: 

-- --
drop procedure if exists sp_test;
delimiter $$
CREATE PROCEDURE `sp_test`()
BEGIN
    SET @sql = CONCAT('SELECT "',unhex('31a032'),'", sleep(10)');
    PREPARE stmt FROM @sql;
    EXECUTE stmt;
END$$
delimiter ;
call sp_test();drop procedure if exists sp_test;
-- -- 

during 10 sec check information_schema.PROCESSLIST:

-- --
select info from `information_schema`.`PROCESSLIST`;
show warnings;
-- --

it's truncated right after '1' character
[21 Jun 2012 18:26] Sveta Smirnova 
Thank you for the report.

Verified as described. Partial workaround: use SHOW PROCESSLIST

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.039 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.