Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
None
-
None
-
None
-
None
-
Windows
Description
LOAD DATA LOCAL query fails to import all rows. It fails after importing first row and shows warning "Data truncated for column 'c' at row 1".
It was working fine till revision 79.
Here are the details:
Table Structure:
CREATE TABLE `csv_table` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
`c` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1
LOAD LOCAL QUERY:
LOAD DATA LOCAL INFILE 'C:\\Users\\XYZ\\Desktop
sample.csv' INTO TABLE `csv_db`.`csv_table` FIELDS ESCAPED BY '
' TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\r\n' (`a`, `b`, `c`);
sample.csv attached here.