[CASSANDRA-6172] COPY TO command doesn't escape single quote in collections

• Type: Bug
• Status: Resolved
• Priority: Low
• Resolution: Fixed
• Fix Version/s: 1.2.13, 2.0.4
• Component/s: Legacy/Tools

Environment

Cassandra 2.0.1, Linux

• Severity: Low
• Assignee: Mikhail Stepura
• Reporter: Ivan Mykhailov

Authors

Mikhail Stepura

Reviewers

Aleksey Yeschenko

• Created: 09/Oct/13 10:51
• Updated: 16/Apr/19 09:32
• Resolved: 24/Nov/13 18:58

Description

CREATE TABLE test (key text PRIMARY KEY , testcollection set<text>) ;
INSERT INTO test (key, testcollection ) VALUES ( 'test', {'foo''bar'});
COPY test TO '/tmp/test.csv';
COPY test FROM '/tmp/test.csv';

Bad Request: line 1:73 mismatched character '<EOF>' expecting '''
Aborting import at record #0 (line 1). Previously-inserted values still present.

Content of generated '/tmp/test.csv':

test,{'foo'bar'}

Unfortunately, I didn't find workaround with any combination of COPY options