Bug #57812 updating LONGTEXT fails
Submitted: 28 Oct 2010 14:16 Modified: 1 Jan 2011 13:00
Reporter: mitja c Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S3 (Non-critical)
Version:5.2.29CE rev. 6756 OS:Windows
Assigned to: CPU Architecture:Any
Tags: longtext, UPDATE, updating

[28 Oct 2010 14:16] mitja c
Description:
using sql editor with EDIT command to edit rows, I'm unable to save updated rows of type longtext because the value is not surrounded by apostrophs (')

How to repeat:
set new value to a field of type longtext and apply the change

in my example, I'm trying to update the table that has following fields
 subtitle - varchar
 content - longtext
 short_content - text

here is generated sql query after clicking on apply button:
UPDATE `some_db`.`some_table` SET `subtitle`='varchar', `content`=logtext_value, `short_content`='text' WHERE `id_content`='171';

as you can see, longvalue is missing the apostrophs arround the new content of the field (`content`=logtext_value instead of `content`='logtext_value')
[28 Oct 2010 14:31] Valeriy Kravchuk
Looks like a duplicate of bug #56542.
[28 Oct 2010 17:32] mitja c
yes it is a duplicate, sorry, I didn't find that bug although I searched. closing this one..