Bug #42059 Enclosure characters cause data to large for field error

• Submitted: 12 Jan 2009 19:06
• Modified: 12 Feb 2009 20:06
• Reporter: Brendan Putek
• Status: No Feedback
• Category: MySQL Server: DML
• Severity: S3 (Non-critical)
• Version: 5.1.24-rc-community-log
• OS: Any
• CPU Architecture: Any
• Tags: data, enclosed, load, varchar

[12 Jan 2009 19:06] Brendan Putek

Description:
When doing a Load Data Infile into a varchar field mysql counts the enclosure characters on the data before stripping them when determining if the data fits into the field length.

How to repeat:
Load a string with a length of 255 into a varchar(255) and enclose it in the enclosure character for the Load Data Infile statement.

Suggested fix:
Strip the enclosure field before determining if the data will fit into the field.

[12 Jan 2009 20:06] Valeriy Kravchuk

Thank you for a problem report. Please, try to repeat with a newer version, 5.1.30, and, in case of the same problem, please, provide a complete test case, with exact CREATE TABLE and LOAD DATA statements.

[13 Feb 2009 0:00] 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".