Bug #56803 The Replace command in workbench returns blob
Submitted: 15 Sep 2010 18:45 Modified: 15 Sep 2010 23:32
Reporter: Gihovani Demétrio Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S3 (Non-critical)
Version:5.2.27 OS:Windows
Assigned to: CPU Architecture:Any
Tags: BLOB, REPLACE, RETURNS, workbench

[15 Sep 2010 18:45] Gihovani Demétrio
Description:
Hi there,

There is a bug in MySQL Workbench version 5.2.27 while using the command SELECT CONCAT('MYSQL ', REPLACE(5.27, 2, 3)); just returns "BLOB"

Here is some images to compare:
Using workbench:
http://www.ezclick.com.br/images/workbench.jpg
Using phpmyadmin:
http://www.ezclick.com.br/images/phpmyadmin.jpg

How to repeat:
SELECT CONCAT('MYSQL ', REPLACE(5.27, 2, 3));
[15 Sep 2010 22:13] MySQL Verification Team
Thank you for the bug report. Please right click on result data and select Open Value in Viewer. Thanks in advance.
[15 Sep 2010 23:27] Gihovani Demétrio
thank you. worked pretty well!
[15 Sep 2010 23:32] MySQL Verification Team
Thank you for the feedback.