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
• Status: Not a Bug
• Category: MySQL Server: Command-line Clients
• Severity: S2 (Serious)
• Version: 5.0.38
• OS: Any (any)
• 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.