Bug #6691 mysql crashes when using mysqlimport or LOAD DATA INFILE
Submitted: 17 Nov 2004 23:29 Modified: 18 Dec 2004 22:50
Reporter: Brandon Walts Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server: Command-line Clients Severity:S2 (Serious)
Version:4.1.7-standard OS:Other (IRIX 6.5 IP27)
Assigned to: CPU Architecture:Any

[17 Nov 2004 23:29] Brandon Walts 
Description:
When attempting to import a text file using the mysqlimport command line tool, or using LOAD DATA INFILE, mysql crashes.  These crashes happen when a field delimiter of "|" (the UNIX pipe symbol) or "||" is used.  It doesn't seem to happen when a field delimiter of "," or ":" is used, or when no field delimiter is specified.

This crash happens regardless of whether or not the --local flag is set (for mysqlimport) or whether or not LOAD DATA LOCAL INFILE is used

This was not an issue with version 4.0.20.  It seems to have appeared somewhere between version 4.0.20 and version 4.1.7

How to repeat:
mysqlimport --fields-terminated-by="||" -u root -p Alleles.txt

results in

/usr/local/mysql41/bin/mysqlimport: Error: Lost connection to MySQL server during query, when using table: Alleles

and checking the mysql server stats shows that it restarted

Suggested fix:
Update the documentation to say that "|" is an illegal field delimiter.

Better figure out what caused this problem to appear between version 4.0.20 and 4.1.7
[18 Nov 2004 22:50] MySQL Verification Team 
Hi,

Thank you for the report, but I wasn't able to repeat it with my test data.
Could you upload the table, file that you use in the LOAD DATA and LOAD DATA statement?
[14 Feb 2005 22:54] Bugs System 
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".