Bug #26733 '\r' in the text data in INSERT statement causes client to reconnect
Submitted: 28 Feb 2007 20:15 Modified: 1 Mar 2007 9:46
Reporter: Victoria Reznichenko Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server: Command-line Clients Severity:S2 (Serious)
Version:5.0.38 OS:Any (any)
Assigned to: CPU Architecture:Any

[28 Feb 2007 20:15] Victoria Reznichenko
Description:
If you have somewhere in text '\r' in multi-row INSERT statement it causes command-line client to recoonnect with the following error:

$ ./bin/mysql test < /home/vita/dump.sql
ERROR 2005 (HY000) at line 67: Unknown MySQL server host 'for' (1)

It happens only with huge multi-row INSERT statements and I wasn't able to reproduce this error with less test case.

How to repeat:
Try to restore uploaded file.
[28 Feb 2007 20:19] Victoria Reznichenko
File bug26733.sql.bz2 uploaded to MySQL FTP.
[1 Mar 2007 9:46] Sergei Golubchik
The dump is corrupted.