Bug #12195 Use system EOL in 'LOAD DATA INFILE' and 'SELECT .. INTO OUTFILE'
Submitted: 27 Jul 2005 6:10 Modified: 26 Oct 2008 9:36
Reporter: Mario Esteves Email Updates:
Status: Verified Impact on me:
Category:MySQL Server Severity:S4 (Feature request)
Version:4.1.12a-nt OS:Windows (Microsoft Windows 2000)
Assigned to: CPU Architecture:Any

[27 Jul 2005 6:10] Mario Esteves
I think this is not a real bug, but the version ported to Microsoft Windows uses the unix standard '\n' line feed.

Microsoft Windows uses '\r\n', so every 'LOAD DATA' function needs the LINES TERMINATED BY '\r\n' to correct this.

How to repeat:
Export a CSV file(with Microsoft Excel or something like) and load with 'LOAD DATA INFILE', the last column is terminated with the '\r' character.

Suggested fix:
I think there is a way to detect if the compiler is  a windows compiler and change the line feed variable.

Sorry my English.
[26 Oct 2008 9:36] Sveta Smirnova
Thank you for the report.

Although user manual is clear about current behavior: "If you specify no LINES clause, the defaults are the same as if you had written this: LINES TERMINATED BY '\n' STARTING BY '' " (http://dev.mysql.com/doc/refman/5.0/en/load-data.html) I mark this feature request as "Verified"