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

[27 Jul 2005 6:10] Mario Esteves
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.
[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"

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.049 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.