Bug #98089 Fail to load data with "\様"
Submitted: 28 Dec 2019 12:44 Modified: 28 Dec 2019 13:03
Reporter: Cai Minshen Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Command-line Clients Severity:S3 (Non-critical)
Version:5.6, 5.6.46, 5.6.45 OS:Any
Assigned to: CPU Architecture:Any
Tags: regression

[28 Dec 2019 12:44] Cai Minshen
Description:
Load data to MySQL V5.6. If there is one line which contains "\様" in the data file, then it fails to load that line and  the following ones.

Note:
1) It is a regression. I encountered this issue on V5.6.35 & V5.6.46. It works fine on V5.6.44
2) It works fine on V5.7 

How to repeat:
create table test (name varchar(80)) charset = utf8
set names utf8;
set character_set_database = utf8;
set character_set_server=utf8;

LOAD DATA LOCAL INFILE 'C:\\Users\\micai\\Downloads\\test.csv'
REPLACE INTO TABLE test
FIELDS TERMINATED BY ',' ENCLOSED BY '\''
LINES TERMINATED BY '\r\n'
IGNORE 1 ROWS;

Please refer to the data file from the attach. It only load 11 rows instead of the expected 12 rows.
[28 Dec 2019 12:45] Cai Minshen
The data file for issue reproduction

Attachment: test.csv (application/vnd.ms-excel, text), 331 bytes.

[28 Dec 2019 13:03] Umesh Shastry
Hello Cai Vincent,

Thank you for the report and test case.
Observed that 5.6.46 release build is affected.

Thanks,
Umesh