If the LOAD DATA process found a line with an escape character followed by UTF8 characters, then the process failed to load the line and any additional lines. This issue was a regression.
General
Escalation
General
Escalation
Description
Environment
None
AFFECTED CS IDs
274680
Attachments
1
Smart Checklist
Activity
Show:
Przemyslaw Skibinski April 6, 2020 at 10:54 AMEdited
I submitted a patch for 5.6.47 at https://bugs.mysql.com/bug.php?id=98089
It's based on https://github.com/mysql/mysql-server/commit/ac64a647
Done
Details
Details
Assignee
Przemyslaw SkibinskiReporter
Przemyslaw MalkowskiLabels
Upstream Bug URL
Time tracking
4h 45m logged
Fix versions
Affects versions
Priority
MediumSmart Checklist
Open Smart Checklist
Smart Checklist
Open Smart Checklist
Created March 26, 2020 at 3:37 PM
Updated March 6, 2024 at 11:14 AM
Resolved April 7, 2020 at 10:23 AM
Since 5.6.45 onwards, LOAD DATA with specific utf8 characters silently fails.
Test case for affected version:
Forcing latin1 db charset make the data to load, but it gets corrupted:
The same test for non-affected version: