Bug #57814 WorkBench Procedure Analyse
Submitted: 28 Oct 2010 14:41 Modified: 28 Oct 2010 14:51
Reporter: Shane Williams Email Updates:
Status: Closed Impact on me:
Category:MySQL Workbench: SQL Editor Severity:S3 (Non-critical)
Version:5.2.29 CE Rev 6756 OS:Any
Assigned to: CPU Architecture:Any

[28 Oct 2010 14:41] Shane Williams
Using Procedure Analyse in a query returns the following fields as BLOBS instead of actually displaying the contents within the results window:

Field_Name, Min_value, Max_value, Avg_value_or_avg_length, Std, Optimal_fieldtype

The BLOBs returned appear to be addresses that can be viewed by right-clicking and choosing the Open Value in Viewer and then the TEXT tab.

How to repeat:
add Procedure Analyse to the end of any Select query

Suggested fix:
Return contents of BLOBs for the fields mentioned.
[28 Oct 2010 14:51] Shane Williams
The issue was resolved by Editing the Preferences and ensuring that the Treat Binary/VarBinary data as nonbinary character string....on the SQL Editor tab.