MySQL Bugs: #54266: Whole Line selected, load blob from file results in error

Bug #54266	Whole Line selected, load blob from file results in error
Submitted:	6 Jun 2010 16:53	Modified:	14 Jun 2010 14:30
Reporter:	Pro Bot	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench: SQL Editor	Severity:	S3 (Non-critical)
Version:	5.2.22 OSS RC	OS:	Windows
Assigned to:	Sergei Tkachenko	CPU Architecture:	Any
Tags:	load blob, whole line selected

Description:
When I select a whole Line by clicking at the header cell in the dark-gray colum of a line and Right-Click on a BLOB Column and then "Load value from file", select file I get an Error:
"Eine externe Komponente hat eine Ausnahme ausgelöst"
which means:
"An external componend has triggered an exception"

If I select only the cell and not the whole line works.

How to repeat:
-Open Workbench SQL Editor on a table with BLOB column
-Select whole line by clicking on darkgray header cell (first cell) of line
-Right click on BLOB column of selected line
-Select "Load value from file"
-Select a .png file and open it
-There you have the error :-(

Thank you for the problem report. Please, check with a newer version, 5.2.22, and in case of the same problem, send CREATE TABLE for the problematic table.

Ok, checked with newer version: Same error
Here is the Create Statement:
delimiter $$

CREATE TABLE `testtable` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name_de` varchar(50) NOT NULL,
  `name_it` varchar(50) NOT NULL,
  `name_en` varchar(50) NOT NULL,
  `ingredients_de` varchar(255) NOT NULL,
  `ingredients_it` varchar(255) NOT NULL,
  `ingredients_en` varchar(255) NOT NULL,
  `weight` varchar(15) NOT NULL,
  `image` blob,
  `breadgroup_id` int(11) NOT NULL,
  `show_guest` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name_de`),
  UNIQUE KEY `name_it` (`name_it`),
  UNIQUE KEY `name_en` (`name_en`)
) ENGINE=InnoDB AUTO_INCREMENT=61 DEFAULT CHARSET=utf8$$

I've tried it with a smaller table with only id, name, image, but there doesn't exists the error.

Verified exactly as described with your table on 32-bit Windows XP.

fix confirmed in repository

An entry has been added to the 5.2.23 changelog:

In the SQL Editor, editing a table with a row highlighted, right-clicking on a BLOB column and loading a value from a file resulted in the error: “An external component has triggered an exception”.