Bug #66031 Mysql Workbench trims longtext fields
Submitted: 26 Jul 2012 17:28 Modified: 3 Feb 2015 6:02
Reporter: Pedro Gauna Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench Severity:S2 (Serious)
Version:5.2.41 OS:Linux (Linux 3.2.0-27-generic)
Assigned to: CPU Architecture:Any
Tags: WBBugReporter

[26 Jul 2012 17:28] Pedro Gauna 
Description:
When copying or pasting texto into a LONGTEXT field, it gets trimed.

----- Developer Notes -----

MySQL Workbench CE for Linux/Unix version 5.2.41  revision 9727
Configuration Directory: /home/pgauna/.mysql/workbench
Data Directory: /usr/share/mysql-workbench
Cairo Version: 1.10.2
OS: Linux 3.2.0-27-generic
CPU: 4x Intel(R) Core(TM) i3-2100 CPU @ 3.10GHz 1600.000 MHz, 3,8 GB RAM
Distribution: Ubuntu 12.04 LTS

How to repeat:
Create a table with a longtext field.
Copy some long text
Paste into the field
Copy back and you can see that a lot of text is missed
[27 Jul 2012 13:37] Alfredo Kojima 
Can you attach a screenshot so we can have an idea about context?
[27 Jul 2012 14:13] Pedro Gauna 
This is the table description, note that 'texto' field is a longtext field

Attachment: table_description.png (image/png, text), 35.72 KiB.
[27 Jul 2012 14:14] Pedro Gauna 
The query shows the data length and the last part of the string in it

Attachment: table_full_data.png (image/png, text), 32.67 KiB.
[27 Jul 2012 14:16] Pedro Gauna 
The screenshot shows the result of copying text and pasting it in a text editor, note that the end of the string is no the same

Attachment: table_copy_paste.png (image/png, text), 58.79 KiB.
[27 Jul 2012 19:11] Johannes Taxacher 
verified in linux and windows. while in windows, one can still use the "open in editor" feature to add larger amount of text, on linux WB keeps truncating the contentlength to ~65kb
[27 Dec 2012 16:54] Alfredo Kojima 
This is a limitation in GTK, apparently there's a 64k limit in edited text fields. The popup full value editor should be used in such cases. A workaround where an error will be shown in case a big field value is attempted to be edited inline will be shown.
[3 Feb 2015 6:02] Philip Olson 
Posted by developer:
 

Fixed as of the upcoming MySQL Workbench 6.2.5 release, and here's the changelog entry:

Due to "result grid" size limitations (e.g., 64k with GTK on Linux), the
text there is truncated at some point. Now, an error is generated if the
entered text will be truncated. 

To enter long text using the GUI, click "Open Value in Editor" from a 
fields context menu to open an editor window.

Thank you for the bug report.
[25 Mar 2015 9:15] Rumata Estorsky 
Solution is bad: this errors appears on enter of any non-latin character.