MySQL Bugs: #33095: Table/Inserts can not handle many INSERT statements

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:	None
Category:	MySQL Workbench	Severity:	S3 (Non-critical)
Version:	5.0.10 OSS Beta 2272	OS:	Any
Assigned to:		CPU Architecture:	Any

Description:
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.

Thank you for the report.

Verified as described.

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.