2012-07-25 19:55:50 |
Christoffer Sawicki |
description |
# How to reproduce
1. SELECT NULL INTO OUTFILE 'example.tbl' FIELDS TERMINATED BY ',' ENCLOSED BY '"' ESCAPED BY 'X';
2. CREATE TABLE examples (example varchar(24)) ENGINE=InfiniDB;
3. /usr/local/Calpont/bin/cpimport test examples -s , -E \" -C X /usr/local/Calpont/mysql/db/test/examples.tbl
4. SELECT * FROM examples
# Expected result
+---------+
| example |
+---------+
| NULL |
+---------+
# Actual result
+---------+
| example |
+---------+
| XN |
+---------+
# Explanation
cpimport doesn't interpret XN as NULL even though the escape character is set to X. (The behaviour is correct if the escape character is \.) |
# How to reproduce
1. SELECT NULL INTO OUTFILE 'examples.tbl' FIELDS TERMINATED BY ',' ENCLOSED BY '"' ESCAPED BY 'X';
2. CREATE TABLE examples (example varchar(24)) ENGINE=InfiniDB;
3. /usr/local/Calpont/bin/cpimport test examples -s , -E \" -C X /usr/local/Calpont/mysql/db/test/examples.tbl
4. SELECT * FROM examples
# Expected result
+---------+
| example |
+---------+
| NULL |
+---------+
# Actual result
+---------+
| example |
+---------+
| XN |
+---------+
# Explanation
cpimport doesn't interpret XN as NULL even though the escape character is set to X. (The behaviour is correct if the escape character is \.) |
|