MySQL Bugs: #57814: WorkBench Procedure Analyse

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:	None
Category:	MySQL Workbench: SQL Editor	Severity:	S3 (Non-critical)
Version:	5.2.29 CE Rev 6756	OS:	Any
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
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.

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.