Bug #60657 INSERT BLOB doesn't work. Regression bug.
Submitted: 26 Mar 2011 15:59 Modified: 1 Dec 2011 18:39
Reporter: Screen Cleaner Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench: Modeling Severity:S2 (Serious)
Version:5.2.33 OS:Linux (Ubuntu 10.10)
Assigned to: CPU Architecture:Any
Tags: INSERT BLOB regression

[26 Mar 2011 15:59] Screen Cleaner 
Description:
The problem occurs when trying to "Forward Engineer" the database.
When I check the "Generate INSERT Statements for Tables" checkbox, the generated INSERT statements for the BLOB columns, when reviewing the generated SQL, contains "..."(three dots) instead of the actual BLOB data.

This problem is present since 5.2.31

How to repeat:
1. Create a simple table.
2. Add a BLOB column.
3. In the "Inserts" tab add a row. On the BLOB column - right click and choose "Load from file".
4. Now in the "Database" menu go to "Forward Engineer" and check "Generate INSERT Statements for Tables".
5. Click "Next" a couple of times to review the SQL script and find the INSERT statement.
[23 Apr 2011 6:43] Valeriy Kravchuk 
I can not repeat this on Mac OS X as I get

near ".": syntax error

while loading almost any (text) file as a value...
[17 May 2011 8:33] Valeriy Kravchuk 
On Ubuntu 10.04 I do not get INSERT at all in this case. After trying to forward engineer even committed row disappear from the INSERTs tab. We definitely have problems here.
[1 Aug 2011 11:24] Cobus Stroebel 
Also having this problem on Ubuntu 10.04.
I am using version 5.2.25.

No insert statements are generated for blob fields.
[1 Dec 2011 18:39] Philip Olson 
Fixed as of 5.2.36:

+        The <guimenu>Generate INSERT Statements for Tables</guimenu>
+        option would not generate <literal>INSERT</literal> statements
+        for <literal>BLOG</literal> columns.