Bug #2742 fields-escaped-by only allows single character separator!

• Submitted: 12 Feb 2004 6:25
• Modified: 28 Feb 2007 23:24
• Reporter: Are you mortal? Then prepare to die.
• Status: Verified
• Category: Client
• Severity: S3 (Non-critical)
• Version: mysqlimport Ver 2.8
• OS: Any (3.23.58 RH linux gnu i386)
• Assigned to: Georg Richter
• Triage: Triaged: D4 (Minor)

[12 Feb 2004 6:25] Are you mortal? Then prepare to die.

Description:

mysqlimport --fields-escaped-by='\t\|\t' ncbi_taxonomy ../division.dmp

mysqlimport: Error: Field separator argument is not what is expected. 
Check the manual, when using table: division

Sadly this unusual field separator is in use by the NCBI in some of their flat file
dumps. 

mysqlimport doesn't allow any field separator with more than a single character, which is
a silly restriction really.

How to repeat:
See above

Suggested fix:
Allow multi character field separator, like the record separator!

[25 Dec 2006 11:18] Sveta Smirnova

Thank you for the report.

But problem is not field separator which can be any value, but incorrect error message
which names field escape symbol "field separator"