Bug #50692 All text fields show as 'blob' in query results
Submitted: 28 Jan 2010 15:29 Modified: 10 Feb 2010 11:39
Reporter: Bob Dankert Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S2 (Serious)
Version:5.2.14 Rev 4990 OS:Any
Assigned to: Sergei Tkachenko CPU Architecture:Any
Tags: TEXT BLOB

[28 Jan 2010 15:29] Bob Dankert 
Description:
When I run any query (or an edit of a table data) that involves returning columns defined as text, they are all being returned instead with a blob icon and there is no way to see the contents of the column.  Prior to upgrading to this version, all text fields returned their actual text instead of showing blob.

How to repeat:
Query or edit a table that contains a text field.

Suggested fix:
Display the contents of the text field instead of the blob icon.  I would also recommend that there be some way to display the content of blob's similar to QB, however that should go to a new bug.
[29 Jan 2010 0:44] Steve Miller 
Verified on Windows XP x86, MySQL Workbench 5.2.15
[29 Jan 2010 10:51] Sascha Szott 
In #50111 MySQL developer Sergei Tkachenko already reported that all kind of text fields are represented as BLOB values to avoid ui performance hit caused
by potentially large values. However, would at be at least possible to add an option that enables the output of text fields (at the risk of performance degradation)? Text fields are so common today that I doubt most users like the current behaviour.
[29 Jan 2010 14:48] Sergei Tkachenko 
I will work on adding such an option. The idea is to provide global WB option specifying number of symbols to represent for TINYTEXT/TEXT/MEDIUMTEXT/LONGTEXT fields, and the rest of the field value will be truncated until you start editing. Default value for the option will be 256. To disable truncation when visualizing field values in grid you'll have to set it to -1.
Any objections?
[29 Jan 2010 15:14] Bob Dankert 
I think that the solution described by Sergei would be excellent and a most-welcome improvement.

Thanks!

Bob
[29 Jan 2010 15:47] Sascha Szott 
Such an option would be great! Can you guess how long it will take you to implement this feature?
[29 Jan 2010 16:10] Sergei Tkachenko 
v5.2.16 will most probably contain the fix. At least it's planned to be so.
[29 Jan 2010 16:14] Sascha Szott 
Thanks a lot!
[3 Feb 2010 8:48] Johannes Taxacher 
Bug #50814 has been marked as duplicate of this one
[4 Feb 2010 17:47] Johannes Taxacher 
fix in repository confirmed
[5 Feb 2010 16:22] Johannes Taxacher 
Bug #50948 has been marked as duplicate of this one
[10 Feb 2010 11:39] Tony Bedford 
Changelog has been updated. See also Bug #50111, #50948, #50814.
[16 Feb 2010 11:07] Valeriy Kravchuk 
Bug #51207 was marked as a duplicate of this one.
[18 Feb 2010 12:17] Johannes Taxacher 
Bug #51214 has been marked as duplicate of this one
[8 Mar 2010 14:45] Johannes Taxacher 
Bug #51829 has been marked as duplicate of this one
[11 Jul 2011 19:30] Jesse Perring 
A restart is required after changing the byte size to -1, just FYI to save you 5 minutes. ;p