MySQL Bugs: #11447: Edit functionality on BLOB columns not working

Bug #11447	Edit functionality on BLOB columns not working
Submitted:	20 Jun 2005 8:03	Modified:	22 Jun 2005 7:46
Reporter:	Kai Sautter (Basic Quality Contributor)	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Query Browser	Severity:	S3 (Non-critical)
Version:	1.1.10	OS:	Windows (Windows XP (SP2))
Assigned to:		CPU Architecture:	Any

Description:
I am trying to manage the content of a BLOB column using query browser.

Onve the table is in edit mode, an icon to upload a file appears in an empty field at the very right --> working fine.

If there is already content in the field, a number of icons appear allowing (suggesting) a number of actions, yet not of it does what you would imply form the icon. The only action you can get is the file open dialog (the above mentioned functionality to add a file) when clicking on the cross icon (delete filed content?), which is now at the position where the file open icon was when the filed was empty (changes were committed).

How to repeat:
(1) Create a table with a BLOB field.
(2) Select the table in Query Browser
(3) Put the table in edit mode
(4) Click the filder icon and upload a file
(5) Commit changes
(6) Click on the various icons that now appear in the filed of the just added BLOB.

Comments:
You might need to add some (at least one) lines to the table prior to step (3).
The above behaviout can also be observed, if the Query Browser is closed between stepps (5) and (6).

sorry didn't catch what's wrong. Could you please to explain more detailed?

In edit mode blob can be saved to file. Or uploaded from file. or deleted. As far as blob is 'binary large object' - some raw data, there is no way (in common case) to edit it in the query browser.

I tried to reproduce the problem once again, but now it works. I will have to investigate the specific conditions under which it occurred once again. Please close the bug in the meantime. If I can reproduce it, I will rereport it.

I am sorry for this.