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.
It seems that 'Windows Linebreaks' (\r\n) are broken in revision 80 with LOAD DATA LOCAL.
Please also observe that "LINES TERMINATED BY" can specify any character sequence.
It is not restricted to 'visual linebreaks' (neither Linux, Windows nor Mac -style) actually.