MySQL Bugs: #60477: Running script to load data file causes "Unexpected Error"

Bug #60477	Running script to load data file causes "Unexpected Error"
Submitted:	15 Mar 2011 15:23	Modified:	27 Apr 2011 17:05
Reporter:	Troye Kauffman	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Utilities	Severity:	S3 (Non-critical)
Version:	5.2.33	OS:	Windows (7 - Enterprise)
Assigned to:		CPU Architecture:	Any

Description:
Here is the script:

LOAD DATA LOCAL INFILE 'C:\logs\output\test\DelimitedICMP.txt' INTO TABLE VLANICMP TERMINATED BY '|'
(`VLANICMP`.`idVLANICMP`, `VLANICMP`.`LogLine`, `VLANICMP`.`LogNum`, `VLANICMP`.`DateAndTime`, `VLANICMP`.`Firewall`, `VLANICMP`.`FWAction`, `VLANICMP`.`InterfaceIn`, `VLANICMP`.`InterfaceOut`, `VLANICMP`.`SourceIP`, `VLANICMP`.`DestIP`, `VLANICMP`.`IPPacketLength`, `VLANICMP`.`TypeOfService`, `VLANICMP`.`TOSPrecedence`, `VLANICMP`.`TimeToLive`, `VLANICMP`.`DatagramID`, `VLANICMP`.`Protocol`, `VLANICMP`.`Type`, `VLANICMP`.`OtherFlags`)

How to repeat:
Running it from Workbench Scripting Shell

Please, send the results of:

show create table VLANICMP\G

and send some sample file to load data from (that demonstrates the crash).

When I tried running this command: 
show create table VLANICMP\G

It also caused the same problem:

"MySQL Workbench has encounter a problem
External component has thrown an exception."

What exact version of Workbench, 5.2.x, do you use?

Using Workbench 5.2.32CE, Revision 7496

Could you please try version 5.2.33. Thanks.

That seemed to fix the previous problem, however now I'm seeing the following:

>>> show create table VLANICMP\G;
Traceback (most recent call last):
  File "<string>", line 1, in <module>
NameError: name 'grtV' is not defined

Thank you,
Troye Kauffman

Please, execute:

show create table VLANICMP\G

in the mysql command line client and send the results.

Do you have any Python version installed?

Valeriy,

Please see my previous entry - the latest error received WAS from executing "show create table VLANICMP\G".  I don't have Python installed.

Thank you,
Troye

Had you noted "in the mysql command line client" in my request? 

I've got it that in Workbench this does not work, but I still need table structure to create a complete repeatable test case.

I used the mysql executable from a DOS prompt because the scripting shell from within the workbench did not work.

mysql> show create table VLANICMP\G
*************************** 1. row ***************************
       Table: VLANICMP
Create Table: CREATE TABLE `vlanicmp` (
  `idVLANICMP` int(11) NOT NULL,
  `LogLine` int(11) DEFAULT NULL,
  `LogNum` int(11) DEFAULT NULL,
  `DateAndTime` varchar(45) DEFAULT NULL,
  `Firewall` varchar(45) DEFAULT NULL,
  `FWAction` varchar(10) DEFAULT NULL,
  `InterfaceIn` varchar(15) DEFAULT NULL,
  `InterfaceOut` varchar(15) DEFAULT NULL,
  `SourceIP` varchar(45) DEFAULT NULL,
  `DestIP` varchar(45) DEFAULT NULL,
  `IPPacketLength` int(11) DEFAULT NULL,
  `TypeOfService` varchar(15) DEFAULT NULL,
  `TOSPrecedence` varchar(15) DEFAULT NULL,
  `TimeToLive` int(11) DEFAULT NULL,
  `DatagramID` int(11) DEFAULT NULL,
  `Protocol` varchar(15) DEFAULT NULL,
  `Type` int(11) DEFAULT NULL,
  `OtherFlags` varchar(345) DEFAULT NULL,
  PRIMARY KEY (`idVLANICMP`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1
1 row in set (0.00 sec)

mysql>

Could you please provide a test sample of DelimitedICMP.txt (attaching it with Files tab). Thanks.

Please close this ticket.

Let's consider this a duplicate of Bug #60977. Workbench should not crash/output "Unexpected error" no matter what code user tried to execute in scripting shell.