MySQL Bugs: #12195: Use system EOL in 'LOAD DATA INFILE' and 'SELECT .. INTO OUTFILE'

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:	None
Category:	MySQL Server	Severity:	S4 (Feature request)
Version:	4.1.12a-nt	OS:	Windows (Microsoft Windows 2000)
Assigned to:		CPU Architecture:	Any

Description:
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.

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"