Bug #69688 PROCEDURE ANALYSE results are not displayed properly
Submitted: 8 Jul 2013 10:53 Modified: 9 Jul 2013 23:00
Reporter: Matthias Maier Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S3 (Non-critical)
Version:6.0.2 OS:Windows (7 SP1)
Assigned to: CPU Architecture:Any
Tags: BLOB, PROCEDURE ANALYSE, result

[8 Jul 2013 10:53] Matthias Maier
Description:
Some columns (Field_name, Min_value, Max_value, Avg_value_or_avg_length, Std, Optimal_fieldtype) of the result of PROCEDURE ANALYSE (http://dev.mysql.com/doc/refman/5.6/en/procedure-analyse.html) are displayed as BLOB value. The other integer columns (Min_length, Max_length, Empties_or_zeros, Nulls) are displayed correctly.

How to repeat:
Run a query like
SELECT col1, col2 FROM table1 PROCEDURE ANALYSE(10, 2000);
and check if columns Field_name, Min_value, Max_value, Avg_value_or_avg_length, Std, Optimal_fieldtype are displayed correctly not as blob.

Suggested fix:
Show all columns with correct values/data type like in other SQL Editors.
[8 Jul 2013 11:13] MySQL Verification Team
Hello Matthias,

Thank you for the bug report and the test case. 
Verified as described..

Thanks,
Umesh
[9 Jul 2013 22:58] Alfredo Kojima
That is because these values are returned by the server as VARBINARY strings. You can make WB display them as normal strings by using the Preferences -> SQL Queries -> Treat BINARY/VARBINARY as nonbinary character string option