Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Won't Fix
-
1.0.11
-
CentOS 7
Description
CREATE TABLE escape_inno
(
id int AUTO_INCREMENT PRIMARY KEY,
sVal varchar(50),
createDate datetime
) ENGINE=INNODB DEFAULT CHARSET utf8;
CREATE TABLE escape_columnstore
(
id int NOT NULL,
sVal varchar(50),
createDate datetime
) ENGINE=columnstore DEFAULT CHARSET utf8 COMMENT='autoincrement=id';
LOAD DATA INFILE '/mnt/data/testEscape.asc.data1' INTO TABLE escape_inno CHARACTER SET UTF8; – GOOD: transform per 2 "\" to a "\"
LOAD DATA INFILE '/mnt/data/testEscape.asc.data1' INTO TABLE escape_columnstore CHARACTER SET UTF8; – BAD: transform per 4 "\" to a "\"