Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Duplicate
-
1.0.8
-
None
-
Debian GNU/Linux 8.7 (jessie)
Description
A character delimited file (eg. tab or comma) containing a literal \ character and a \ escape character (ie. E\\) causes inconsistent behavior between
|
--Server version: 10.1.18-MariaDB-1~jessie mariadb.org binary distribution
|
--Server version: 10.1.22-MariaDB Columnstore 1.0.8-1
|
when using LOAD DATA.
|
|
The value in question: E\\ (the actual value is E\), causes the MCS loader to throw an exception, complaining about a field count violation.
|
|
In 10.1.18-MariaDB the load command without specifying a FIELDS clause works fine (defaults) the string E\ gets inserted.
|
In 10.1.22-MariaDB Columnstore 1.0.8-1 the load command without specifying a FIELDS clause causes a field count violation. However, adding the following -empty- FIELDS clause: ESCAPED BY '', works fine and inserts the E\ string.
|
|
PS. Also inserting the string NULL is inconsistent. Non MCS requires, as we all know, the [OPTIONALLY] ENCLOSED BY to not be empty to interpret the NULL string as a NULL value. For MCS this is not necessary.
|
Attachments
Issue Links
- duplicates
-
MCOL-877 Not all data escaped when inserting with select statement from innodb table into columnstore
- Closed