MySQL Bugs: #59256: Can't commit BLOB data on Inserts tab

Bug #59256	Can't commit BLOB data on Inserts tab
Submitted:	3 Jan 2011 6:16	Modified:	26 Jun 2014 20:05
Reporter:	Paul Macdonnell	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Workbench: Modeling	Severity:	S3 (Non-critical)
Version:	5.2.31	OS:	Any (Windows XP, Linux)
Assigned to:		CPU Architecture:	Any
Tags:	BLOB, commit, inserts

Description:
When adding data to a table via the "Inserts" tab, I'm unable to commit data in fields with a datatype of "BLOB".
I can successfully commit other datatypes (VARCHAR, INT, etc).

How to repeat:
Add a new table to a schema.
Add columns to the table, ensuring one is of type "BLOB".
Go to the "Inserts" tab.
Add data to the columns which are NOT of type BLOB.
Click the "commit" button.
Close the table editing tab.  This should work successfully (I.E. no error message and data remains where re-editing the table).

Edit the same table.
Click to the "Inserts" tab.
Add data to the BLOB column(s).
Click the "commit" button.
Close the table editing table.  This will raise the following error message:
"There are unsaved changes in the INSERTS editor.
Please Apply or Revert these changes before closing."

Suggested fix:
Allow BLOB data to be committed.

Please, send exact CREATE TABLE statement for the table you are trying to insert data into.

Here is the CREATE TABLE statement for the table in question:

CREATE  TABLE IF NOT EXISTS `ExPr`.`kinesiology` (
  `id` INT NOT NULL AUTO_INCREMENT ,
  `type` VARCHAR(45) NOT NULL ,
  `name` VARCHAR(45) NOT NULL ,
  `description` BLOB NULL ,
  PRIMARY KEY (`id`) )
ENGINE = InnoDB;

Cheers,
Paul

Verified as described on Windows XP SP3. Note that this works as expected in SQL Editor part.

Posted by developer:
 
Can't repeat this, it was probalby fixed a long time ago.