Bug #53245 Field viewer doesn't display image on Mac OSX
Submitted: 28 Apr 2010 11:48 Modified: 13 May 2010 12:36
Reporter: Giuseppe Maxia Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S3 (Non-critical)
Version:5.2.20 OS:MacOS (10.5, 10.6)
Assigned to: Alfredo Kojima CPU Architecture:Any
Tags: editor, viewer, workbench

[28 Apr 2010 11:48] Giuseppe Maxia
Description:
In the SQL editor of MySQL Workbench, when you have a blob, you should be able to display the field in the viewer.

However, the field viewer does not display the image.

Notice, though, that using the "save" button in the viewer, the image is saved correctly and it is usable (from other applications).

How to repeat:
1.  save a JPEG image into /tmp/p.jpg
2.  In workbench, run these queries:
    create table t1 (p blob);
    insert into t1 values (load_file('/tmp/p.jpg'));
    select * from t1
3.  right click on the result cell. Select "open value in viewer"
4.  click on the "image" tab. It is blank
[29 Apr 2010 12:51] Susanne Ebrecht
I am not able to repeat this on Ubuntu. Seems to be a Mac only problem.
[29 Apr 2010 13:08] Valeriy Kravchuk
Not repeatable on Windows also.
[29 Apr 2010 13:13] Giuseppe Maxia
Indeed. The problem is on Mac only, as the "OS" label says. Can anyone verify it?
[29 Apr 2010 18:07] Valeriy Kravchuk
Verified just as described on Mac OS X 10.5.x.
[3 May 2010 17:05] Wil Moore
I have verified this on MAC OS X 10.6.3 running MySQL Workbench 5.2.20 beta.
[3 May 2010 19:44] Alfredo Kojima
Does the editor display the correct image size at the bottom? Or does it say 0 bytes?
[4 May 2010 0:07] Wil Moore
I am getting the correct data length. Terminal shows 19K (rounded up) and editor shows "18831" bytes.
[4 May 2010 14:53] Alfredo Kojima
If you resize the Window the image should appear.
[4 May 2010 15:23] Alfredo Kojima
Fixed
[4 May 2010 15:46] Wil Moore
I have verified that resizing the window does correctly display the image.
[5 May 2010 21:14] Johannes Taxacher
fix confirmed in repository
[13 May 2010 12:36] Tony Bedford
An entry has been added to the 5.2.21 changelog:

In the SQL Editor, if a BLOB field containing an image was loaded into the Viewer, the image was not displayed.