Bug #54492 "load data local infile" crashed MySql Workbench
Submitted: 14 Jun 2010 18:13 Modified: 16 Jun 2010 13:29
Reporter: Austin Kalb Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S2 (Serious)
Version:5.2.22 OS:Any
Assigned to: CPU Architecture:Any
Tags: crash, load

[14 Jun 2010 18:13] Austin Kalb 
Description:
Trying to run this statement:

load data local infile 'iSTocks2.csv' into table `iTrader`.`Stocks`
fields terminated by ','
enclosed by '"'
lines terminated by '\n'
(symbol);

Against this table:

CREATE  TABLE IF NOT EXISTS `iTrader`.`Stocks` (
  `idStocks` INT NOT NULL AUTO_INCREMENT ,
  `symbol` VARCHAR(45) NOT NULL ,
  `MovingAverage10Day` DECIMAL NULL ,
  `Volatility10Day` DECIMAL NULL ,
  `AverageVolume30Day` MEDIUMTEXT  NULL ,
  PRIMARY KEY (`idStocks`) ,
  INDEX `Symbol` (`symbol` ASC) ,
  UNIQUE INDEX `symbol_UNIQUE` (`symbol` ASC) )
ENGINE = InnoDB;

Using this data:

"TACT."
"ISSC."
"IIG."
"UHAL."

Consistantly crashes MySql Workbench

How to repeat:
See above.
[15 Jun 2010 12:18] MySQL Verification Team 
Thank you for the bug report. Which server version are you using?.
[15 Jun 2010 13:26] Austin Kalb 
Server: 5.1.47-community MySQL Community Server (GPL) running on Windows 2003
[16 Jun 2010 13:29] Alfredo Kojima 
This is a duplicate of bug #49694, which unfortunately is in an underlying library.