Bug #33095 Table/Inserts can not handle many INSERT statements
Submitted: 9 Dec 2007 11:50 Modified: 19 Dec 2013 18:47
Reporter: Srdjan Dakic Email Updates:
Status: Closed Impact on me:
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:5.0.10 OSS Beta 2272 OS:Any
Assigned to: CPU Architecture:Any

[9 Dec 2007 11:50] Srdjan Dakic
We have table with IP addresses and country codes. 

It currently contains 605 INSERT statements and script is 56 KB when saved in a separate file. 

It simply can not fit into textbox of Table/Inserts.

How to repeat:
INSERT INTO fm_geo_ip (ip_from, ip_to, country_code2) VALUES (3590157760, 3590157775, 'RS');
INSERT INTO fm_geo_ip (ip_from, ip_to, country_code2) VALUES (3590158440, 3590158455, 'SI');
INSERT INTO fm_geo_ip (ip_from, ip_to, country_code2) VALUES (3641626624, 3641630719, 'HR');

Copy/paste these 3 lines and make script of ~640 lines. Then paste entire code to Table/Inserts. You will notice that last line has been cut in half.

Suggested fix:
Do not limit insert textbox input size.
[9 Dec 2007 12:23] Sveta Smirnova
Thank you for the report.

Verified as described.
[7 Jan 2008 19:13] Johannes Taxacher
from version 5.0.11 Workbench offers a Grid-editor for default-data insertation. manual entry/editing of inserts is disabled at the moment.
It will be re-enabled when the parsing of the text-entered/edited is fully implemented.