Bug #63606 WB hangs on Open Value in Viewer in SQL Editor for long text field
Submitted: 5 Dec 2011 15:57 Modified: 23 Dec 2011 20:18
Reporter: Bob Dankert Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S2 (Serious)
Version:5.2.36 OS:Windows (W7 64, XP)
Assigned to: CPU Architecture:Any
Tags: editor, Open Value, regression, slow, viewer

[5 Dec 2011 15:57] Bob Dankert
Description:
The new MySQL Workbench 5.2.36 is extremely slow when using the Open Value in Viewer for large text fields.  For a text field that is 65,535 bytes in length, it took 154 seconds (2 minutes, 34 seconds) for WB to open the field viewer.  At first I thought the program was locked up and crashed, and was submitting a bug for that, but while writing the bug the window popped open.  I have tried several times since and can verify that it indeed takes just over 2 and a half minutes to open this window, for what is relatively not that much information.

How to repeat:
Open value in viewer for a text field with a lot of information

Suggested fix:
Open quickly
[5 Dec 2011 16:20] MySQL Verification Team
Could you please provide the output of Help->System Info. Thanks.
[5 Dec 2011 16:23] Bob Dankert
System Info:
MySQL Workbench CE for Windows version 5.2.36  revision 8542
Configuration Directory: C:\Users\<username>\AppData\Roaming\MySQL\Workbench
Data Directory: C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE
Cairo Version: 1.8.8
Rendering Mode: OpenGL is available on this system, so OpenGL is used for rendering.
OpenGL Driver Version: 2.1.8874
OS: Microsoft Windows 7 Ultimate Edition Service Pack 1 (build 7601), 64-bit
CPU: 2x Intel(R) Core(TM)2 Duo CPU     P8400  @ 2.26GHz, 3.9 GiB RAM
Active video adapter (0): ATI Mobility Radeon HD 3650
Installed video RAM: 256 MB
Current video mode: 1280 x 800 x 4294967296 colors
Used bit depth: 32
Driver version: 8.641.1.1000
Installed display drivers: atiumd64.dll,atidxx64.dll,atiumdag,atidxx32,atiumdva,atiumd6a.cap,atitmm64.dll
Current user language: English (United States)
[5 Dec 2011 17:12] Valeriy Kravchuk
Yes, it took me more than 60 seconds on Windows XP to open value that is inserted as repeat('a', 66000) into longtext column as Text. it is opened instantly in hex form. 

Also this looks like platform-specific bug, as I do not see this problem on Mac OS X.
[23 Dec 2011 20:18] Philip Olson
Fixed as of 5.2.37:
The field editor would hang when large text values were shown.