Bug #11691 Blob Columns do not display/edit correctly
Submitted: 1 Jul 2005 14:40 Modified: 17 Aug 2005 11:00
Reporter: Nuno Pereira Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Query Browser Severity:S3 (Non-critical)
Version:1.1.12 OS:Linux (Linux)
Assigned to: Vladimir Kolesnikov CPU Architecture:Any

[1 Jul 2005 14:40] Nuno Pereira
Description:
I selected a few rows from a table that has 2 blob (or mediumblob) columns with images on it, but what I see is the contents of few columns before.
Also when I try to edit the same columns, the contents of that blob column remain equal, but the other column (that I saw her contents), are changed.

It was working fine for MySQL QB 1.1.6.

How to repeat:
1) Create a table with a blob column
2) Insert some data to the table filling the blob column (I can't do this with MySQL 1.1.12, with 1.1.6 it's OK, but maybe you can try it with another interface.
3) Select the rows of the table.
4) View the contents of the Blob column

Suggested fix:
See how the editing, visualization was beeing done in 1.1.6, because it works fine
[6 Jul 2005 16:52] Nuno Pereira
The same situation happens with see/edit text/mediumtext columns
[5 Aug 2005 21:53] Aleksey Kishkin
tested against suse 9.3 and query browser 1.1.12 
Visualisation of blobs and text fields is broken. ( Actually i always got empty value despite the fact that fields contained some values)

I made a table  

create table bug11691 (uq int primary key, bb blob, delim int, cargo text);

insert into bug11691 values (1,'t1',1,'mambo1'), (2,'t2',2,'mambo2'),(3,'t3','3','mambo3');

enter into query area
select * from bug11691 

and look at recordset by 'view field in popup editor'. Fields uq and delim showed values. Fields bb and cargo always seemed empty.
[17 Aug 2005 11:00] Vladimir Kolesnikov
Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html
[9 Oct 2005 8:46] Msquared
Where is the current source repository for QB?  According http://www.mysql.com/doc/en/Installing_source_tree.html it's BitKeeper, and while I can find a BK BQ respository there, it doesn't seem to have been updated in 8 months:

  http://mysql.bkbits.net:8080/mysql-query-browser/ChangeSet@-9M?nav=index.html