Description:
LOAD DATA LOCAL INFILE 'VBKD.CSV' replace INTO TABLE VBKD FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' IGNORE 0 LINES(`VBELN`,`POSNR`,`KURSK`,`BSTKD`,`BSTKD_E`,`BSTDK`,`FKDAT`);
If a field is enclosed by " and there is a space between the closing " and ;
e.g. ;"GRIEKSPOOR" ;
the load is terminated after the line is loaded.
How to repeat:
use test;
CREATE TABLE IF NOT EXISTS VBKD (`VBELN` CHAR(10),`POSNR` DECIMAL(6),`KURSK` DECIMAL(9,5),`BSTKD` CHAR(35),`BSTKD_E` CHAR(35),`BSTDK` DATE,`FKDAT` DATE
,primary key (`VBELN`,`POSNR`));
truncate table VBKD;
LOAD DATA LOCAL INFILE 'VBKD.CSV' replace INTO TABLE VBKD FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' IGNORE 0 LINES(`VBELN`,`POSNR`,`KURSK`,`BSTKD`,`BSTKD_E`,`BSTDK`,`FKDAT`);
loading the following infile will terminate after 2 rows, not 4!
0000050822;000000;1.00000;652404 ;66310304 ;20040324;20040324
0000050823;000000;1.00000;652406 ;"GRIEKSPOOR" ;20040324;20040324
0000050824;000000;1.00000;652408 ; ;20040324;20040324
0000050825;000000;1.00000;652407 ;1501204725 ;20040324;20040324