MySQL Bugs: #98089: Fail to load data with "\様"

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

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.

The data file for issue reproduction

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

Hello Cai Vincent,

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

Thanks,
Umesh

5.6.47 patch based on https://github.com/mysql/mysql-server/commit/ac64a647

Attachment: 98089_56.patch (text/x-patch), 6.25 KiB.