Bug #53186 SQL Text Editor in Forward Engineer DB wizard cannot accept > 32768 characters
Submitted: 27 Apr 2010 8:01 Modified: 3 Jun 2010 9:17
Reporter: Marc Walters Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S2 (Serious)
Version:5.2.19 OS:Windows (XP 32-bit)
Assigned to: CPU Architecture:Any
Tags: Edit, forward engineer, paste, sql editor, text

[27 Apr 2010 8:01] Marc Walters
Description:
The intention was to move a SQL DB from a remote WWW server to a local development platform using the Forward Engineer DB wizard of MySQL Workbench.

STEPS
1) A database backup (SQL format) was obtained, loaded into Workbench and a model created. 
2) Forward Engineer Database wizard was launched (Main Menu:Database|Forward Engineer...)
3) At screen 4 (Review SQL Script) modifications had to be made. However, text could be deleted but not added. I experimented and it became apparent that although the generated SQL can exceed 32768 bytes, no text can be manually added. ie pasting from clipboard (CTRL-V) and any alpha-numeric keys fail.

If the text is less than 32768 characters then editing proceeds as expected.

I have not been able to find a workaround in MySQL Workbench, nor any setting in Preferences.

How to repeat:
1) Create a new database then select Main Menu:Database|Forward Engineer...
2) Step through to the Review SQL Script page
3) Paste in the contents of text file (any will do) that exceeds 32768 characters
3) The text that was pasted in will be truncated to 32768 characters. Place the insertion point/cursor in the body of text and try to type. No text ensues
4) Delete a few characters
5) Type some characters. The exact amount of chars can be entered that were deleted

Suggested fix:
Allow more than 32768 chars to be editable. Perhaps a 16-bit string datatype is being used on the editor form?
[29 Apr 2010 12:09] Susanne Ebrecht
Many thanks for writing a bug report.

I am not able to repeat this on Linux with Workbench 5.2.20.

Please try Workbench 5.2.20 here.
[29 Apr 2010 13:03] Susanne Ebrecht
This could be related to bug #53127.

Which means this could be related to Windows.
[30 Apr 2010 0:02] Marc Walters
The 32768 char editing limit persists on Workbench 5.2.20.
[3 May 2010 9:17] Johannes Taxacher
While it's possible to edit the generated code in the "review script" step in fwd eng. wizard, its not actually recommended to use that functionality. changes to the database schema should be made to the document objects using the editors provided.
could you maybe provide your script/model ( you can mark it as private, so only internal devs can access it) and explain the "changes" that you wanted to make at this step?
thanks in advance
[3 Jun 2010 23:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".