Comment 0 for bug 1025347

Revision history for this message
Christoffer Sawicki (qerub) wrote :

# 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 \.)